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 some knowledge of how to design a data base through at least third normal form (3NF) as well as some knowledge of how to code Structured Query Language (SQL).