SQL

Interview Skills

AI and LLM

test module

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

Bonus - LLMs

Career Development Sessions

TA Office Hours

Week 2: RAG optimizations + Reranking

Data Modeling on Snowflake

Bootcamp Kickoff

Change Data Capture (CDC) and Analytical Patterns

dbt basics

Advanced dbt

Advanced Snowflake

Passing Analytics Engineer Interviews

Bonus

Tech Talk

TA Office Hours

Dimensional Data Modeling in Postgres

Dimensional Data Modeling with Apache Iceberg

Fact Data Modeling in Postgres

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

Data Impact Communication & Visualization

dbt

Dimensional Data Modeling in Iceberg

Fact Data Modeling with Apache Iceberg

Data Quality Patterns in Apache Airflow

Unit and Integration Testing Spark Pipelines

Analytical Patterns & Analysis with Trino

Data Impact Communication & Visualization

Data Lakes with Delta Table

Structured Streaming Kafka to Delta Live Table

Mastering Analytical Patterns

dbt basics

Advanced Snowflake

Big Tech Careers

Wisdom From Zach