# Change Data Capture Lab

> Change Data Capture (CDC) is crucial for tracking data changes in real-time, and this lab focuses on implementing it using database triggers. Participants will learn how to create an audit tracking table for time zone changes, utilize PostgreSQL with DataGrip, and set up triggers to capture updates…

- Web page: https://www.dataexpert.io/lesson/changedatacapturelab-jan2026-p735-l1904
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 7: Analytical Patterns & CDC
- Access: Requires enrollment in AnalyticsExpert
- Length: 14 min video
- Skills: SQL, Data Modeling, ETL/ELT, Airflow, Postgres
- Academy: DataExpert.io Academy

## About this lesson

Change Data Capture (CDC) is crucial for tracking data changes in real-time, and this lab focuses on implementing it using database triggers. Participants will learn how to create an audit tracking table for time zone changes, utilize PostgreSQL with DataGrip, and set up triggers to capture updates efficiently. This lesson benefits data engineers and analysts looking to enhance their skills in CDC and understand the implications of real-time data tracking in production environments.

## Navigation

- Previous lesson: [Mastering Change Data Capture (CDC)](https://www.dataexpert.io/lesson/masteringchangedatacapturecdc-jan2026-p735-l1902.md)
- Next lesson: [Snowflake and Glue Catalog Integration Lab](https://www.dataexpert.io/lesson/snowflakeandgluecatalogintegrationlab-jan2026-p735-l2005.md)