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.
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.
Course Overview [Autogenerated] Hi, everyone. My name is Thomas Oblong and welcome to my course, optimizing a data warehouse on the sequel server platform. I'm a product manager at idea. I worked with the wear escape products for data warehouse automation tools. Working with data warehouses and sequel server tools has been ongoing with me for over 20 years. In this course, we're gonna look at the tools and resource is available in sequel server for optimizing a data warehouse. The tools are geared towards architect's developers and administrators in the database round the enterprise information management terminology was created for items like master data, data quality and extract. Transform and load Our e t l. This was all created for data warehouses. Some of the major topics that we're going to cover in this course include options for indexing in a data warehouse using integration Service's are S S, I s for importing of source data into a destination. Master data management with Master Data Service is cleansing data with data quality service is and documentation options, including a data diagram. By the end of this course, you will know how to cleanse data with S s. I s including a data quality service component. You will also use Excel toe Add data. You'll be able to diagram a database or data warehouse structure and show the source and target columns. You will also be able to enhance indexes on a data warehouse database before beginning this course. You should be familiar with these sequel server management studio sequel server data tools, creating indexes and tables, as well as data warehouse structure concepts. I hope you'll join me to learn more about data warehouse tools when we go through the course, optimizing a data warehouse on the Microsoft sequel server platform.