Data Modeling with PowerDesigner 16.5

Course Details
Code: DEV355-v015
Tuition (USD): $3,000.00 • Classroom (4 days)
Course Details
GSA (USD): $2,430.23 • Classroom (4 days)

Skills Gained

  • 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 Can Benefit

  • Business Analyst
  • Data Consultant / Manager
  • Database Administrator
  • Developer
  • Developer Consultant

Prerequisites

  • Essential:
       -Understanding of relational database concepts and database implementation issues.
       -Exposure to Entity Relationship (ER) data modeling and data normalisation.
  • Recommended:
       -NONE

Course Details

Course 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

Notes

  • The course material is available in English only

Course based on software release

  • SAP PowerDesigner