Data Modeling with PowerDesigner 16.5 (DEV355v15)

  • Business analyst
  • Data consultant / manager
  • Database administrator
  • Developer
  • Developer consultant

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
4 day

Description

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.

Objective

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

SUBSCRIPTION COST


$2,680.00

Select Course Options

 

NEED HELP OR NOT SURE?