Course 20765: Provisioning SQL Databases

Course Content

Course 20765A: MCSA 70-765 Provisioning SQL Databases

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 module 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