Azure SQL DB and ARM Templates


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
This course illustrates when to use hosted Azure SQL DB and how to manage it as per 70-533 Domain #3. You'll also learn how to provision ARM templates as per Domain #6.

Target Audience
IT professionals responsible for managing Microsoft Azure

Prerequisites
None

Expected Duration (hours)
1.8

Lesson Objectives

Azure SQL DB and ARM Templates

  • start the course
  • describe when Azure SQL DB should be used
  • implement Azure SQL DB replication
  • describe Azure SQL DB management tools
  • deploy Azure SQL DB using the portal
  • use SQL Server Management Studio to connect to Azure SQL DB
  • use PowerShell cmdlets to view Azure SQL DB
  • use the Azure CLI to view Azure SQL DB
  • migrate on-premises SQL to Azure SQL DB
  • list various levels of security to Azure SQL objects
  • set server and database security settings
  • determine how resources are managed with ARM
  • compare the options available in ARM policies
  • configure a policy for ARM management
  • create a template for ARM deployment of resources
  • use various methods of deploying an ARM template
  • configure Azure SQL and ARM templates
  • Course Number:
    cl_imas_a05_it_enus

    Expertise Level
    Intermediate