-
Course
- Data
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.
What you'll learn
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.
Table of contents
- Introduction | 34s
- Setting up SSIS ETL Package for a Data Warehouse Job | 2m 27s
- Demo: Setup the ETL Package in SSIS | 7m 5s
- Demo: Execute the ETL Package in SSIS | 5m 57s
- Creating SSIS Catalog Database | 1m 46s
- Demo: Creating SSIS Catalog Database | 1m 17s
- Build and Deploy ETL Package | 1m 18s
- Demo: Build and Deploy ETL Package | 3m 16s
- Summary | 34s
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 Courses by Dayo