SQL Server: Change Data Capture

Learn how to capture SQL Server table data changes for downstream consumption using the Change Data Capture feature of SQL Server. This course is applicable to developers, DBAs, and architects on SQL Server 2008 onward.
More
Learn how to capture SQL Server table data changes for downstream consumption using the Change Data Capture feature of SQL Server. This course is applicable to developers, DBAs, and architects on SQL Server 2008 onward.
More
Introduction
7m 9s
Administration
22m 58s
Of all the methods of tracking and storing changing data in SQL Server, the Change Data Capture (CDC) feature is by far the most flexible and easiest to implement. This course focuses on the implementation of CDC in SQL Server 2008 and higher, and includes topics such as configuration, querying change data, managing schema changes after enabling CDC, CDC feature compatibility, backup and restore considerations, performance tuning and optimization of CDC, and using the SQL Server 2012+ SSIS CDC components to perform ETL/ELT processing of change data into a data warehouse. The course is perfect for developers, DBAs, and architects on SQL Server 2008 onward, who need to capture SQL Server table data changes for downstream consumption.
Table of Contents
Introduction
7m 9s
Administration
22m 58s
Description
Of all the methods of tracking and storing changing data in SQL Server, the Change Data Capture (CDC) feature is by far the most flexible and easiest to implement. This course focuses on the implementation of CDC in SQL Server 2008 and higher, and includes topics such as configuration, querying change data, managing schema changes after enabling CDC, CDC feature compatibility, backup and restore considerations, performance tuning and optimization of CDC, and using the SQL Server 2012+ SSIS CDC components to perform ETL/ELT processing of change data into a data warehouse. The course is perfect for developers, DBAs, and architects on SQL Server 2008 onward, who need to capture SQL Server table data changes for downstream consumption.
Course info
Level
Intermediate
Rating
(148)
Duration
2h 10m
Updated
27 Mar 2015
Course authors

Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years.

Share course