Data Warehousing

Week 1: Databricks Basics

Week 2: Databricks & Advanced Spark

Week 4: Structured Streaming with Spark & Kafka

Q&A with Zach

Data Modeling with Iceberg and Trino

Airflow + Trino

Snowflake + dbt Basics

Databricks Basics

Advanced Spark on Databricks

Snowflake + Advanced dbt

Analytical Patterns and Advanced SQL

Real Time Data (Spark and Kafka Streaming)

Q&A with Zach Wilson

TA Office Hours

Bootcamp Kickoff

Pipeline Spec Building + Airflow Fundamentals

Change Data Capture (CDC) and Analytical Patterns

dbt basics

Advanced dbt

Advanced Snowflake

Bonus

Tech Talk

TA Office Hours

Kickoff

Pre-Read - Data Modeling

Week 1: dbt Basics

Week 2: Advanced dbt

Week 4: Advanced Snowflake

Week 6: Airflow & Pipeline Specs with Trino

Week 7: Analytical Patterns & CDC

Expert Guest Sessions

Dimensional Data Modeling with Apache Iceberg

Fact Data Modeling with Apache Iceberg

Pipeline Spec Building and dbt fundamentals

Unit Testing Spark Pipelines and Write-Audit-Publish

Analytical Patterns & Analysis with Trino

Streaming Pipelines with Apache Flink

Data Pipeline Maintenance

Batch Pipelines with Apache Spark

Data Impact Communication & Visualization

dbt

Data Pipeline Maintenance (V4)

Dimensional Data Modeling in Iceberg

Fact Data Modeling with Apache Iceberg

Data Quality Patterns in Apache Airflow

Unit and Integration Testing Spark Pipelines

Streaming Pipelines with Kafka and Spark Streaming

Analytical Patterns & Analysis with Trino

Data Impact Communication & Visualization

Wisdom From Zach