This SAP PowerDesigner training course provides skills for data analysis, data modeling, and database design processes using PowerDesigner. Learn to create a conceptual and logical data models with entities, attributes, and relationships.
By attending SAP PowerDesigner workshop, delegates will learn to:
- 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
- Understanding of relational database concepts and database implementation issues.
- Exposure to Entity Relationship (ER) data modeling and data normalisation.
The SAP PowerDesigner class is ideal for:
- Business Analysts
- Data Consultants / Managers
- Database Administrators
- Developers
- Developer Consultants