Dimensional Modeling on the Microsoft SQL Server Platform

This course teaches you how to use Microsoft SQL Server and SQL Server Integration Services to design and efficiently load data to your data warehouse. You'll also learn techniques for troubleshooting performance bottlenecks in your ETL.
Course info
Level
Intermediate
Updated
Aug 9, 2019
Duration
3h 10m
Table of contents
Course Overview
Understanding How to Model Dimension Tables
Loading a Dimension Table in SQL Server
Understanding How to Model Fact Tables
Loading a Fact Table Using SSIS
Exploring Incremental ETL Options
Loading Data Incrementally Using Change Data Capture
Loading Data Incrementally Using Change Tracking
Exploring Options for Modeling Many-to-many Relationships
Description
Course info
Level
Intermediate
Updated
Aug 9, 2019
Duration
3h 10m
Description

A properly designed dimensional model is essential to delivering large volumes of data in a fast and easily understood manner. In this course, Dimensional Modeling on the Microsoft SQL Server Platform, you'll learn how to design and efficiently load dimensions, facts, and bridge tables on the Microsoft SQL Server platform. First, you’ll learn about type 1, 2, and 3 slowly changing dimensions and several methods for loading data into these dimensions. Then, you’ll discover how to use SSIS to load data into fact tables along with several options to process data incrementally, including 2 built-in Microsoft technologies: Change Data Capture and Change Tracking. Finally, you'll explore modeling techniques to handle many-to-many relationships. When you’re finished with this course, you'll have the skills and knowledge to design a proper dimensional model and load data efficiently using the Microsoft SQL Server platform.

About the author
About the author

Christopher has been a BI Engineer for over 10 years, focusing on data warehousing solutions using SQL Server’s BI stack.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Christopher Smith, and welcome to my course, Dimensional Modeling on the Microsoft SQL Server Platform. Dimensional modeling was first introduced by Ralph Kimball in 1996, when he published a book called the Data Warehouse Toolkit. Since then, the concept has widely been accepted as the leading architecture for designing a data warehouse. In this course, we're going to learn how to use Microsoft SQL Server and SQL Server Integration Services to design and efficiently populate dimension, fact, and bridge tables. Some of the major topics that we will cover include common components that are found in dimension and fact tables, and why they're important, several techniques to handle Slowly Changing Dimensions, five methods to incrementally process data in your ETL, including two built-in Microsoft technologies, change data capture and change tracking, how to troubleshoot and resolve bottlenecks in your ETL, and several techniques to model many-to-many relationships. By the end of this course, you'll have a solid understanding of how to use the Microsoft SQL Server platform to design and efficiently load data to your data warehouse. Before beginning this course, you should have an entry-level understanding of dimensional modeling and SQL Server Integration Services. I hope you'll join me on this journey to learn dimensional modeling with the Dimensional Modeling on the Microsoft SQL Server Platform course, at Pluralsight.