Analytics Engineering Boot Camp starting October 2024

Zach Wilson

Taught by Zach Wilson

Founder at DataExpert.io

What you'll learn

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

Learn directly from the experts

Zach Wilson

Zach Wilson

Founder at DataExpert.io

I have led teams of data engineers and software engineers at Airbnb, Facebook, and Netflix. My next goal is to upskill as many data knowledge workers as I can!

Course syllabus

49 lessons • 36+ hours of content • 6 assignments

Bootcamp Kickoff
1
Analytics Engineering Bootcamp Kickoff
2
Capstone Requirements
3
Understanding Capstone Requirements
Pipeline Spec Building + Airflow Fundamentals
1
Write a comprehensive pipeline spec document
2
Write a comprehensive pipeline spec document Lab
3
Orchestration and Airflow Fundamentals Lecture
4
Orchestration and Airflow Fundamentals Lab
Change Data Capture (CDC) and Analytical Patterns
1
Change Data Capture (CDC) and Snowflake basics Lecture
2
Change Data Capture (CDC) and Snowflake basics Lab
3
How to use snowpark and Snowflake optimization Lecture
4
How to use snowpark and Snowflake optimization Lab
5
Growth Accounting Models Lecture
6
Growth Accounting Models Lab
7
Grouping sets and Window functions Lecture
8
Grouping sets and Window functions Lab
dbt basics
1
dbt basics: How dbt works: sources, models, packages Lecture
2
dbt basics: How dbt works: sources, models, packages Lab
3
dbt basics: creating a full dbt project lecture
4
dbt basics: creating a full dbt project lab
Advanced dbt
1
Advanced dbt: Understanding incremental models Lecture
2
Advanced dbt: Understanding incremental models Lab
3
Advanced pipelines: Blue-green and WAP with Airflow Lecture
4
Advanced pipelines: Blue-green and WAP with Airflow Lab
Advanced Snowflake
1
Advanced snowflake: Deploying the Capstone dag Lecture
2
Advanced snowflake: Deploying the Capstone dag Lab
3
Advanced Snowflake: Data Modeling and UDFs Lecture
4
Advanced Snowflake: Data Modeling and UDFs Lab
Passing Analytics Engineer Interviews
1
SQL
Bonus
1
Complex Data Types Lecture
2
Complex Data Types Lab
3
Slowly Changing Dimensions Lecture
4
Slowly Changing Dimensions Lab
5
Graph Data Modeling Lecture
6
Graph Data Modeling Lab
7
Fact Data Modeling Lecture
8
Fact Data Modeling Lab
9
Data modeling with Date lists Lecture
10
Data modeling with Date lists Lab
Tech Talk
1
Tech talk with Andrew Madson
2
Tech talk with Gourav Khanijoe
3
Tech talk with Carly Taylor
4
Tech talk with Jess Ramos
5
Tech talk with Madison Schott
6
Tech talk with Vaishali Macwan
7
Tech talk with Tim Chan
TA Office Hours
1
Office Hour 1
2
Office Hour 2
3
Office Hour 3
4
Office Hour 4

Program Resources

See what you'll be working with

Homework overview

Weekly schedule

Before you join

Prerequisites

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