Analytics Engineering Boot Camp starting April 14th, 2025

Master tools: Iceberg, Snowflake, Airflow, and dbt. Build a capstone project and advance your career!

Zach Wilson

Taught by Zach Wilson

Founder at DataExpert.io

What you'll learn

5 weeks of live classes
One year access to Cloud Tools
Deploy Airflow pipelines in the Cloud
Master data modeling and architecture
Lifetime Access to Content
Weekly Q&A with Zach
Engaging Capstone Project
5 Speaker Sessions with industry experts
Over 50% hands on learning
Weekly Resume and Interview Help Sessions

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

93 lessons • 75+ hours of content • 12 assignments

Data Modeling on Iceberg
1
Apache Iceberg Lecture Day 1
2
Apache Iceberg Lab Day 1
3
Apache Iceberg Lecture Day 2
4
Apace Iceberg Lab Day 2
5
Apache Iceberg Lecture Day 3
6
Apache iceberg Lab Day 3
Data Modeling on Snowflake
1
Conceptual Data Modeling Lecture Day 1
2
Conceptual Data Modeling Lab Day 1
3
How to use Snowpark and Snowflake Optimizations Lecture Day 2
4
How to use Snowpark and Snowflake Optimizations Lab Day 2
5
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
6
Advanced Snowflake Data Modeling and UDFs Lab Day 3
Snowflake + dbt basics
1
dbt basics Day 1 Lecture
2
dbt basics Day 1 Lab
3
dbt basics Day 2 Lecture
4
dbt basics Day 2 Lab
Advanced dbt
1
Advanced dbt Lecture Day 1
2
Advanced dbt Lab Day 1
3
Advanced dbt Lecture Day 2
4
Advanced dbt Lab Day 2
End-to-End Project Hacking
1
Capstone Project Day 1 Lecture
2
Capstone Project Day 1 Lab
3
Capstone Project Day 2 Class
4
Capstone Project Day 3 Class
Q&A With Zach Wilson
1
Q&A with Zach Week 1
2
Q&A with Zach Week 2
3
Q&A with Zach Week 3
4
Q&A with Zach Week 4
TA Office Hours
1
TA Office Hour 1
2
TA Office Hour 2
3
TA Office Hour 3
4
TA Office Hour 4
5
TA Office Hour 5
6
TA Office Hour 6
Tech Talks
1
Tech Talk 1 - Jess Ramos
2
Tech Talk 2 - Madison
3
Tech Talk 3 - Ben Rogojan
4
Tech Talk 4 - John Kutay
5
Tech Talk 5 - Carly Taylor
6
Tech Talk 6 - Vin Vashishtha
7
Tech Talk 7 - Parth Parekh
8
Tech Talk 8 - Prasad Rao
Career Development
1
Build-a-Resume!
2
LinkedIn Like Pro!

Also included

IncludedAnalytics Engineering Boot Camp starting October 2024
49 lessons

Bootcamp Kickoff

1Analytics Engineering Bootcamp Kickoff
2Capstone Requirements
3Understanding Capstone Requirements

Pipeline Spec Building + Airflow Fundamentals

1Write a comprehensive pipeline spec document
2Write a comprehensive pipeline spec document Lab
3Orchestration and Airflow Fundamentals Lecture
4Orchestration and Airflow Fundamentals Lab

Change Data Capture (CDC) and Analytical Patterns

1Change Data Capture (CDC) and Snowflake basics Lecture
2Change Data Capture (CDC) and Snowflake basics Lab
3How to use snowpark and Snowflake optimization Lecture
4How to use snowpark and Snowflake optimization Lab
5Growth Accounting Models Lecture
6Growth Accounting Models Lab
7Grouping sets and Window functions Lecture
8Grouping sets and Window functions Lab

dbt basics

1dbt basics: How dbt works: sources, models, packages Lecture
2dbt basics: How dbt works: sources, models, packages Lab
3dbt basics: creating a full dbt project lecture
4dbt basics: creating a full dbt project lab

Advanced dbt

1Advanced dbt: Understanding incremental models Lecture
2Advanced dbt: Understanding incremental models Lab
3Advanced pipelines: Blue-green and WAP with Airflow Lecture
4Advanced pipelines: Blue-green and WAP with Airflow Lab

Advanced Snowflake

1Advanced snowflake: Deploying the Capstone dag Lecture
2Advanced snowflake: Deploying the Capstone dag Lab
3Advanced Snowflake: Data Modeling and UDFs Lecture
4Advanced Snowflake: Data Modeling and UDFs Lab

Passing Analytics Engineer Interviews

1SQL

Bonus

1Complex Data Types Lecture
2Complex Data Types Lab
3Slowly Changing Dimensions Lecture
4Slowly Changing Dimensions Lab
5Graph Data Modeling Lecture
6Graph Data Modeling Lab
7Fact Data Modeling Lecture
8Fact Data Modeling Lab
9Data modeling with Date lists Lecture
10Data modeling with Date lists Lab

Tech Talk

1Tech talk with Andrew Madson
2Tech talk with Gourav Khanijoe
3Tech talk with Carly Taylor
4Tech talk with Jess Ramos
5Tech talk with Madison Schott
6Tech talk with Vaishali Macwan
7Tech talk with Tim Chan

TA Office Hours

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

Program Resources

See what you'll be working with

Homework overview

Weekly schedule

Before you join

Prerequisites

Proficiency in Python and SQL
Commitment to Learning Quickly

Platform Access Included

SnowflakeSnowflake
AWSAWS