Advanced Data Modeling Using Erwin R9.7

Summary

This course is taught in a workshop format, supported by slide presentation and visual tool illustrations. There are daily review sessions, lectures, and workshops, supported by a complete case study, augmented by periodic exercises and quizzes.

Prerequisites

Before taking this course, students must have at least 4 months experience using ERwin. Sound understanding of Data modeling concepts and Relational Database Design is assumed.

Duration

3 Days/Lecture & Lab

Audience

This course is designed for data modelers, data architects, business analysts, application builders, DBA’s, and end users who will be participating in data modeling and database design of OLTP and Data Warehouse applications.

Topics

Enterprise Modeling Features

• Advanced Logical Modeling

• Advanced Physical Modeling

• Model Audit and Validation

• Dimensional and Data Warehouse Modeling

• Introduction to ModelMart and Server Based Modeling

• Advanced Model Reporting

Related Scheduled Courses