Provisioning SQL Databases (20765)

Module 1: SQL Server 2016 Components
· Describe the SQL Server platform, SQL Server services, and SQL Server configuration options.
· Lessons
· Introduction to the SQL Server Platform
· Overview of SQL Server Architecture
· SQL Server Services and Configuration Options
· Lab : SQL Server Versions ( Discussion session)

Module 2: Installing SQL Server 2016
· This modules describes the process to install SQL Server 2016.
· Lessons
· Considerations for installing SQL Server
· TempDB Files
· Installing SQL Server 2016
· Automating Installation
· Lab : Installing SQL Server

Module 3: Upgrading SQL Server to SQL Server 2016
· This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016.
· Lessons
· Upgrade Requirements
· Upgrade SQL Server Services
· Migrating SQL Server Data and Applications
· Lab : Upgrading SQL Server

Module 4: Deploying SQL Server on Microsoft Azure
· This module describes the options available to run SQL Server on Azure.
· Lessons
· SQL Server Virtual Machines in Azure
· Deploying an Azure SQL Database
· Migrating an On-Premise Database to an Azure SQL Database
· Lab : Migrating SQL Server with Azure

Module 5: Working with Databases
· This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.
· Lessons
· Overview of SQL Server Databases
· Creating Databases
· Database Files and Filegroups
· Moving Database Files
· Buffer Pool Extension
· Lab : Managing Database Storage

Module 6: Database Storage Options
· At the end of this module you will be able to describe the database storage options.
· Lessons
· SQL Server storage Performance
· SMB Fileshare
· SQL Server Storage in Azure
· Stretch Databases
· Lab : Implementing Stretch Database

Module 7: Performing Database Maintenance
· This module covers database maintenance.
· Lessons
· Ensuring Database Integrity
· Maintaining Indexes
· Automating Routine Database Maintenance
· Lab : Performing Ongoing Database Maintenance