SSIS Design Patterns for Data Warehousing

by Robert Cain

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.

Preview this course

What you'll learn

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.

Table of contents

Introduction and Setup
18mins
Basic Design Patterns Part 1
46mins
Basic Design Patterns Part 2
25mins
Advanced Design Patterns Part 1
25mins
Advanced Design Patterns Part 2
25mins
Fact Pattern, Master/Child Patterns
31mins

About the author

Robert Cain

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, teleco... more

See more courses by Robert Cain
Ready to upskill? Get started