Course Description

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

Module 2: Installing SQL Server 2016
Considerations for installing SQL Server
TempDB Files
Installing SQL Server 2016
Automating Installation

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

Module 4: Deploying SQL Server on Microsoft Azure
SQL Server Virtual Machines in Azure
Deploying an Azure SQL Database
Migrating an On-Premise Database to an Azure SQL Database

Module 5: Working with Databases
Overview of SQL Server Databases
Creating Databases
Database Files and Filegroups
Moving Database Files
Buffer Pool Extension

Module 6: Database Storage Options
SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Azure
Stretch Databases

Module 7: Performing Database Maintenance
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance