Data Modeling with PowerDesigner 15

Goals

• 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 you PowerDesigner models

Audience

• This course is designed for individuals who are responsible for designing, implementing, and managing relational databases, including: Data analysts, Data modelers, Database administrators, Systems analysts, Application Developers with data modeling responsibilities

Prerequisites

• Understanding of relational database concepts and database implementation issues, Exposure to entity relationship (ER) data modeling and data normalization.

Content

• 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 rule
• Reverse engineering databases
• Model management techniques
• Links to Requirements models
• Physical data model synchronization
• Working with packages and diagrams
• Working with the Enterprise Repository
• Creating reports

Notes

• Learn how PowerDesigner 15.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 the conceptual , logical and physical levels.
• Employ PowerDesigner to create a conceptual data model with entities, attributes, and relationships. 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.
• You will also explore the reverse engineering features of PowerDesigner to create physical, logical and conceptual 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, learn how to use and mange the Enterprise Repository for storing and sharing enterprise models across disparate groups and locations.

Popular tags

No tags submitted for this course yet