Advanced Integration Services

Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Data Warehousing Packages, Part I- 57m 46s
—Introduction 1m 17s
—Introduction to Data Warehousing 4m 32s
—Dimensional Modeling 5m 41s
—Data Profiling 2m 5s
—Demo: Data Profiling 8m 22s
—ETL Design Patterns 2m 58s
—Extract Package 3m 57s
—Demo: Extracting to Staging Tables 12m 4s
—Load Patterns 1m 50s
—Fact Extract for Ongoing Load 3m 16s
—Demo: Extracting Records Since Last Load 7m 58s
—Summary 3m 46sData Warehousing Packages, Part II- 49m 34s
—Introduction 0m 51s
—Slowly Changing Dimensions 2m 52s
—Dimension Load Patterns: Type 0, Type 1, and Type 2 4m 42s
—Dimension Load Package 0m 54s
—Demo: Transforming and Loading Data for Type 0 7m 25s
—Demo: Loading Data with the Slowly Changing Dimension Wizard 13m 34s
—Fact Table Design Patterns 1m 39s
—Demo: Performing ETL for a Fact Table 6m 33s
—Demo: Selecting Data for Ongoing Fact Table Load 1m 41s
—Analysis Services Objects 0m 52s
—Demo: Using the Analysis Services Task 4m 22s
—Demo: Orchestrating the ETL Process 2m 38s
—Summary 1m 31sData Cleansing- 1h 13mPackage Performance- 38m 45s