Data Warehousing Fundamentals

Summary: This dimensional modelling techniques course is designed to answer questions, such as the following:
- What is data warehousing?
- What is a data mart?
- What are the data modelling options?
- What is Extract, Transform and Load (ETL)?
- What are the terms and concepts specific to data warehousing and OLAP design?
- How to plan and implement a data warehouse with high availability, simplified manageability and optimal performance
- What are common statistics, analytic and OLAP SQL queries?

Objectives: Upon completion of this course, the participant should be able to design a data warehouse using both star and snowflake schemas. And the delegate should understand the implication of such terms as cubes, dimensions, attributes, joins, hierarchies, measures, etc.