ETL/ELT

Data Pipeline Maintenance (V4)

dbt

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

Large Language Models

Data Impact Communication & Visualization

AI and LLM

Week 1: Databricks Basics

Week 2: Databricks & Advanced Spark

Week 3: Data Lakes with Delta Table

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 2: Advanced dbt

Week 4: Advanced Snowflake

Week 6: Airflow & Pipeline Specs with Trino

Week 7: Analytical Patterns & CDC

Expert Guest Sessions

Batch Pipelines with Apache Spark

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

Streaming Pipelines with Apache Flink

Data Pipeline Maintenance

Data Impact Communication & Visualization

Databricks and Advanced Spark

Airflow

Mastering Analytical Patterns

Data Lakes with Delta Table

Wisdom From Zach