# Dimensional Data Modeling - Slowly-changing Dimensions and idempotent queries with Trino (Day 2 Lab) - Pre-recorded from V3

> This is a pre-recorded lesson from V3. In this lab, we reinforce lecture concepts with a hands-on approach. We dive into implementing a Slowly Changing Dimension (SCD) table. Learn to track user activity changes using lag functions and identify active and inactive player seasons. We also tackle com…

- Web page: https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lab-v4
- Program: [Data Engineering Mastery Course](https://www.dataexpert.io/program/data-engineering-mastery-course)
- Module: Week 1: Dimensional Data Modeling in Iceberg
- Access: Requires enrollment in Data Engineering Mastery Course
- Length: 37 min video
- Skills: SQL, Data Modeling, ETL/ELT, Trino
- Academy: DataExpert.io Academy

## About this lesson

This is a pre-recorded lesson from V3. In this lab, we reinforce lecture concepts with a hands-on approach. We dive into implementing a Slowly Changing Dimension (SCD) table. Learn to track user activity changes using lag functions and identify active and inactive player seasons. We also tackle common errors in query optimization, providing practical solutions for a real-world understanding. Watch the video for step-by-step guidance on implementing SCDs in your data pipelines. [Recorded Nov 8, 2023]

## Navigation

- Previous lesson: [Dimensional Data Modeling - Slowly-changing Dimensions and Idempotent Queries in Iceberg (Day 2 Lecture) - Pre-recorded from V3](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lecture-v4.md)
- Next lesson: [Conceptual Data Modeling (Day 3 Lecture)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-3-lecture-v4.md)