Loading Classes
Data Modeling with PowerDesigner 16.5 (DEV355)
New Age Technologies has been delivering Authorized Training since 1996. We offer SAP’s full suite of authorized courses including courses pertaining to PowerDesigner, Supply Chain Management (SCM), Enterprise Resource Planning (ERP), BusinessObjects, Product Lifecycle Management (PLM), and more. If you have any questions or can’t seem to find the SAP class that you are interested in, contact one of our SAP Training Specialists. Invest in your future today with SAP training from New Age Technologies.
✉ SAP Training Specialists | ☏ 502.909.0819
COURSE INFORMATION
Data Modeling with PowerDesigner 16.5 (DEV355) Overview:
In the Data Modeling with PowerDesigner 16.5 (DEV355) course, you will learn how PowerDesigner can be used as a tool during the data analysis, data modeling, and database design processes. Employ PowerDesigner to create a conceptual and logical data models 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
Data Modeling with PowerDesigner 16.5 (DEV355) Goals:
- Define glossary terms
- Distribute model templates using the Library
- Create and manage conceptual and logical 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 the PowerDesigner Repository
- Create effective reports on PowerDesigner models
- Define glossary terms
- Distribute model templates using the Library
- Create and manage conceptual and logical 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 the PowerDesigner Repository
- Create effective reports on PowerDesigner models
Who Should Attend:
- Business Analyst
- Data Consultant / Manager
- Database Administrator
- Developer
- Developer Consultant
Data Modeling with PowerDesigner 16.5 (DEV355) Prerequisites:
Before attending this course, you must have the following:
- Understanding of relational database concepts and database implementation issues.
- Exposure to Entity Relationship (ER) data modeling and data normalisation.
Data Modeling with PowerDesigner 16.5 (DEV355) Content:
SAP PowerDesigner
- Identifying Key Components of the SAP PowerDesigner Environment
- Creating a Project in the Workspace
- Adding a Model to the Library
- Creating a Glossary
Conceptual Data Models (CDMs) and Logical Data Models (LDMs)
- Applying Model Properties and Options
- Creating Entities and Domains
- Creating Relationships in CDMs and LDMs
- Creating Inheritance Links in a Model
- Checking a CDM
Physical Data Models (PDMs)
- Generating a PDM from Another Model
- Implementing Data Integrity Checks in a PDM
- Creating Views, Stored Procedures, and Triggers
- Creating Indexes and Alternate Keys
- Checking a PDM
- Generating a Database from a PDM
- Reverse Engineering from a Database
Model Synchronization
- Comparing Models
- Merging Models
- Synchronizing Models
Model Organization
- Creating and Modifying a Package
- Creating a Diagram
- Creating a Package from a Diagram
- Creating a Dependency Matrix
Reporting
- Creating a Report Template
- Creating a Report
- Generating a Report
- Creating a Multi-Model Report
Impact Analysis
- Creating Requirements
- Creating a Link Between Models
- Generating an Impact Analysis Model (IAM)
The Repository
- Modifying Documents in the Repository
- Setting up a Repository Workflow
- Integrating Changes Across Repository Branches
- Managing a Repository
