Data Modeling with PowerDesigner 10

Sybase Canada Ltd.
Ottawa, Toronto, Winnipeg, 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 10.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
Who Should Attend : Data analysts, Data modelers, Database administrators, Systems analysts, Application Developers with data modeling responsibilities

Prerequisites :

Logical Database Design (SYB144)
Experience using Microsoft Windows™ or another graphical user interface
Understanding of relational database concepts and database implementation issues
Exposure to entity relationship (ER) data modeling and data normalization

...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

Ottawa Learning Center
Sybase Canada Ltd.
320 March Road
3rd floor
Kanata, Ontario K2K 2E2

Toronto-Mississauga Learning Center
1 Robert Speck Parkway
Suite 800
Mississauga, Ontario
Canada L4Z 3M3

Winnipeg/Manitoba Public Insurance
234 Donald St.
Room B100
Winnipeg, MB R3C 4A4

1-800-8-SYBASE (800-879-2273)
(613) 321-5005

Jobs & Resumes: Ottawa, Toronto, Winnipeg
Houses & Roommates: Ottawa, Toronto, Winnipeg

Sybase Enterprise Security
Advanced Content Management
EAServer: Developing Web Applications with Enterprise JavaBeans
Enterprise Application Server: Building Web Applications with Java (J2EE)
Enterprise Application Server: Delivering Web Services
Enterprise Application Server Administration
EAServer 5.0 Administration
EAServer 24x7
Business Process Modeling with PowerDesigner 9.0
Data Modeling with PowerDesigner
Object-Oriented Modeling with PowerDesigner

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.