Data Modeling with PowerDesigner 11

Sybase, Inc.
Ottawa, Toronto, Ontario, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Information Systems that perform well are based on well-designed databases developed from a complete and accurate model of the data. In this three-day course, learn how PowerDesigner 11.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 both a conceptual and physical level. Use 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. Explore the reverse engineering features of PowerDesigner to create physical, conceptual, and object-oriented 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
Physical data model synchronization
Working with packages and diagrams
Working with the Enterprise Repository
Creating reports
...''

Elements of this syllabus are subject to change.

Phone:(978) 287-1626

School Address:

Sybase, Inc.
Toronto Learning Center
175 Bloor Street East, Suite 800
Phase 1 - North Tower
Toronto, Canada M4W 3R8

Jobs & Resumes: Ottawa, Toronto
Houses & Roommates: Ottawa, Toronto
Travel Agencies: Ottawa, Toronto

Search other schools for Data Modeling with PowerDesigner 11 training resources.

Adaptive Server Anywhere 9.0 Fundamentals
Manage Anywhere Studio 5.0 Administration
Replicating Data using SQL Remote 9.0
MobiLink Synchronization with Adaptive Server Anywhere 9.0
MobiLink Synchronization with SQL Anywhere 10.0
Logical Database Design
Physical Database Design
Data Modeling with PowerDesigner 12
Business Process Modeling with PowerDesigner 12
Business Process Modeling Using PowerDesigner 11
Essential Techniques for Object-Oriented Modeling using PowerDesigner 12
Object-Oriented Modeling with PowerDesigner 11.0
Object-Oriented Modeling with PowerDesigner 12
Data Modeling with PowerDesigner 15
Business Process Modeling with PowerDesigner 15
Advanced Modeling Techniques using PowerDesigner 12
Moving to PowerDesigner 15
Implementing Mirror Activator for Sybase

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.