SQL Server 2016: Provision a Database
MP4 | Video: 720p | Duration: 2:44:45 | English | Subtitles: VTT | 334.5 MB
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