YoVDO

Automate database tasks for Azure SQL

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft SQL Server Courses SQL Courses PowerShell Courses Azure SQL Courses Command Line Interface (CLI) Courses Azure Resource Manager Courses Azure Policies Courses SQL Server Agent Courses

Course Description

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

Tags

Related Courses

Microsoft Azure Administrator: Manage Subscriptions and Governance
Pluralsight Microsoft Azure Solutions Architect: Implement a Governance Strategy
Pluralsight Microsoft DevOps Solutions: Designing Governance Enforcement Mechanisms
Pluralsight Microsoft Azure Solutions Architect: Design Governance
Pluralsight Configuring Security Services and Policies in Microsoft Azure
Pluralsight