Description
In this course, you will learn :
- Warehouse of Data Fundamental ideas.
- Modeling in three dimensions.
- Dimensional and factual tables
- Snowflake schema and Schema.
Syllabus :
- What is Data Warehouse
- Why we need Data Warehouse?
- Ideal Data Warehouse Solution
- Responsibility of Data Warehouse designer
- SQL Server (OLTP) vs Data Warehouse (OLAP)
- Dimensional Modeling
- Facts and Fact Table
- Dimensions and Dimension table
- Star vs Snowflake