Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Automate database tasks for Azure SQL

Microsoft via Microsoft Learn

Go to class Write review

Overview

Module 1: Configure automatic deployment for Azure SQL Database

After completing this module, you will be able to:

Deploy an Azure Resource Manager template using PowerShell and CLI
Deploy an Azure Resource Manager template using Azure DevOps
Explore the structure of an Azure Resource Manager template

Module 2: Schedule tasks using SQL Server Agent

After completing this module, you will be able to:

Schedule necessary maintenance activities for your databases.
Configure notifications and alerts on SQL Server Agent jobs, and SQL Server.
Configure alerts based on performance monitor values.

Module 3: Manage Azure PaaS resources using automated methods

After completing this module, you will be able to:

Explore Azure Policy
Implement Azure Automation
Configure Elastic Jobs

Syllabus

Module 1: Configure automatic deployment for Azure SQL Database

Introduction
Describe deployment models in Azure
Create an Azure Resource Manager template
Deploy an Azure Resource Manager template
Exercise: Deploy an Azure SQL Database using an Azure Resource Manager template
Knowledge check
Summary

Module 2: Schedule tasks using SQL Server Agent

Introduction
Create a SQL Server maintenance plan
Describe task status notifications
Knowledge check
Exercise: Create a CPU status alert for a SQL Server
Summary

Module 3: Manage Azure PaaS resources using automated methods

Introduction
Implement Azure policy
Use Azure subscriptions and tag Azure resources
Describe Azure automation
Build an automation runbook
Describe elastic jobs in Azure SQL database
Exercise: Deploy an automation runbook to automatically rebuild a databases indexes
Knowledge check
Summary

Tags

united states

Reviews

Start your review of Automate database tasks for Azure SQL