Analytics Engineering Boot Camp starting October 2024

• 5 weeks of classes
• 8 hrs on dbt
• 8 hrs on Trino, Snowflake, and Iceberg
• 4 hrs on Airflow
• Master 5 analytics interviews
• Weekly Q&A with Zach
• 2x/week calls with industry leaders
• Get career mentorship afterwards
• Build a capstone project

PrerequisitesCurriculaHomeworkSchedule

• Basic SQL knowledge
• Previous experience as data analyst, data engineer or data scientist

• Basic SQL knowledge
• Previous experience as data analyst, data engineer or data scientist

Main Content

Bootcamp Kickoff2.2 hrs

• Analytics Engineering Bootcamp Kickoff
• Capstone Requirements
• Understanding Capstone Requirements

Pipeline Spec Building + Airflow Fundamentals2.8 hrs

• Write a comprehensive pipeline spec document
• Write a comprehensive pipeline spec document Lab
• Orchestration and Airflow Fundamentals Lecture
• Orchestration and Airflow Fundamentals Lab

Change Data Capture (CDC) and Analytical Patterns5.5 hrs

• Change Data Capture (CDC) and Snowflake basics Lecture
• Change Data Capture (CDC) and Snowflake basics Lab
• How to use snowpark and Snowflake optimization Lecture
• How to use snowpark and Snowflake optimization Lab
• Growth Accounting Models Lecture
• Growth Accounting Models Lab
• Grouping sets and Window functions Lecture
• Grouping sets and Window functions Lab

dbt basics2.6 hrs

• dbt basics: How dbt works: sources, models, packages Lecture
• dbt basics: How dbt works: sources, models, packages Lab
• dbt basics: creating a full dbt project lecture
• dbt basics: creating a full dbt project lab

Advanced dbt2.7 hrs

• Advanced dbt: Understanding incremental models Lecture
• Advanced dbt: Understanding incremental models Lab
• Advanced pipelines: Blue-green and WAP with Airflow Lecture
• Advanced pipelines: Blue-green and WAP with Airflow Lab

Advanced Snowflake2.6 hrs

• Advanced snowflake: Deploying the Capstone dag Lecture
• Advanced snowflake: Deploying the Capstone dag Lab
• Advanced Snowflake: Data Modeling and UDFs Lecture
• Advanced Snowflake: Data Modeling and UDFs Lab

Passing Analytics Engineer Interviews0.5 hrs

• SQL

Bonus6.8 hrs

• Complex Data Types Lecture
• Complex Data Types Lab
• Slowly Changing Dimensions Lecture
• Slowly Changing Dimensions Lab
• Graph Data Modeling Lecture
• Graph Data Modeling Lab
• Fact Data Modeling Lecture
• Fact Data Modeling Lab
• Data modeling with Date lists Lecture
• Data modeling with Date lists Lab

Tech Talk5.7 hrs

• Tech talk with Andrew Madson
• Tech talk with Gourav Khanijoe
• Tech talk with Carly Taylor
• Tech talk with Jess Ramos
• Tech talk with Madison Schott
• Tech talk with Vaishali Macwan
• Tech talk with Tim Chan

TA Office Hours3.9 hrs

• Office Hour 1
• Office Hour 2
• Office Hour 3
• Office Hour 4