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

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

Postgres

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 Lab

Dimensional Data Modeling: Graph Data Modeling Day 3 Lab

Quiz

Quiz

Quiz

Quiz

Quiz