
Paths
Deploying Microsoft Azure Data Solutions
Microsoft Azure includes a complete data storage offering suited to a variety of business needs. This skill teaches you how to deploy these data storage services on the Microsoft... Read more
What you will learn:
- Deploy Azure Data Warehouse
- Deploy Azure SQL Server
- Deploy Azure Data Factory Pipelines
- Deploy SQL Server via containers
Pre-requisites
Learners approaching this path should be familiar with the Microsoft Azure storage offerings, and how those offerings are used to address specific business requirements. It is not expected that learners are familiar with the operational aspects of deploying the services into a production environment.
Beginner
This section of the path teaches you to deploy Azure SQL Data Warehouse and Azure SQL Databases.
Deploying Microsoft Azure Synapse Analytics and Azure SQL Database
1h 57m
Description
Agile methodologies have radically changed application development. Databases now need to continually evolve along with our applications, especially with the focus on highly iterative, micro-service driven architectures. In this course, Deploying Microsoft Azure Synapse Analytics and Azure SQL Database, you will learn foundational knowledge to create and deploy databases as part of a CI/CD process. First, you'll learn to create new Azure SQL Databases, Azure Data Warehouses, and Azure Data Factory resources along with creating ARM templates for each resource. Next, you’ll learn how to set up build and release pipelines with Azure DevOps to automatically provision new resources using ARM templates and deploying data warehouse or SQL database using data-tier application packages (DACPAC). Finally, you'll explore how to migrate existing on-premises SQL Server Databases to Azure using Azure Migrate Service, or keeping your on-premises databases automatically synchronized with Azure SQL Databases using Azure Data Sync. When you’re finished with this course, you will have the skills and knowledge to use Azure DevOps to deploy both Azure SQL Data Warehouses and Azure SQL Databases as part of your Agile processes.
Table of contents
- Course Overview
- Deploying the Modern Data Warehouse Environment
- Choosing a Code Branching Strategy
- Implementing a Data Warehouse Build and Release Pipeline
- Managing Hybrid Azure SQL Data Warehouse Solutions
Intermediate
In this section, you will learn to deploy Azure Data Factory pipelines, including integration with Git.
Deploying Data Pipelines in Microsoft Azure
1h 28m
Description
Data engineers working with Azure Data Factory can take advantage of Continuous Integration and Continuous Delivery practices to deploy robust and well-tested data pipelines to production.
In this course, Deploying Data Pipelines in Microsoft Azure, you will learn foundational knowledge to apply CI/CD methodologies to your data pipeline creation process.
First, you will learn to create the right environments to fall into the pit of success when creating data pipelines in ADF.
Next, you will discover how to deploy data pipelines using ADF visual tools and ARM templates.
Finally, you will explore how to create a release pipeline in Azure DevOps to automate the deployment process between three distinct environments: development, staging, and production.
When you are finished with this course, you will have the skills and knowledge to apply CI/CD practices to your data pipeline creation process, effortlessly.
Table of contents
- Course Overview
- Getting Started Deploying Data Pipelines in Azure
- Creating the Data Pipeline Deployment Infrastructure
- Creating Azure Data Factory Environments
- Integrating Azure Data Factory Pipelines with Source Control Using Azure DevOps
- Deploying Data Pipelines Using ARM Templates and Azure DevOps
- Implementing Continuous Integration and Delivery of Azure Data Factory Pipelines Using Azure DevOps
Advanced
This section of the skill teaches you to deploy Microsoft SQL Server in a container on Microsoft Azure.
Deploying SQL Server Containers in Microsoft Azure
2h 20m
Description
On first glance, SQL Server and containers seem complete opposites, but running SQL Server containers in Azure provides a number of business and technical benefits. In this course, Deploying SQL Server Containers in Microsoft Azure, you will gain the ability to design and deploy a container-based SQL Server deployment in Azure. First, you will learn core skills around containers and Kubernetes. Next, you will discover how to deploy SQL Server in a container. Finally, you will explore how to piece everything together by deploying SQL Server to container services hosted in Azure, while meeting key SQL Server requirements. When you’re finished with this course, you will have the skills and knowledge of deploying SQL Server containers in Azure needed to meet your business and technical goals.
Table of contents
- Course Overview
- SQL Server and Containers in Azure
- Running SQL Server in a Container and Kubernetes
- SQL Server and AKS Deployment