| Course Code: |
DEV 325 |
| Course Abstract: |
In this course, participants learn how PowerDesigner 11.0 can be used as a tool during the data analysis, data modeling, and database design processes. A well-known “best practice” in Information Engineering (IE) is to model the information at both a conceptual and physical level. Participants will learn to use PowerDesigner to create a conceptual data model with entities, attributes, and relationships. They will learn to target a DBMS, generate and enhance a physical data model, and then generate a database creation script for database tables, indexes, views, triggers, and stored procedures. Attendees will explore the reverse engineering features of PowerDesigner to create physical, conceptual, and object-oriented models from an existing database, as well as learn iterative modeling by using compare and merge model features and synchronizing physical data models with corresponding databases and vice versa. Finally, attendees will learn how to use and mange the Enterprise Repository for storing and sharing enterprise models across disparate groups and locations.
This course is 40% Lecture and 60% Labs. |
| Audience: |
This course is designed for Data analysts, Data modelers, Database administrators, Systems analysts, and Application Developers with data modeling responsibilities. |
| Duration: |
3 days |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
> Create and manage conceptual data models
> Generate and manage physical data models
> Generate database creation scripts
> Produce implementation details, such as triggers, procedures, and views
> Reverse engineer an existing database to create physical, conceptual, and object-oriented models
> Compare and merge models
> Synchronize physical data models with databases
> Manage large models and multiple designers using MetaWorks
> Create effective reports on PowerDesigner models |
| Course Topics: |
Introduction to data modeling with PowerDesigner
Using the PowerDesigner modeling environment
Creating and managing a conceptual data model
Defining business rules
Creating data items, entities, and entity attributes
Creating and defining relationships
> Cardinality
> Dependency
> Roles
> Existence
Defining and using domains and inheritance
Generating a physical data model
Transforming CDM objects to PDM objects
Customizing the physical data model
Creating views, alternate keys, and indexes
Creating the database script
Protecting data through triggers, procedures, views, and business rules
Reverse engineering databases
Model management techniques
Physical data model synchronization
Working with packages and diagrams
Working with the Enterprise Repository
Creating reports |
| Prerequisites: |
Experience using Microsoft Windows™ or another graphical user interface, understanding of relational database concepts and database implementation issues, and exposure to entity relationship (ER) data modeling and data normalization is required. |