Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Data Modeling with PowerDesigner 16.5 (DEV355v15)

GK# 2073 Vendor# DEV355v15

Course Overview

TOP

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 database management system (DBMS), generate and enhance a physical data model, and then generate a database creation script for database tables, indexes, views, triggers, and stored procedures.

This course is based on software release SAP PowerDesigner.

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. 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

2. 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

3. 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

4. Model Synchronization

  • Comparing Models
  • Merging Models
  • Synchronizing Models

5. Model Organization

  • Creating and Modifying a Package
  • Creating a Diagram
  • Creating a Package from a Diagram
  • Creating a Dependency Matrix

6. Reporting

  • Creating a Report Template
  • Creating a Report
  • Generating a Report
  • Creating a Multi-Model Report

7. Impact Analysis

  • Creating Requirements
  • Creating a Link Between Models
  • Generating an Impact Analysis Model (IAM)

8. The Repository

  • Modifying Documents in the Repository
  • Setting up a Repository Workflow
  • Integrating Changes Across Repository Branches
  • Managing a Repository

Who Should Attend

TOP
  • Business analyst
  • Data consultant / manager
  • Database administrator
  • Developer
  • Developer consultant
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 4 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 4 day

Request this course in a different delivery format.
Enroll