Data Modeling with PowerDesigner 16.5 (DEV355v15)

Description

Audience & Prerequisites

Course Outline

Schedule & Fees

Certification

DEV355v15 – Data Modeling with PowerDesigner 16.5 Training

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.

Objectives

  • 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

Intended Audience

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

Course Outline                                                  Duration: 5 Days

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

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly contact us.


Reviews