SQL

Interview Skills

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

Bonus - LLMs

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

Week 2: Advanced RAG, Reranking & Dev Workflow

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

Kickoff

Pre-Read - Data Modeling

Week 1: dbt Basics

Week 2: Advanced dbt

Week 3: Data Modeling on Snowflake

Week 4: Advanced Snowflake

Week 7: Analytical Patterns & CDC

Expert Guest Sessions

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