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

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

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 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

Intro to SQL 101

academy/5/course/1410/mastering_sql_and_python_for_data_engineering_success/transcription.json

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

SQL

Boot Camp: Community Edition