Course announcements

  • 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

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

Audience

  • 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 based on software release

  • SAP PowerDesigner

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