MEAPSA

Automate deployment of database resources

Explore multiple deployment models available on Azure. Use Azure Resource Manager (ARM) templates and Bicep files for deploying Azure SQL resources. Understand how to use PowerShell and Azure CLI for automation purposes.

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module Objectives

After completing this module, you will be able to:

Describe the deployment models available on Azure
Deploy database resources using PowerShell and Azure CLI
Deploy an Azure Resource Manager template and Bicep
Understand the difference between multiple command-line options

Units

Introduction min
Describe deployment models in Azure min
Automate deployment by using Azure Resource Manager templates and Bicep min
Automate deployment by using PowerShell min
Automate deployment by using Azure CLI min
Exercise: Deploy an Azure SQL Database using an Azure Resource Manager template min
Knowledge check min
Summary min

Prerequisites

Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Experience creating and configuring resources using the Azure portal.