arrow_back
Welcome
Welcome to the Course
Introduction
Data vs information
Why do we need Data?
Data Storage and Processing
Transactional and Analytical Processing
What is Data Warehouse?
History of Data Warehouse
OLAP & OLTP
Introduction to ETL
Data Warehouse Introduction Assessment
OLTP & OLAP Assessment
Introduction to ETL
Introduction to ETL Study Material
Extraction in ETL
Extraction in ETL Study Material
Transformation Introduction
Transformation Introduction Study Material
Types of Transformation
Types of Transformation Study Material
Load Data
Load Data Study Material
DataWarehouse Architecture Introduction
DataWarehouse Architecture Introduction Study Material
Data Warehouse Architectures based on Layers
Data Warehouse Architecture based on Tiers
Data Warehouse Architecture based on Layers and Tiers Study Material
ETL Assessment
What is Data Mart ?
Storing Data in Data Warehouse
Dimension Tables and Fact Tables
Dimension and Fact table with Example
Dimension and Fact Assessment
Data Warehouse Schema
Introduction to Data Warehouse Schema
Star Schema
Snowflake Schema
Fact Constellation Schema
Slowly Changing Dimension Introduction
SCD Type 0 and SCD Type 1
SCD Type 2
SCD Type 3
SCD Type 4
SCD Type 6
ETL Tools
Scheduling Tools
Reporting Tools
What Next