Data Modeling with PowerDesigner 16.5

Summary

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

Prerequisites

Before taking this course, students should have an understanding of relational database concepts and database implementation issues and exposure to Entity Relationship (ER) data modeling and data normalization.

Duration

4 Days/Lecture & Lab

Audience

This course is designed for:

• Business Analysts
• Data Consultants / Managers
• Database Administrators
• Developers
• Developer Consultants

Topics

• SAP PowerDesigner
• Conceptual Data Models (CDMs) and Logical Data Models (LDMs)
• Physical Data Models (PDMs)
• Model Synchronization
• Model Organization
• Reporting
• Impact Analysis
• The Repository