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 1m
- Setting up SSIS ETL Package for a Data Warehouse Job 2m
- Demo: Setup the ETL Package in SSIS 7m
- Demo: Execute the ETL Package in SSIS 6m
- Creating SSIS Catalog Database 2m
- Demo: Creating SSIS Catalog Database 1m
- Build and Deploy ETL Package 1m
- Demo: Build and Deploy ETL Package 3m
- Summary 1m
- Introduction 1m
- Understanding the SQL Server Agent 1m
- Create a SQL Server Job 2m
- Demo: Create a SQL Server Job 3m
- Manage Permission in a SQL Server Agent Job 2m
- Demo: Manage Permission in a SQL Server Agent Job 4m
- Manage a Data Warehouse SQL Server Agent Job 1m
- Demo: Manage a Data Warehouse SQL Server Agent Job 3m
- Summary 0m
- Introduction 1m
- Creating and Updating Statistics in a Data Warehouse 3m
- Demo: Creating and Updating Statistics in a Data Warehouse 5m
- Understanding Columnstore Index 4m
- Demo: Create Cluster Columnstore Index 4m
- Using Segment Elimination to Improve Performance 1m
- Demo: Segment Elimination to Improve Performance 10m
- Batch Mode Execution to Improve Performance 2m
- Summary 0m
About the author
Dayo is a Technology Specialist with expertise in Cloud Data Solutions, Artificial intelligence, and Web Development. Dayo has traveled around the United States delivering workshops on technical services in the workplace, in over 35 states, as well as Europe. The audience for these workshops varies from Database Administrators to Software Developers. Ifedayo holds several certifications in Azure, such as: Azure Data Engineer, Azure Data Scientist, Azure AI Engineer, Google Cloud Fundamentals and... more