Analytics Engineering Boot Camp starting October 2024
Overview
Lessons
Credentials
Start Date
Oct 22, 2024
End Date
Nov 18, 2024
This program is not accepting enrollments right now!
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
Prerequisites
Basic SQL knowledge
Previous experience as data analyst, data engineer or data scientist
Course Contents
1
Bootcamp Kickoff
3 Lessons (2h 10m)
2 Assignments
2
Pipeline Spec Building + Airflow Fundamentals
4 Lessons (2h 48m)
1 Assignment
3
Change Data Capture (CDC) and Analytical Patterns
8 Lessons (5h 30m)
Lessons
Change Data Capture (CDC) and Snowflake basics Lecture *58m
58mChange Data Capture (CDC) and Snowflake basics Lab *40m
40mHow to use snowpark and Snowflake optimization Lecture *48m
48mHow to use snowpark and Snowflake optimization Lab *25m
25mGrowth Accounting Models Lecture *51m
51mGrowth Accounting Models Lab *38m
38mGrouping sets and Window functions Lecture *30m
30mGrouping sets and Window functions Lab *38m
38m4
dbt basics
4 Lessons (2h 36m)
1 Assignment
5
Advanced dbt
4 Lessons (2h 40m)
1 Assignment
6
Advanced Snowflake
4 Lessons (2h 38m)
1 Assignment
7
Passing Analytics Engineer Interviews
Lessons
8
Bonus
10 Lessons (6h 46m)
Lessons
Complex Data Types Lecture 48m
48mComplex Data Types Lab 30m
30mSlowly Changing Dimensions Lecture *46m
46mSlowly Changing Dimensions Lab *37m
37mGraph Data Modeling Lecture 38m
38mGraph Data Modeling Lab 42m
42mFact Data Modeling Lecture *46m
46mFact Data Modeling Lab *37m
37mData modeling with Date lists Lecture 38m
38mData modeling with Date lists Lab 39m
39m9
Tech Talk
7 Lessons (5h 40m)
10
TA Office Hours
4 Lessons (3h 56m)
Ready to Start Your Journey?
Join thousands of students who have already transformed their careers with this program.
This program is not accepting enrollments right now!