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.
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.
Author Name: Dayo Bamikole
Author Description:
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
Table of Contents
- 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
User Reviews
Be the first to review “Configuring and Deploying a Data Warehouse on the Microsoft SQL Server Platform”
Related Products
Data Pipelines with Azure
Build scalable data pipelines using Microsoft Azure tools.
Transfer and transform data with Azure Synapse Analytics pipelines
Azure Synapse Analytics enables data integration through the use of pipelines, which you can use to automate and orchestrate data transfer and transformation activities.
Use Delta Lake in Azure Synapse Analytics
Delta Lake is an open source relational storage area for Spark that you can use to implement a data lakehouse architecture in Azure Synapse Analytics.
Get started with data engineering on Azure
In most organizations, a data engineer is the primary role responsible for integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions. An Azure data engineer also helps ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a specific set of business requirements and constraints.
Data Streaming
Study techniques for real-time data processing and stream analytics.
Explore fundamentals of large-scale analytics
Organizations use analytics platforms to build large scale data analytics solutions that generate insights and drive success. Microsoft provides multiple technologies that you can combine to build a large scale data analytics solution.
There are no reviews yet.