Automate database tasks for Azure SQL

Automate database tasks for Azure SQL

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
Data Analyst
Data Engineer
Database Administrator
Azure
SQL Server
SQL Database

Related Modules

Automate deployment of database resources
module
Intermediate   MS Learn
Data Engineer
Database Administrator
Create and manage SQL Agent jobs
module
Intermediate   MS Learn
Data Engineer
Database Administrator
Manage Azure PaaS tasks using automation
module
Intermediate   MS Learn
Data Engineer
Database Administrator