DEV353: Data Modeling with PowerDesigner 15

Course Description :
Learn how PowerDesigner 15.0 can be used as a tool during the data analysis, data modeling, and database design processes. A well-known “best practice” in Information Engineering (IE) is to model the information at the conceptual , logical and physical levels. Employ PowerDesigner to create a conceptual data model 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. You will also explore the reverse engineering features of PowerDesigner to create physical, logical and conceptual models from an existing database, as well as learn iterative modeling by using compare and merge model features and synchronizing physical data models with corresponding databases and vice versa. Finally, learn how to use and mange the Enterprise Repository for storing and sharing enterprise models across disparate groups and locations.

Course Objectives :
Upon completion of this course, you will be able to:
Create and manage conceptual 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 MetaWorks
Create effective reports on you PowerDesigner models
Course Topics:

Introduction to data modeling with PowerDesigner
Using the PowerDesigner modeling environment
Creating and managing a conceptual data model
Defining business rules
Creating data items, entities, and entity attributes
Creating and defining relationships
Cardinality
Dependency
Roles
Existence
Defining and using domains and inheritance
Generating a physical data model
Transforming CDM objects to PDM objects
Customizing the physical data model
Creating views, alternate keys, and indexes
Creating the database script
Protecting data through triggers, procedures, views, and business rules
Reverse engineering databases
Model management techniques
Links to Requirements models
Physical data model synchronization
Worguide with packages and diagrams
Worguide with the Enterprise Repository
Creating reports
Who Should Attend: This course is designed for individuals who are responsible for designing, implementing, and managing relational databases, including: Data analysts, Data modelers, Database administrators, Systems analysts, Application Developers with data modeling responsibilities

Prerequisites: Understanding of relational database concepts and database implementation issues, Exposure to entity relationship (ER) data modeling and data normalization.

Skill: Building

Format:
40% Lecture
60% Labs

Duration: 4 days

Type:
Classroom, Onsite, SyberLearning LIVE

Delivery Times:
Learning Center Classroom: Classes typically begin at 8:30AM Local Time in most Learning Centers. Please check your Confirmation Letter for exact time.

SyberLearning LIVE (Instructor-facilitated online training): Four, 6.0 Hour Sessions (Lecture & Lab: 11:00am – 5:00pm EST)

PassGuide Cisco Exams Questions & Training Materials

1. Free DEV354: Business Process Modeling with PowerDesigner 15
2. Free passguide Sybase PowerDesigner Data Modeling Pro.Exam (version 12.1) : 510-802
3. Free Mastering Data Warehouse Design: Relational and Dimensional Techniques
4. Free Microsoft MCIPT Certification Training Optimizing Data Access for SQL 2005 70-444 Exam
5. Free 70-442
6. Free Cisco CCNP Certification Training ONT 1.0: Optimizing Converged Cisco Networks
7. Free 70-441
8. Free MCITP: Database Developer
9. Free IBM DB2 Universal Database 8.1 Database Administration Training Certification Course
10. Free Test 730: DB2 9 Family Fundamentals
11. Free PassGuide 510-888
12. Free Analyzing Requirements and Defining Solutions Architecture: MCSD Training Kit (exam 70-100)