SQL Server Virtual Machines on Azure
SQL Server Virtual Machines on Azure Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description
Azure virtual machines provide a way to move on-premise SQL Server workloads and applications to the cloud. This course will cover the recommended usage scenarios for Azure VMs, as well as how to provision, create, and connect to Azure SQL Databases. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.
Target Audience
SQL Server database administrators and application developers
Prerequisites
None
Expected Duration (hours)
1.9
Lesson Objectives SQL Server Virtual Machines on Azure
start the course
explain SQL Server on Azure virtual machines
recognize SQL Server Azure VM usage scenarios
explain per-minute licensing
recognize the differences between IaaS and on-premises deployments
demonstrate how to connect to a SQL Server Azure VM
demonstrate how to migrate a database to a SQL Server Azure VM
perform a backup of a database to an Azure storage account
perform a restore from an Azure storage account to an Azure VM
configure automatic patching and updating of an Azure VM running SQL Server
describe the customer experience improvement program (CEIP)
explain service tiers in SQL Server 2016
describe common service tier use cases
demonstrate how to create a sysadmin account
explain elastic database pools
describe when to use the appropriate service tier
explain SQL Server 2016 database transaction units
describe how to provision an Azure SQL Server 2016 database
demonstrate how to create an Azure SQL Server 2016 database
demonstrate how to connect to an Azure SQL Server 2016 database
determine when to deploy SQL to Azure VMs and databases
Course Number: df_sqlp_a03_it_enus
Expertise Level
Intermediate
