Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

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

via Pluralsight

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course will teach you how to increase the efficiency of a Data Warehouse process by scheduling ETL Jobs leveraging the SQL Server Agent.

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.

Taught by

Ifedayo Bamikole

Reviews

Start your review of Configuring and Deploying a Data Warehouse on the Microsoft SQL Server Platform

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.