Automate deployment of database resources

Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
Azure SQL Database
SQL Server

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.

Learning 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

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.