Relational and Dimensional Data Warehouse Design

    

Summary:
This course provides students with the skills necessary to design a successful data warehouse using both relational and dimensional data modeling techniques.

Duration:
3 Days/Lecture & Lab

Audience:
This course is targeted at technical staff, team leaders and project managers who need to understand how to design a data warehouse using both relational (Bill Inmon style) and dimensional (Ralph Kimball style) data warehousing design techniques.

Topics:

• Introduction
• Fundamental Relational Concepts
• Understanding the Business Model
• Developing the Model
• Creating and Maintaining Keys
• Modeling the Calendar
• Modeling Hierarchies
• Modeling Transactions
• Data Warehouse Optimization
• Accommodating Business Change
• Maintaining the Models
• Deploying the Relational Solution
• Comparison of Data Warehouse Methodologies

Prerequisites:
Students should have at least some experience with any relational database management system.

Last Update: September 9, 2010