Computer Science
Information Technology
Windows Server

Automate tasks in SQL Server

Created By
Microsoft via Microsoft Learn
  • 0
  • 2-3 hours worth of material
  • Microsoft Learn
  • English
Automate tasks in SQL Server

Course Overview

  • Module 1: Configure automatic deployment for Azure SQL Database

    • After completing this module, you will be able to:

    • 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

    • 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.
  • Module 3: Manage Azure PaaS resources using automated methods

    • After completing this module, you will be able to:

    • Explore Azure Policy
    • Implement Azure Automation
    • Configure Elastic Jobs

Course Circullum

  • 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

out of 5.0
5 Star 85%
4 Star 75%
3 Star 53%
1 Star 20%

Item Reviews - 3

Submit Reviews

Free Online Course

Enroll Now
This Course Include:
  • 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
  • Provider:Microsoft Learn
  • Certificate:Not Avalible
  • Language:English
  • Duration:2-3 hours worth of material
  • Language CC:

Do You Have Questions ?

We'll help you to grow your career and growth.
Contact Us Today