Level 2 · Intermediate Smarter Pipelines

Goal: move beyond a single manual script — write advanced SQL, ingest from APIs, warehouse properly, orchestrate with Airflow, handle incremental loads, work with Parquet/Arrow, test pipelines, learn streaming basics, and use dbt.

Modules

1. Advanced SQL for Pipelines
2. Working with APIs for Ingestion
3. Data Warehousing Concepts
4. Airflow Hands-On
5. Data Partitioning & Incremental Loads
6. Working with Parquet/Arrow
7. Testing Data Pipelines
8. Streaming Basics (Kafka Concepts)
9. dbt Basics
10. Project — Orchestrated Multi-Step Pipeline

Coming soon

Full lesson content for this level is being written next. Start with Level 1 · Entry, which is complete.