Share Description
In this course, you will learn :
- Architect and implement a professional data warehouse from start to finish.
- The principles of Data Warehouse Design will be taught to you.
- You will master the ETL process both theoretically and practically.
- In a case study, you will implement your own data warehouse and ETL process.
- You will become acquainted with the modern architecture of a Data Warehouse.
- A professional approach to Dimensional Modeling.
Syllabus :
- Data Warehouse Basics
- Data Warehouse Architecture
- Dimensional Modeling
- Facts
- Dimensions
- Slowly Changing Dimensions
- ETL process
- ETL tools
- Case Study: Creating a Data Warehouse
- ETL vs. ELT
- Using a Data Warehouse
- Optimizing a Data Warehouse
- The Modern Data Warehouses
