# Dimensional Data Modeling - Slowly-changing Dimensions and idempotent queries with Postgres (Day 2 Lecture)

> In this presentation on dimensional data modeling, we explore idempotent pipelines and slowly changing dimensions.

- Web page: https://julie.techexpert.io/lesson/dimensional-data-modeling-day-2-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: 41 min video
- Skills: SQL, Data Modeling, ETL/ELT, Postgres
- Academy: Julies academy to catch all other programs

## About this lesson

In this presentation on dimensional data modeling, we explore idempotent pipelines and slowly changing dimensions.

## Navigation

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