Analytics Engineering Boot Camp starting April 14th, 2025
Master tools: Iceberg, Snowflake, Airflow, and dbt. Build a capstone project and advance your career!
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
Enroll now
Apr 14, 2025 – May 16, 2025 · Starting soon
Payment plan
$2700
one-timeDuration5 weeks
StartsApr 14, 2025
Time commitment8 hrs / week
FormatLive Online
What's included
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
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 202449 lessons
IncludedAnalytics Engineering Boot Camp starting October 2024
49 lessonsBootcamp 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
SnowflakeAWSEnroll now
Apr 14, 2025 – May 16, 2025 · Starting soon
Payment plan
$2700
one-timeDuration5 weeks
StartsApr 14, 2025
Time commitment8 hrs / week
FormatLive Online
What's included
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
Enroll now
Apr 14, 2025 – May 16, 2025 · Starting soon
Payment plan
$2700
one-timeDuration5 weeks
StartsApr 14, 2025
Time commitment8 hrs / week
FormatLive Online
What's included
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
$2700one-time
One-time