Data Modeling with PowerDesigner 15

Sybase USA
Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States

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

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
Working with packages and diagrams
Working with the Enterprise Repository
Creating reports
...''

Elements of this syllabus are subject to change.

Phone:1-800-8-SYBASE

School Address:

Manhattan Learning Center
The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Irvine Learning Center
19800 MacArthur Blvd. Suite 855
Irvine, CA 92612


Jobs & Resumes: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Houses & Roommates: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Travel Agencies: Atlanta, Chicago, Dallas,

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

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
Data Modeling with PowerDesigner 11
Essential Techniques for Object-Oriented Modeling using PowerDesigner 12
Object-Oriented Modeling with PowerDesigner 11.0
Object-Oriented Modeling with PowerDesigner 12
Business Process Modeling with PowerDesigner 15
Advanced Modeling Techniques using PowerDesigner 12
Moving to PowerDesigner 15
Implementing Mirror Activator for Sybase
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise
Fast Track to Replication Server Administration
Replication Server 15.0 Masters
Powering Up to Replication Server 12.6

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: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.