Automate tasks in SQL Server
- Offered byMicrosoft
Automate tasks in SQL Server at Microsoft Overview
Automate tasks in SQL Server
at Microsoft
Explore SQL automation for scheduled tasks and automatic alerts for SQL Server and Managed Instance
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
Table of content
- Overview
- Course Details
- Curriculum
- Entry Requirements
Automate tasks in SQL Server at Microsoft Course details
Automate tasks in SQL Server
at Microsoft
Skills you will learn
What are the course deliverables?
- Configure automatic deployment for Azure SQL Database
- Schedule tasks using SQL Server Agent
- Manage Azure PaaS resources using automated methods
More about this course
- 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
Automate tasks in SQL Server
at Microsoft
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
Automate tasks in SQL Server
at Microsoft
Eligibility criteria
- 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
Conditional Offer
- Not mentioned
Other courses offered by Microsoft
Free
2 hours
Intermediate
View Other 1171 Courses
Automate tasks in SQL Server
at Microsoft
Student Forum
Anything you would want to ask experts?