Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server: Change Data Capture

via Pluralsight

Overview

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.

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.

Syllabus

  • Introduction 7mins
  • Configuring Change Data Capture 13mins
  • Querying Change Data Using Transact-SQL 33mins
  • Administration 22mins
  • Performance Tuning and Optimization 24mins
  • SQL Server 2012 SSIS Components 28mins

Taught by

Jonathan Kehayias

Reviews

4.3 rating at Pluralsight based on 168 ratings

Start your review of SQL Server: Change Data Capture

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.