Expanded

Configuring and Deploying a Data Warehouse on the Microsoft SQL Server Platform

This course will teach you how to increase the efficiency of a Data Warehouse process by scheduling ETL Jobs leveraging the SQL Server Agent.
Course info
Level
Advanced
Updated
Nov 13, 2020
Duration
1h 57m
Table of contents
Course Overview
Preparing a Data Warehouse to Create a Job
Scheduling a Data Warehouse Job
Increasing Performance Speed in a Data Warehouse
Monitoring Performance in a Data Warehouse
Avoiding Accessibility Issues When Data Warehouse Job Is Running
Description
Course info
Level
Advanced
Updated
Nov 13, 2020
Duration
1h 57m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
Description

After Implementing a data warehouse environment, there are issues and processes that come up, making regular data warehouse task inefficient. In this course, Configuring and Deploying a Data Warehouse on the Microsoft SQL Server Platform, you’ll learn to schedule Data Warehouse Jobs within SQL Server as well as how to maintain the jobs. You will also learn what issues you’ll frequently run into in a Data Warehouse environment and how to solve them. First, you’ll explore creating and scheduling jobs to maintain the data warehouse with the SQL Server Agent. Next, you’ll discover identifying performance and logic issues across the warehouse data pipeline. Finally, you’ll learn how to fix the issues that are identified within the data warehouse environment and how to be on the lookout for future issues. When you’re finished with this course, you’ll have the skills and knowledge of configuring and deploying a data warehouse on the Microsoft SQL Server Platform needed to architect and maintain an effective data warehouse environment.

About the author
About the author

Ifedayo is a tech specialist with expertise in Cloud Data Solutions, Artificial intelligence, and Web Development. He loves teaching and watching people learn.

More from the author
Implement Security on Azure Synapse
Intermediate
39m
Jun 7, 2021
More courses by Ifedayo Bamikole
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Ifedayo Bamikole, and welcome to my course on preparing a data warehouse on the SQL Server platform. I am a data and AI solution architect at Microsoft, and I have worked with SQL Server in many different roles. Preparing a data warehouse in the right way is very important as a data professional, and this course will help save time in the business processes when creating a data warehouse architecture in SQL Server, as well as maintaining the SQL Server environment by reducing the amount of manual processes and quickly identifying critical performance blockers. Some of the major topics that we will cover include creating and scheduling a data warehouse job, increasing performance speed in a data warehouse, monitoring a data warehouse, and avoiding accessibility issues in a data warehouse. Before beginning this course, you should be familiar with SQL Server Management Studio, SQL Server Data Tools, as well a SQL Server Integration Services. By the end of this course, you will have a solid foundation to adequately prepare your data warehouse in Microsoft SQL Server. I hope you'll join me on this journey to learn about data warehousing with the Preparing a Data Warehouse on the Microsoft SQL Server Platform, at Pluralsight.