Training Schedule Training Schedule

(DEV355) Data Modeling with PowerDesigner 16.5
Code: DEV355 v15
Type: null
Tuition (USD): $3000
Length: 4 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
Live Virtual, US 01/28/2019
San Francisco, CA 02/26/2019
Live Virtual, US 06/17/2019

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

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 Should Attend?
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 normalization
What You Will Learn:
  • 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
Course Info:
Course based on software release: SAP PowerDesigner

Course notes and announcements:

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

This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, SAP Certified e-book participant guides and SAP Certified Hard copy participant guides.

This 4 day instructor led course qualifies for 32 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

Not finding any suitable dates? Contact us for additional available dates: training@dunnsolutions.com