EulerFold
Aspiring Data Engineers

Data Warehousing Basics

8 weeks
0 Learners
Jul 23

Understand OLAP vs OLTP, schemas, and ETL before building pipelines in dbt or Snowflake.

Share:

What you'll learn

Differentiate between OLTP and OLAP systems
Design star and snowflake schemas
Implement ETL strategies and slowly changing dimensions
Compare cloud data warehouses and data lakes
Master Advanced Dimensional Modeling Techniques
Understand Data Governance and Security
Optimize Data Warehouse Performance
Explore Modern Data Architectures (Data Mesh, Lakehouse)

Prerequisites

Level

W1

Data Warehouse Architecture

2 videos19m
3 readings
2 topics
1 homework
Learn

Topics

1.1
Data Warehousing: OLTP vs OLAP Systems
8 minutes
1.2
Data Warehousing: Enterprise Data Warehouse (EDW) vs Data Mart
11 minutes
W2

Dimensional Modeling Fundamentals

2 videos17m
2 readings
2 topics
1 homework
Learn
W3

Advanced Dimensional Modeling

2 videos21m
3 readings
2 topics
1 homework
Learn
W4

ETL Processes

2 videos63m
2 readings
2 topics
1 homework
Learn
W5

Data Loading Strategies

2 videos43m
2 readings
2 topics
1 homework
Learn
W6

Modern Data Platforms

2 videos60m
3 readings
2 topics
1 homework
Learn
W7

Performance and Optimization

2 videos29m
2 readings
2 topics
1 homework
Learn
W8

Next-Gen Architectures

2 videos31m
3 readings
2 topics
1 homework
Learn
01

Learn

Watch curated videos and read study resources

02

Practice

Practice what you learned

03

Build Projects

Build projects using your new gained knowledge

04

Submit & Verify

Submit your project and get verified by our system

Rate this course

0.0
0 reviews

Help the community find verified technical paths.

Community Insights

0

Join the discussion

Sign in to share your thoughts and technical insights.

Loading insights...