SQL Server 2016: Provision a Database

Posted By: Landau17
SQL Server 2016: Provision a Database

SQL Server 2016: Provision a Database
MP4 | Video: 720p | Duration: 2:44:45 | English | Subtitles: VTT | 334.5 MB

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