Simple play icon Course

Advanced Integration Services

by Stacia Misner Varga

This course teaches how to work with Integration Services packages in the context of a data warehouse development project to perform extract, transform, and load operations.

What you'll learn

This course explains how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse.

It covers design patterns for staging data and for loading data into fact and dimension tables. In addition, this course describes how to enhance ETL packages with data cleansing techniques and offers insight into the buffer architecture of the data flow engine to help package developers get the best performance from packages.

This course was written for SQL Server 2012 Integration Services, but most principles apply to SQL Server 2005 and later.

Before taking this course, you should be familiar with SSIS basics

Table of contents

About the author

Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

Ready to upskill? Get started