Data Engineering
Design and build the systems that move, transform, and store data at scale. From SQL and ETL pipelines to modern data warehousing.
9
Total Topics
3
Categories
SQL for Data Engineering
3 topicsBeginner12 min
SQL Fundamentals for Data Engineers
Tables, keys, SELECT, filtering and grouping.
SQL for Data Engineering
Intermediate15 min
SQL Joins & Aggregations
Join types, GROUP BY, HAVING and aggregate functions.
SQL for Data Engineering
Advanced18 min
Window Functions & CTEs
Ranking, running totals, deduplication and WITH queries.
SQL for Data Engineering
ETL Pipelines
3 topicsBeginner10 min
ETL vs ELT Explained
Extract, transform, load patterns and when to use each.
ETL Pipelines
Intermediate16 min
Building Reliable ETL Pipelines
Incremental loads, idempotency and data quality checks.
ETL Pipelines
Advanced20 min
Pipeline Orchestration with Apache Airflow
DAGs, operators, scheduling, retries and backfills.
ETL Pipelines
Data Warehousing
3 topicsBeginner12 min
Data Warehouse Concepts & Architecture
OLTP vs OLAP, warehouse layers and cloud warehouses.
Data Warehousing
Intermediate16 min
Dimensional Modeling: Star & Snowflake Schemas
Facts, dimensions, grain and surrogate keys.
Data Warehousing
Advanced18 min
Slowly Changing Dimensions (SCD)
Track history with Type 1, 2 and 3 techniques.
Data Warehousing