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.
Optimizing a Data Warehouse on the Microsoft SQL Server Platform
Once a data warehouse is initially created, performance and maintainability come into question. In this course, you'll explore SQL Server and the tools and resources needed to efficiently optimize a data warehouse.
This Course Includes
pluralsight
4 (13 reviews )
3 hour 4 minutes 
english
Online - Self Paced
Expanded Courses
pluralsight
About Optimizing a Data Warehouse on the Microsoft SQL Server Platform
The resources offered by Microsoft SQL Server are geared towards architects, developers, and administrators in the database realm. In this course, Optimizing a Data Warehouse on the Microsoft SQL Server Platform, you'll delve into the tools and resources available in SQL Server for optimizing a data warehouse. First, you'll explore the options for indexing in a data warehouse. Next, you'll learn how to use Integration Services (SSIS) to import source data into your destination. Then, you'll discover what the database engine includes, such as, table partitioning, various indexes like clustered and columnstore, and bulk insert. Finally, you'll explore documentation options that includes data flows complementing a data dictionary. By the end of this course, you'll have the necessary knowledge needed to effectively optimize your data warehouse on the Microsoft SQL Server platform.
What You Will Learn?
- Course Overview : 2mins.
- Managing Data Warehouse with Best Practices : 4mins.
- Partitioning Data Warehouse Fact Tables : 38mins.
- Indexing Data Warehouse Tables : 35mins.
- Extracting, Transforming, and Loading (ETL) a Data Warehouse : 26mins.
- Cleansing Data in a Data Warehouse : 20mins.
- Centralizing Data with Master Data Management Processes : 36mins.
- Documenting a Data Warehouse : 20mins.