Winter 2026 Analytics Engineering Camp
Master Snowflake and dbt like a pro in 5 weeks!
Start Date
Jan 6, 2026
End Date
Feb 6, 2026
Status
Not Enrolled
This program is not accepting enrollments right now!
What You'll Learn
- Lifetime Access to Content
- 5 guest speaker sessions
- Join a vibrant learning community
- Join our referral network for jobs
- Bulid a standout capstone project
- Best for Analysts looking to become Data Engineers or Data Engineers looking to upskill
Prerequisites
- Basic SQL skills
Program Structure
1
Bootcamp Kick off
3 Lessons•1h 55m
2
Airflow
5 Lessons•4h 0m
1 Assignment
3
Mastering Analytical Patterns
6 Lessons•3h 31m
2 Assignments
4
dbt basics
4 Lessons•4h 21m
1 Assignment
5
advanced dbt
4 Lessons•4h 16m
1 Assignment
6
Advanced Snowflake
4 Lessons•3h 25m
1 Assignment
7
Q&A with Zach
5 Lessons•4h 38m
8
Tech Talks
5 Lessons•4h 52m
9
TA Office hours
8 Lessons•6h 18m
10
Career Dev Sessions
5 Lessons•1h 57m
11
Book Club
12
Data Modeling on Iceberg
6 Lessons•4h 14m
13
Data Modeling on Snowflake
6 Lessons•3h 58m
Lessons
Conceptual Data Modeling Lecture Day 1
38m
Conceptual Data Modeling Lab Day 1
39m
How to use Snowpark and Snowflake Optimizations Lecture Day 2
41m
How to use Snowpark and Snowflake Optimizations Lab Day 2
45m
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
34m
Advanced Snowflake Data Modeling and UDFs Lab Day 3
39m
14
Capstone Project
2 Assignments
Other Included Cohorts
Analytics Engineering Boot Camp starting October 2024
15
Bootcamp Kickoff
3 Lessons•2h 10m
2 Assignments
16
Pipeline Spec Building + Airflow Fundamentals
4 Lessons•2h 48m
1 Assignment
17
Change Data Capture (CDC) and Analytical Patterns
8 Lessons•5h 30m
Lessons
Change Data Capture (CDC) and Snowflake basics Lecture
58m
Change Data Capture (CDC) and Snowflake basics Lab
40m
How to use snowpark and Snowflake optimization Lecture
48m
How to use snowpark and Snowflake optimization Lab
25m
Growth Accounting Models Lecture
51m
Growth Accounting Models Lab
38m
Grouping sets and Window functions Lecture
30m
Grouping sets and Window functions Lab
38m
18
dbt basics
4 Lessons•2h 36m
1 Assignment
19
Advanced dbt
4 Lessons•2h 40m
1 Assignment
20
Advanced Snowflake
4 Lessons•2h 38m
1 Assignment
21
Passing Analytics Engineer Interviews
Lessons
22
Bonus
10 Lessons•6h 46m
Lessons
Complex Data Types Lecture
48m
Complex Data Types Lab
30m
Slowly Changing Dimensions Lecture
46m
Slowly Changing Dimensions Lab
37m
Graph Data Modeling Lecture
38m
Graph Data Modeling Lab
42m
Fact Data Modeling Lecture
46m
Fact Data Modeling Lab
37m
Data modeling with Date lists Lecture
38m
Data modeling with Date lists Lab
39m
23
Tech Talk
7 Lessons•5h 40m
24
TA Office Hours
4 Lessons•3h 56m
Analytics Engineering Boot Camp starting April 14th, 2025
15
Data Modeling on Iceberg
6 Lessons•4h 43m
1 Assignment
16
Data Modeling on Snowflake
6 Lessons•5h 11m
1 Assignment
Lessons
Conceptual Data Modeling Lecture Day 1
57m
Conceptual Data Modeling Lab Day 1
51m
How to use Snowpark and Snowflake Optimizations Lecture Day 2
52m
How to use Snowpark and Snowflake Optimizations Lab Day 2
45m
Advanced Snowflake Data Modeling and UDFs Lecture Day 3
47m
Advanced Snowflake Data Modeling and UDFs Lab Day 3
58m
Assignments
17
Snowflake + dbt basics
4 Lessons•3h 50m
1 Assignment
18
Advanced dbt
4 Lessons•3h 46m
1 Assignment
19
End-to-End Project Hacking
4 Lessons•4h 54m
2 Assignments
20
Q&A With Zach Wilson
4 Lessons•3h 21m
21
TA Office Hours
6 Lessons•5h 39m
22
Tech Talks
8 Lessons•7h 19m
23