Data Warehousing Certification Training Course Syllabus

Full curriculum breakdown — modules, lessons, estimated time, and outcomes.

Overview: This self-paced course provides a comprehensive introduction to data warehousing, covering key concepts, modeling techniques, ETL development, and business intelligence visualization. With a balanced mix of theory and hands-on practice, learners progress through six modules totaling approximately 25 hours. The curriculum guides you from foundational principles to a capstone project that integrates modeling, ETL, and dashboarding—building job-ready skills for data engineering roles.

Module 1: Data Warehouse Fundamentals

Estimated time: 3 hours

OLTP vs. OLAP systems
Data marts and operational data stores (ODS)
Core characteristics: subject orientation, time variance, integration
Data warehouse architecture components

Module 2: Dimensional Modeling & SCD

Estimated time: 4 hours

Fact tables and dimension tables
Star schema and snowflake schema design
Hierarchies in dimensional models
Slowly Changing Dimensions (Types I–III) and historical data handling

Module 3: Normalization & Schema Design

Estimated time: 3 hours

Database normalization and normal forms
Galaxy (fact constellations) schemas
Metadata management and reporting

Module 4: ETL Development with Talend

Estimated time: 6 hours

Talend components and interface overview
Data extraction from CSV and databases
Transformation functions and data cleansing
Job orchestration in Talend

Module 5: BI Visualization with Tableau

Estimated time: 5 hours

Connecting Tableau to data warehouses
Building interactive dashboards
Using filters and calculated fields

Module 6: Final Project