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.
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.
This Course Includes
pluralsight
0 (0 reviews )
1 hour 57 minutes 
english
Online - Self Paced
Expanded Courses
pluralsight
About Configuring and Deploying a Data Warehouse on the Microsoft SQL Server Platform
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.
What You Will Learn?
- Course Overview : 1min.
- Preparing a Data Warehouse to Create a Job : 24mins.
- Scheduling a Data Warehouse Job : 19mins.
- Increasing Performance Speed in a Data Warehouse : 30mins.
- Monitoring Performance in a Data Warehouse : 16mins.
- Avoiding Accessibility Issues When Data Warehouse Job Is Running : 25mins.