This boot camp will help you get the fundamentals needed to be a great data engineer!

Dimensional Data Modeling Homework Submission

Fact Data Modeling Assignment Submission

Analytical Patterns Homework Submission

Data Pipeline Maintenance Homework Submission

In this lecture, we talk about one big table vs relational vs dimensional data modeling and their tradeoffs!

Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lecture

academy/5/course/658/dimensional-data-modeling-lecture-day-1-yt-transcript.json

In this video will be building a cumulative table design (https://github.com/EcZachly/cumulative-table-design) with complex data types STRUCT and ARRAY. 
We will take the table player_seasons and create a new table called players that holds onto an historical record of all NBA players and the seasons that they played! 

Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab

academy/5/course/659/dimensional_data_modeling_day_1_lab/dimensional_data_modeling_day_1_lab.json

We cover slowly changing dimensions and idempotent pipelines in this lecture! Enjoy! 

Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lecture

academy/5/course/660/dimensional-data-modeling-day-2-lecture-yt-transcript.json

In this video we build an slowly changing dimension type 2 model on top of the players table we built in the first lab! 

Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab

academy/5/course/661/dimensional-data-modeling-day-2-lab-yt-transcript.json

In this lecture we talk about dimensional additivity and how to build a flexible data model ready for graph database consumption!

Dimensional Data Modeling: Graph Data Modeling Day 3 Lecture

academy/5/course/666/dimensional-data-modeling-day-3-lecture-yt-transcript.json

In this lab, we build a network of NBA players and see who they play against/with the most and for which teams!

Dimensional Data Modeling: Graph Data Modeling Day 3 Lab

academy/5/course/667/dimensional-data-modeling-day-3-lab-yt-transcript.json

In this hands-on lab session, we embark on a practical journey of growth accounting. The video guides you through the step-by-step process, illustrating how to create a partition column, calculate active dates, and adeptly track state transitions.

Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab

academy/5/course/671/applying-analytical-patterns-day-1-lab-yt-transcript.json

In this presentation, Zach explores a range of topics related to Advanced SQL Analytical Patterns. The discussion covers the application of recursive CTEs, count case when, grouping sets, cross join unnest, cube, rollup, and window functions.

Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture

academy/5/course/672/applying-analytical-patterns-day-2-lecture-yt-transcript.json

Explore the dynamic world of data engineering in this insightful video. Zach shares a wealth of experiences and insights, addressing key challenges faced in the field.

Data Pipeline Maintenance: Navigating the Complexities of Data Engineering Day 1 Lecture

academy/5/course/686/data-pipeline-maintenance-day-1-lecture-yt-transcript.json

In this lab we look at bootcamp.nba_player_seasons and do GROUP BY, JOIN, and WITH to make different queries!

GROUP BY, JOIN, and Common Table Expression Lab

academy/5/course/1411/draft2compressed/transcription.json

Data Modeling Basics

academy/5/course/1516/mastering_data_modeling__a_comprehensive_guide_for_data_engineers_/transcription.json

Data Modeling

Boot Camp: Community Edition

Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lecture

Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab

Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lecture

Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab

Dimensional Data Modeling: Graph Data Modeling Day 3 Lecture

Dimensional Data Modeling: Graph Data Modeling Day 3 Lab

Dimensional Data Modeling Homework Submission

Quiz

Quiz

Quiz

Quiz

Quiz

Quiz

Quiz

Fact Data Modeling Assignment Submission

Quiz

Quiz

Quiz

Quiz

Quiz

Quiz

Quiz

Quiz

Quiz

Quiz

Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab

Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture

Analytical Patterns Homework Submission

Quiz

Quiz

Quiz

Quiz

Quiz

Data Pipeline Maintenance: Navigating the Complexities of Data Engineering Day 1 Lecture

Data Pipeline Maintenance Homework Submission

Quiz

Quiz

Quiz

Quiz

The Absolutely Free Beginner Data Engineering Boot Camp starting August 14th

GROUP BY, JOIN, and Common Table Expression Lab

Data Modeling Basics