Analytics Engineering Boot Camp starting April 14th, 2025

Master tools: Iceberg, Snowflake, Airflow, and dbt. Build a capstone project and advance your career!

• 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

Platform Access Included:

Snowflake

AWS

PrerequisitesCurriculaHomeworkSchedule

• Proficiency in Python and SQL
• Commitment to Learning Quickly

• Proficiency in Python and SQL
• Commitment to Learning Quickly

Main Content

Data Modeling on Iceberg5.6 hrs

• Apache Iceberg Lecture Day 1 - Updated
• Apache Iceberg Lab Day 1
• Apache Iceberg Lecture Day 2
• Apace Iceberg Lab Day 2
• Apache Iceberg Lecture Day 3
• Apache iceberg Lab Day 3
• Apache Iceberg Lecture Day 1

Data Modeling on Snowflake5.2 hrs

• Conceptual Data Modeling Lecture Day 1
• Conceptual Data Modeling Lab Day 1
• How to use Snowpark and Snowflake Optimizations Lecture Day 2
• How to use Snowpark and Snowflake Optimizations Lab Day 2
• Advanced Snowflake Data Modeling and UDFs Lecture Day 3
• Advanced Snowflake Data Modeling and UDFs Lab Day 3

Snowflake + dbt basics3.8 hrs

• dbt basics Day 1 Lecture
• dbt basics Day 1 Lab
• dbt basics Day 2 Lecture
• dbt basics Day 2 Lab

Advanced dbt3.8 hrs

• Advanced dbt Lecture Day 1
• Advanced dbt Lab Day 1
• Advanced dbt Lecture Day 2
• Advanced dbt Lab Day 2

End-to-End Project Hacking4.9 hrs

• Capstone Project Day 1 Lecture
• Capstone Project Day 1 Lab
• Capstone Project Day 2 Class
• Capstone Project Day 3 Class

Q&A With Zach Wilson3.4 hrs

• Q&A with Zach Week 1
• Q&A with Zach Week 2
• Q&A with Zach Week 3
• Q&A with Zach Week 4

TA Office Hours5.7 hrs

• TA Office Hour 1
• TA Office Hour 2
• TA Office Hour 3
• TA Office Hour 4
• TA Office Hour 5
• TA Office Hour 6

Tech Talks7.3 hrs

• Tech Talk 1 - Jess Ramos
• Tech Talk 2 - Madison
• Tech Talk 3 - Ben Rogojan
• Tech Talk 4 - John Kutay
• Tech Talk 5 - Carly Taylor
• Tech Talk 6 - Vin Vashishtha
• Tech Talk 7 - Parth Parekh
• Tech Talk 8 - Prasad Rao

Career Development0.8 hrs

• Build-a-Resume!
• LinkedIn Like Pro!

Included Cohorts

Analytics Engineering Boot Camp starting October 202435 hrs

• Bootcamp Kickoff (2.2 hrs)
• Pipeline Spec Building + Airflow Fundamentals (2.8 hrs)
• Change Data Capture (CDC) and Analytical Patterns (5.5 hrs)
• dbt basics (2.6 hrs)
• Advanced dbt (2.7 hrs)
• Advanced Snowflake (2.6 hrs)
• Passing Analytics Engineer Interviews
• Bonus (6.8 hrs)
• Tech Talk (5.7 hrs)
• TA Office Hours (3.9 hrs)