• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design

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

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

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

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

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

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

Module 7: Performing Database Maintenance

This module covers database maintenance.

Lessons

• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance

.Exam 70-765

Course Days: 5 Days