(PD101) 2-3 Days
Lecture 60%/Labs 40%

The PowerDesigner class is intended for Business Analysts, Database Administrators, and other professionals interested in data or object modeling with PowerDesigner. It can be tailored to specific audiences. Learn to create conceptual data models (CDMs), to target a specific DBMS, and to generate database DDL for database objects. Learn how to reverse-engineer models from existing databases. Understand the compare and merge model features, and how to synchronize a database to a model or vice versa. The repository for storing and sharing enterprise models is discussed, and best practices and appropriate corporate adoption strategies of PowerDesigner are also presented. The expanded class offers UML modeling using PowerDesigner, with emphasis on Object-Oriented analysis and design.

Upon Completion of the course you will be able to:

• Individuals responsible for the design, implementation, and management of relational databases including Database Administrators and Data Analysts and Modelers
• Systems Analysts and Application Developers with data modeling responsibilities.
Application Developers seeking to leverage UML and relational modeling techniques in the development of an object-oriented system using languages such as Java, PowerBuilder, C#, or VB.Net

• Understanding of relational database concepts and database implementation issues.
• Exposure to entity relationship (ER) data modeling and data normalization.
• Experience with logical database design.

Group and individual pricing available. This course is available at our facilities or by arrangement.

• Introduction to Data Modeling with PowerDesigner
• Managing the PowerDesigner Modeling Environment
• Iterative Modeling Techniques
• PowerDesigner Tool Options
• Creating and Managing a Conceptual Data Model (CDM)
• Defining Business Rules
• Creating Data Items, Entities, and Entity Attributes
• Creating and Defining CDM Relationships
• Cardinality and Existence
• Dependency and Inheritance
• Generating and Customizing a Physical Data Model
• Transforming CDM objects to PDM objects
• Check Constraints
• Views, Keys, and Indexes
• Generating the Create Database Script
• Generation Options
• Generating DDL vs. using ODBC
• Generating Triggers, Procedures, and Functions
• Trigger Generation Overview and Templates
• Stored Procedures
• Reverse Engineering and Maintaining Databases
• Reverse Engineering from Scripts and from DLL
• Updating PDMs and Databases
• Object-Oriented Modeling and Analysis
• UML Support in the OOM
• Classes and Objects
• Use-Case Modeling and the Noun-Verb-Adjective Approach
• Relationships in PowerDesigner
• Associations
• Aggregation and Composition
• Inner Classes
• Dynamic Modeling in PowerDesigner
• Dynamic Modeling Overview
• Sequence Diagrams in PowerDesigner
• Object Languages Overview
• Languages Supported
• Generating and Reverse Engineering Object Languages
• Moving Between Models
• Conceptual Mapping between Model Types
• Differences between Object Modeling and Data Modeling
• Generating Conceptual Data Models and Physical Data Models
• Creating Reports with PowerDesigner
• Report Templates
• Reports in Models
• Multi-Model Reports
• Using Metaworks with PowerDesigner
• Repository Overview and Features
• Consolidation and Extraction
• Model versioning and branching