Go back to the home page
Information about CITE
Information about Web-based Training
CITE's course offerings
Register for a CITE course
CITE's Partner program
 
Contact CITE
 
 
 

 

 

Fundamentals of Database Management Systems - Instructor-led, Web-based ("Blended") Version

Author

Brian Smith
University of Virginia

 

Description

Database management systems play an essential role in most modern transportation management, administrative, and control systems. Therefore, transportation professionals are often responsible for making design, development, operations, and maintenance decisions concerning database management systems. In addition, many transportation professionals are users of database management systems to support their responsibilities. Clearly, in order to effectively accomplish their mission, transportation professionals do not need to be database experts. However, a basic understanding of database management systems has become important.

This course emphasizes the importance of database design, use, and management to ITS. The module begins with a general description of databases and database management systems, including the relationships that exist among a database, a DBMS, and an application. Relational database tables, Entity-Relationship Models, and the role of metadata are discussed in detail. Finally, the module describes SQL, and explores the role of databases in data warehousing and Geographic Information Systems.

 

What is an Instructor-led, Web-based course?

A “blended” course combines the best features of both instructor-led and web-based instruction. These features include:

  • Live discussions with the instructor through the use of conference calls,
  • Convenient, flexible web-based learning,
  • A specific time schedule in which to complete the course, and
  • Interaction with other students through the use of class problems posted on a discussion board.

Course Objectives

Upon completion of the course, participants will be able to:

  • Explain how databases work
  • Describe how databases are designed
  • Recall how to work with databases to support decision making
  • Relate how databases are used for advanced applications, namely data warehousing and geographic information systems (GIS)

 

Audience

Transportation professionals who are ultimately responsible for the design, procurement, and operations of transportation systems that rely heavily on database management systems. The course is not intended for individuals with extensive database backgrounds, nor is it intended for individuals seeking to learn the "mechanics" of using a particular database package.

 

Length

8 hours.

 

Course Outline

    Lesson 1. DATABASES AND DBMSs

    Databases
    The Database Management System (DBMS)
    Relationships
    DBMS Roles in ITS
    Big Data
    What Do You Need To Know

    Lesson 2. HOW DATABASES WORK

    Why Use a Database?
    What Is a Relational Database?
    Relational Database Structure
    Relational Database Table Relating Tables with Keys
    Normalizing Databases
    Relational Database Tutorial
    Workshop #1

    Lesson 3. DATABASE DESIGN

    Requirements
    Entity-Relationship Models
    Entity-Relationship (ER) Diagram
    Entity and Attributes
    Sample ER Diagram
    Workshop #2
    Relationships and Diagramming
    Relationship Examples
    Designing Databases with an ER Diagram
    Database Documentation/Metadata
    Workshop #3

    Lesson 4. STRUCTURED QUERY LANGUAGE (SQL)

    Structured Query Language
    SQL Functions
    More about SQL

    Lesson 5. DATA WAREHOUSE

    Data Warehouse and Components
    ITS Data Warehouse
    Key Issues Related to ITS Data Warehouse
    Strengths of Data Warehousing in ITS
    Weaknesses of Data Warehousing in ITS

    Lesson 6. GEOGRAPHIC INFORMATION SYSTEM (GIS)

    What Is GIS?
    Representing Spatial Location in a Database
    Spatial Coordinate Systems

 

Course Syllabus

 

>See Course Syllabus

   

 

 

 

 

 

 

   
Click to send mail to CITE