When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Cloud
pluralsight logo

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.

     
  • 4
    •  |
  • Reviews ( 48 )
Free
Dimensional Modeling on the Microsoft SQL Server Platform

Related Courses

This Course Includes

  • iconpluralsight
  • icon4 (48 reviews )
  • icon3 hour 9 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconExpanded Courses
  • iconpluralsight

About Dimensional Modeling on the Microsoft SQL Server Platform

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.

What You Will Learn?

  • Course Overview : 1min.
  • Understanding How to Model Dimension Tables : 16mins.
  • Loading a Dimension Table in SQL Server : 40mins.
  • Understanding How to Model Fact Tables : 15mins.
  • Loading a Fact Table Using SSIS : 36mins.
  • Exploring Incremental ETL Options : 25mins.
  • Loading Data Incrementally Using Change Data Capture : 21mins.
  • Loading Data Incrementally Using Change Tracking : 16mins.
  • Exploring Options for Modeling Many-to-many Relationships : 16mins.