Automate database tasks for Azure SQL

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

Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures.

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

Modules in this learning path

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.

Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance.

Explore automation for Azure SQL platform. Configure elastic jobs, explore Azure Automation, and evaluate different strategies for monitoring automation tasks.