# Dimensional Data Modeling - Complex Data Types Arrays and Structs with Postgres (Day 1 Lecture)

> In this presentation, we discuss the fundamental concepts of cumulative table design, the strategic use of complex data types like STRUCTS and ARRAYS, tradeoff between compactness and usability, and the challenges posed by temporal cardinality explosions in data representation.

- Web page: https://julie.techexpert.io/lesson/dimensional-data-modeling-day-1-lecture-v2
- Program: [Data Engineering Boot Camp V2 Combined Track](https://julie.techexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 1: Dimensional Data Modeling in Postgres (v2)
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 54 min video
- Skills: SQL, Data Modeling, Postgres
- Academy: Julies academy to catch all other programs

## About this lesson

In this presentation, we discuss the fundamental concepts of cumulative table design, the strategic use of complex data types like STRUCTS and ARRAYS, tradeoff between compactness and usability, and the challenges posed by temporal cardinality explosions in data representation.

## Navigation

- Previous lesson: [Dimensional Data Modeling - Slowly-changing Dimensions and idempotent queries with Postgres (Day 2 Lecture)](https://julie.techexpert.io/lesson/dimensional-data-modeling-day-2-lecture-v2.md)
- Next lesson: [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lab)](https://julie.techexpert.io/lesson/dimensional-data-modeling-day-1-lab-v3.md)