Automating and Managing Databases

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