Database Management

Relational Database Management

An understanding of the design of client-relational databases is vital to system design and implementation. This course provides an overview of relational database technology, data modeling, SQL, data normalization, and the translation of logical designs to physical storage structures. Other concepts introduced include indexes, storage management, transactions, database integrity, concurrency control, recovery, an overview of client/server relational database management, and an introduction to query optimization.

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.

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)

Study techniques for creating and using database applications in depth. You learn requirements analysis and specification; logical database design; normalization; implementing the databases; recovery, concurrency, integrity, and security concerns; and using the database. The course curriculum focuses mainly on the relational database model and SQL.

Gain expertise exploring and using new features in PowerDesigner 15.0. Learn how to manage user profiles, implement projects and define custom frameworks. Work with the new Enterprise Architecture model and Impact Analysis model. Understand the changes to the Repository and learn how to setup the new Repository Web Browser.

Course Objectives :
Upon completion of this course, you will be able to:
Create and implement User Profiles
Implement Projects and Frameworks
Integrate Enterprise Architecture with Existing Models
Discuss the New Features in the Core Modules in PowerDesigner

Course Topics:

Managing User Profiles
Introduction to Projects and Frameworks
Enterprise Architecture Model
Impact Analysis Model
Updates to Data Models, Business Process Models and Object Oriented Models
New Features for Extended Model Definitions
Repository Updates and Web Browser

Pages:- 1 2 3 4 5 6 7 8
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>