Automating and Managing Databases


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


Overview/Description
PowerShell can be used to manage SQL Databases and SQL Servers running in Azure VMs. This course outlines how to perform common administration tasks using PowerShell, as well as how to create runbooks to automate cloud management.

Target Audience
Database professionals interested in working with hybrid/cloud solutions and individuals who are preparing to take the 70-473 exam

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Automating and Managing Databases

  • start the course
  • use PowerShell to configure a subscription
  • define image variables
  • use PowerShell to create a new resource group
  • use PowerShell to create a storage account
  • use PowerShell to create network resources
  • use PowerShell to configure VM objects
  • create a SQL VM using PowerShell
  • create a new SQL database using SQL
  • create runbooks using the Azure portal
  • create runbooks using PowerShell
  • automate cloud management

    • Course Number:
    cl_dicp_a13_it_enus

    Expertise Level
    Expert