Microsoft Learn
Free Online Course
English
2-3 hours worth of material
selfpaced
Overview
- Module 1: Configure automatic deployment for Azure SQL Database
- 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
- 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
- Explore Azure Policy
- Implement Azure Automation
- Configure Elastic Jobs
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
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
