Analytics Engineering Boot Camp starting April 14th, 2025
Master tools: Iceberg, Snowflake, Airflow, and dbt. Build a capstone project and advance your career!
Start Date
Apr 14, 2025
End Date
May 16, 2025
Status
Not Enrolled
This program is not accepting enrollments right now!
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
Prerequisites
- Proficiency in Python and SQL
- Commitment to Learning Quickly
Program Structure
1
Data Modeling on Iceberg
7 Lessons•5h 36m
1 Assignment
2
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
3
Snowflake + dbt basics
4 Lessons•3h 50m
1 Assignment
4
Advanced dbt
4 Lessons•3h 46m
1 Assignment
5
End-to-End Project Hacking
4 Lessons•4h 54m
2 Assignments
6
Q&A With Zach Wilson
4 Lessons•3h 21m
7
TA Office Hours
6 Lessons•5h 39m
8
Tech Talks
8 Lessons•7h 19m
9
Career Development
Other Included Cohorts
Analytics Engineering Boot Camp starting October 2024
10
Bootcamp Kickoff
3 Lessons•2h 10m
2 Assignments
11
Pipeline Spec Building + Airflow Fundamentals
4 Lessons•2h 48m
1 Assignment
12
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
13
dbt basics
4 Lessons•2h 36m
1 Assignment
14
Advanced dbt
4 Lessons•2h 40m
1 Assignment
15
Advanced Snowflake
4 Lessons•2h 38m
1 Assignment
16
Passing Analytics Engineer Interviews
Lessons
17
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
18
Tech Talk
7 Lessons•5h 40m
19
TA Office Hours
4 Lessons•3h 56m