# Understanding Read Streams and SCD Implementation Lab

> Read streams and slowly changing dimensions (SCD) are crucial for tracking data changes over time. This lab focuses on creating a table to monitor active NBA players and implementing SCD Type 2 using SQL commands like MERGE and INSERT. Participants will learn how to effectively manage data streams,…

- Web page: https://www.dataexpert.io/lesson/understandingreadstreamsandscdimplementationlab-jan2026
- Program: [Winter 2026 Analytics Engineering Camp](https://www.dataexpert.io/program/winter-2026-snowflake-boot-camp)
- Access: Requires enrollment in Winter 2026 Analytics Engineering Camp
- Length: 34 min video
- Skills: SQL, Data Modeling, ETL/ELT
- Academy: DataExpert.io Academy

## About this lesson

Read streams and slowly changing dimensions (SCD) are crucial for tracking data changes over time. This lab focuses on creating a table to monitor active NBA players and implementing SCD Type 2 using SQL commands like MERGE and INSERT. Participants will learn how to effectively manage data streams, materialize changes, and handle player status updates, making it ideal for data engineers and analysts looking to enhance their skills in change data capture and data modeling.

## Navigation

- Previous lesson: [Snowflake and Glue Catalog Integration Lab](https://www.dataexpert.io/lesson/snowflakeandgluecatalogintegrationlab-jan2026.md)
- Next lesson: [Build your first pipeline with dbt](https://www.dataexpert.io/lesson/buildyourfirstpipelinewithdbt-jan2026.md)