DATA MODELING WITH POWERDESIGNER 16.7 (PWD2)

In this four-day course you'll learn to use PowerDesigner for conceptual and physical data modeling and for practical database design. Starting from a data specification you will create and extend models and prepare them for implementation.

You will also practice reverse engineering to produce models from existing databases and use the MetaWorks Repository for model sharing, versioning and team collaboration. Model comparison, synchronization and reporting are included.

Location, current course term

Contact us

Custom

Customized Training (date, location, content, duration)

The course:

Hide detail

• SAP PowerDesigner
1. Identifying key components of the PowerDesigner environment
2. Creating a project in the workspace

• Conceptual Data Models (CDMs) and Logical Data Models (LDMs)
1. Applying model properties and options
2. Creating entities and domains
3. Creating relationships in CDMs and LDMs
4. Creating inheritance links in a model
5. Validating a CDM

• Physical Data Models (PDMs)
1. Generating a PDM from another model
2. Implementing data integrity checks in a PDM
3. Creating views, stored procedures, and triggers
4. Creating indexes and alternate keys
5. Validating a PDM
6. Generating a database from a PDM
7. Reverse engineering from an existing database

• Model Synchronization
1. Comparing models
2. Merging models
3. Synchronizing models

• Model Organization
1. Creating and modifying a package
2. Creating a diagram
3. Creating a package from a diagram
4. Creating a dependency matrix

• Reporting
1. Creating a report template
2. Creating a report
3. Generating a report
4. Creating a multi-model report

• Impact Analysis
1. Creating requirements
2. Linking models
3. Generating an Impact Analysis Model (IAM)

• The Repository
1. Creating a glossary
2. Modifying documents in the repository
3. Setting up a repository workflow
4. Integrating changes across repository branches
5. Managing a repository

Assumed knowledge:

Familiarity with Microsoft Windows and basic relational database concepts, ER modeling and normalization.

Schedule:

4 days (9:00 AM - 5:00 PM )

Course price:

2 240.00 € (2 710.40 € incl. 21% VAT)

Education Partner:

MIBCON DIMA s.r.o.

Language: