Analytics Engineering Boot Camp starting October 2024
Start Date
Oct 22, 2024
End Date
Nov 18, 2024
Status
Not Enrolled
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
Program Structure
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
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
4
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
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
9
Tech Talk
7 Lessons•5h 40m
10
TA Office Hours
4 Lessons•3h 56m