Manage Azure PaaS tasks using automation

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

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

Learning objectives

After completing this module, you will be able to:

  • Undersand the benefits of Azure policy
  • Explore the capabilities of Azure Automation
  • Configure elastic jobs
  • Use Logic Apps for database workflow

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.
  • Familiarly with Open Source database systems on Azure.