Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


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.


 
Course Outline
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.

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
• New Erwin 7.3 features

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.

Course Outline

I. Enterprise Modeling Features

A. Model layers defined
B. Splitting, deriving, and combining models
C. Synchronizing model layers

II. Advanced Logical Modeling

A. Establishing model naming standards
B. Hardening logical and physical object names
C. Implementing model object naming options
D. Using Domains to build model standards

III. Advanced Physical Modeling
A. Using model transforms
B. Complete Compare and Synchronization
C. User Defined Data types
D. Data Type standard models
E. ERwin macro review and new 7.3 macros

IV. Model Audit and Validation
A. Ensuring syntactical completeness
B. Ensuring conceptual completeness
C. Practical approach to model auditing
D. Validating ERwin model objects

V. Dimensional and Data Warehouse Modeling
A. Data Warehouse modeling concepts
B. Establishing and implementing metadata standards
C. Star and Snowflake schema models
D. Understand aggregates, semi additive facts and slowly changing dimensions
E. Metadata modeling and management
F. ETL mapping and synchronization
G. Warehouse database specifics (Teradata, Oracle, SQLServer, DB2)

VI. Model Manager (ModelMart) and Server Based Modeling
A. Enterprise modeling architecture and maintenance
B. Understand Model Manager capabilities
C. Model Manager functions, actions, conflicts, and resolution
D. Collaborative modeling best practices and standards
E. Model Manager database Tuning

VII. Report Publication and Metadata Management
A. Integrated Crystal Reports defined
B. Working with existing reports
C. Custom report definition and export
D. Meta Integration Bridge new features



Prerequisites & Certificates
Pre-Requisites

Students must have at least 4 months experience using ERwin. Sound understanding of Data modeling concepts and Relational Database Design is assumed.

Certificates offered

Certificate of completion


Cancellation Policy
10 Day cancellation required for all courses in order to get a full refund.
Map & Reviews
Protech Training
[ View Provider's Profile ]

Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
I took the training remotely so I cannot comment on some of the questions. I think that this seminar has too much content to squeeze it into one week.... might be better as a two week course?
Reviewed by 2013
found the material very helpful - although there was a lot of material covered - the pace was well set. Would definitely recommend people to have explored Microsoft Access beforehand to be familiarized with the program before taking the course. I would imagine someone without any exposure would find it confusing. Environment really good - people very, very nice and helpful. Would definitely take the next level of access with the same training facility.
Reviewed by 2013
I was not in the physical classroom. Feedback centered around online training would be good because now I have to rate items that I was not present for. Those items are getting half a star because I was not there to rate them. The course material must go through an editing process. There are a lot of grammar mistakes, but also a lot of actual procedure/activity mistakes.
Reviewed by 2012
need-to-train-a-group-banner

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 311 times.