Save for later
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.
Get a Reminder
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Microsoft SQL Engineer for Mobility $73k
Microsoft CSR $81k
Microsoft SQL Server DBA $103k
SDE in Microsoft $106k
Microsoft SQL DBA $108k
Microsoft SQL Server Database Administrator $109k
Microsoft SQL Server Developer $109k
SDE @ Microsoft 5 $110k
Microsoft Engineer 3 $126k
Microsoft SQL Database Administrator Lead $128k
Microsoft SQL Developer $130k
Senior Microsoft SQL Database Administrator $148k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course