Automate tasks in SQL Server
- Offered byMicrosoft
Automate tasks in SQL Server at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Automate tasks in SQL Server at Microsoft Course details
- Configure automatic deployment for Azure SQL Database
- Schedule tasks using SQL Server Agent
- Manage Azure PaaS resources using automated methods
- Scripting repetitive tasks in Azure SQL for regular maintenance jobs and multi-instance administration
- Automation of error and resource alerts
- Azure Resource Manager templates for deploying Azure SQL resources
- Explore SQL automation for Azure SQL Database and Open Source databases
Automate tasks in SQL Server at Microsoft Curriculum
MODULE: 1
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
MODULE :2
Create a SQL Server maintenance plan
Describe task status notifications
Describe extended events
Create an extended events session
Exercise: Create a CPU status alert for a SQL Server
MODULE: 3
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
Automate tasks in SQL Server at Microsoft Entry Requirements
- Prerequisites: Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based
- Ability 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?