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

> In this lab, we construct a Slowly Changing Dimension (SCD) table design for dimensional data modeling.

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

## About this lesson

In this lab, we construct a Slowly Changing Dimension (SCD) table design for dimensional data modeling.

## Navigation

- Previous lesson: [Dimensional Data Modeling - Graph Data Modeling with Postgres (Day 3 Lab)](https://julie.techexpert.io/lesson/dimensional-data-modeling-day-3-lab-v2.md)
- Next 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)