- 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
Gain a Splash of New Skills - Coursera+ Annual Nearly 45% Off
You’re only 3 weeks away from a new language
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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