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

Microsoft

Automate database tasks for Azure SQL

Microsoft via Microsoft Learn

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • Automate database deployment

    After completing this module, you will be able to:

    • Describe the deployment models available on Azure
    • Deploy database resources using PowerShell and Azure CLI
    • Deploy an Azure Resource Manager template and Bicep
    • Understand the difference between multiple command-line options
  • Create and manage SQL Agent jobs

    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.
  • Manage Azure PaaS tasks using automation

    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

Syllabus

  • Automate database deployment
    • Introduction
    • Describe deployment models in Azure
    • Automate deployment by using Azure Resource Manager templates and Bicep
    • Automate deployment by using PowerShell
    • Automate deployment by using Azure CLI
    • Exercise: Deploy an Azure SQL Database using an Azure Resource Manager template
    • Module assessment
    • Summary
  • Create and manage SQL Agent jobs
    • Introduction
    • Create a SQL Server maintenance plan
    • Describe task status notifications
    • Knowledge check
    • Exercise: Create a CPU status alert for a SQL Server
    • Summary
  • Manage Azure PaaS tasks using automation
    • Introduction
    • Explore Elastic jobs
    • Understand Azure Automation
    • Build an automation runbook
    • Automate database workflows by using Logic Apps
    • Monitor automated tasks
    • Exercise: Deploy an automation runbook to automatically rebuild indexes
    • Module assessment
    • Summary

Reviews

Start your review of Automate database tasks for Azure SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.