Featured resource
2026 Tech Forecast
2026 Tech Forecast

1,500+ tech insiders, business leaders, and Pluralsight Authors share their predictions on what’s shifting fastest and how to stay ahead.

Download the forecast
  • Course

Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses

The process of getting data from a transactional system to a data warehouse is not simple. This course will teach you various ways of identifying changed data and loading those changes without unnecessary impact on source or destination.

Intermediate
1h 36m

Created by Gail Shaw

Last Updated Nov 18, 2026

Course Thumbnail
  • Course

Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses

The process of getting data from a transactional system to a data warehouse is not simple. This course will teach you various ways of identifying changed data and loading those changes without unnecessary impact on source or destination.

Intermediate
1h 36m

Created by Gail Shaw

Last Updated Nov 18, 2026

Get started today

Access this course and other top-rated tech content with one of our business plans.

Try this course for free

Access this course and other top-rated tech content with one of our individual plans.

This course is included in the libraries shown below:

  • Data
What you'll learn

In modern business intelligence applications, out of date data is useless data. Correctly and optimally loading changes into a data warehouse is essential to the success of any BI project. In this course, Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses, you’ll gain the ability to implement such a loading strategy. First, you’ll explore multiple ways to identify changed data. Next, you’ll discover optimal ways to load that into the destination. Finally, you’ll learn how to monitor, audit, and re-run load jobs without causing more problems. When you’re finished with this course, you’ll have the skills and knowledge of data warehouse loading needed to succeed in any data warehouse project.

Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses
Intermediate
1h 36m
Table of contents

About the author
Gail Shaw - Pluralsight course - Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses
Gail Shaw
8 courses 4.6 author rating 340 ratings

Gail Shaw is a Data Platform MVP and holds the MCM certification for SQL Server. Her specialties are in performance tuning and database recovery for SQL Server. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and often speaks at SQLBits and the PASS Community Summit.

2025 Forrester Wave™ names Pluralsight as a Leader among tech skills dev platforms

See how our offering and strategy stack up.

forrester wave report