SQL Server 2016: Provision a Database

Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service. In this course, Adam Wilbert reviews several ways of getting a SQL database up and running, helping you see the benefits and trade-offs of each option. He begins by explaining how to get started with Azure SQL Database, demonstrating how to deploy a database and choose the right service tier for you. He also shows how to deploy a virtual Windows Server machine, and migrate on-premises SQL Server databases to a SQL Server instance hosted on an Azure virtual machine.

This course is also ideal for anybody preparing for the Provisioning SQL Databases (70-765) exam, one of two exams necessary to earn an MCSA: SQL 2016 Database Administration certification.

Topics include:

• Deploying a Microsoft Azure SQL Database
• Planning for a SQL Server installation
• Planning for an IaaS or on-premises deployment
• Evaluating best practices for installation
• Provisioning an Azure virtual machine
• Deploying SQL Server using templates
• Managing SQL Server instances
• Migrating SQL Server databases to Azure VM
• Migrating client applications