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

Pluralsight

Advanced Integration Services

via Pluralsight

Overview

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

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 hep 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.

Syllabus

  • Data Warehousing Packages, Part I 57mins
  • Data Warehousing Packages, Part II 49mins
  • Data Cleansing 73mins
  • Package Performance 38mins

Taught by

Stacia Misner Varga

Reviews

4.5 rating at Pluralsight based on 429 ratings

Start your review of Advanced Integration Services

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.