Automate database tasks for Azure SQL
- Offered byMicrosoft
Automate database tasks for Azure SQL at Microsoft Overview
Duration | 2 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Automate database tasks for Azure SQL at Microsoft Course details
- Automate deployment of database resources
- Create and manage SQL Agent jobs
- Manage Azure PaaS tasks using automation
- Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration
- This learning path helps prepare you for Exam DP-300: Administering Microsoft Azure SQL Solutions
- Use Azure Resource Manager (ARM) templates and Bicep files for deploying Azure SQL resources
- Understand how to use PowerShell and Azure CLI for automation purposes
- Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance
Automate database tasks for Azure SQL at Microsoft Curriculum
Automate deployment of database resources
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
Knowledge check
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
Knowledge check
Summary
Automate database tasks for Azure SQL at Microsoft Entry Requirements
- Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-basedAbility 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
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?