Provisioning SQL Databases M20765

SQL Server 2016 Components: Introduction to the SQL Server Platform - Overview of SQL Server Architecture - SQL Server Services and Configuration Options

Installing SQL Server 2016: Considerations for SQL Installing Server - TempDB Files - Installing SQL Server 2016 - Automating Installation

Upgrading SQL Server to SQL Server 2016: Upgrade Requirements - Upgrade SQL Server Services - Migrating SQL Server Data and Applications

Working with Databases: Introduction to Data Storage with SQL Server - Managing Storage for System Databases - Managing Storage for User Databases - Moving and Copying Database Files - Side-by-Side Upgrade: Migrating SQL Server Data and Applications - Buffer Pool Extension

Performing Database Maintenance: Ensuring Database Integrity - Maintaining Indexes - Automating Routine Database Maintenance

Database Storage Options: SQL Server storage Performance - SMB Fileshare - SQL Server Storage in Microsoft Azure - Stretch Databases

Planning to Deploy SQL Server on Microsoft Azure: SQL Server Virtual Machines in Azure - Azure Storage - Azure SQL Authentication - Deploying an Azure SQL Database

Migrating Databases to Azure SQL Database: Lessons - Database Migration Testing Tools - Database Migration Compatibility Issues - Migrating a SQL Server Database to Azure SQL Database

Deploying SQL Server on a Microsoft Azure Virtual Machine: Deploying SQL Server on an Azure VM - The Deploy Database to a Microsoft Azure VM Wizard

Managing databases in the Cloud: Managing Azure SQL Database Security - Configure Azure storage - Azure Automation