Search
Cancel
Sign In

Automate tasks in SQL Server

Go to class
Write Review

Free Online Course: Automate tasks in SQL Server provided by Microsoft Learn is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge.

Microsoft via Microsoft Learn
2-3 hours worth of material
Self Paced
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

Syllabus

    • 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

← Prev Next →
0, based on 0 Course votes at GetYourEducation

Start your review of Automate tasks in SQL Server

Add review ->
Related courses by Level

Accounting for Mergers and Acquisitions: Foundations

Intermediate
Provider: Coursera
Language: English

Advanced Topics in Derivative Pricing

Intermediate
Provider: Coursera
Language: English

Assisting Public Sector Decision Makers With Policy Analysis

Intermediate
Provider: Coursera
Language: English

Creating and Capturing Mixed Reality

Intermediate
Provider: Kadenze
Language: English

Docker. Basics

Intermediate
Provider: Coursera
Language: English

Natural Language Processing and Capstone Assignment

Intermediate
Provider: Coursera
Language: English
Browse by subject
Browse by provider
Browse by university
Browse by institution
College Rankings