Deploying Microsoft Azure Data Solutions

Paths

Deploying Microsoft Azure Data Solutions

Authors: Robert Lindley, Marcelo Pastorino, John Savill

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

Related topics

Data Operations Data Pipelines Microsoft Azure Relational Databases NoSQL Databases

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 SQL Data Warehouse and Azure SQL Database

by Robert Lindley

Sep 17, 2019 / 1h 60m

1h 60m

Start Course
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 SQL Data Warehouse 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
  1. Course Overview
  2. Deploying the Modern Data Warehouse Environment
  3. Choosing a Code Branching Strategy
  4. Implementing a Data Warehouse Build and Release Pipeline
  5. 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

by Marcelo Pastorino

Dec 12, 2019 / 1h 29m

1h 29m

Start Course
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
  1. Course Overview
  2. Getting Started Deploying Data Pipelines in Azure
  3. Creating the Data Pipeline Deployment Infrastructure
  4. Creating Azure Data Factory Environments
  5. Integrating Azure Data Factory Pipelines with Source Control Using Azure DevOps
  6. Deploying Data Pipelines Using ARM Templates and Azure DevOps
  7. 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

by John Savill

Sep 11, 2019 / 2h 18m

2h 18m

Start Course
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
  1. Course Overview
  2. SQL Server and Containers in Azure
  3. Running SQL Server in a Container and Kubernetes
  4. SQL Server and AKS Deployment