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

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