SSIS Design Patterns for Data Warehousing
Pluralsight
Course Summary
Learn about the most popular design patterns used in data warehousing. This course will show how to solve common SSIS problems with designs tested and used by others in the industry.
-
+
Course Description
Over time, certain designs have emerged in SSIS as the best way to solve particular types of problems. These have become best practices, and can be used in your environment as well. In this course, you will learn about the most common patterns used in data warehousing, which are also applicable to non-data warehouse situations.
-
+
Course Syllabus
Introduction and Setup- 18m 20s
—Introduction 3m 50s
—What You Need to Run the Demos 7m 3s
—Setting up the Sample Database 7m 26sBasic Design Patterns Part 1- 46m 29s
—Truncate and Load Pattern 10m 29s
—SCD Type 1 Pattern 15m 28s
—SCD Type 2 Pattern 20m 31sBasic Design Patterns Part 2- 25m 27sAdvanced Design Patterns Part 1- 25m 24sAdvanced Design Patterns Part 2- 24m 46sFact Pattern, Master/Child Patterns- 30m 17s
This course is listed under
Development & Implementations
, Data & Information Management
, Networks & IT Infrastructure
and Server & Storage Management
Community
Related Posts:
