MEAPSA

Manage Azure PaaS tasks using automation

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

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module 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

Units

Introduction min
Explore Elastic jobs min
Understand Azure Automation min
Build an automation runbook min
Automate database workflows by using Logic Apps min
Monitor automated tasks min
Exercise: Deploy an automation runbook to automatically rebuild indexes 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.
Familiarly with Open Source database systems on Azure.