MS-20765 - Provisioning SQL Databases

This 5 day instructor led training course teaches students how to provision SQL databases both on premise and in SQL Azure.

Click here to print this page »


This course requires that you meet the following prerequisites:
  • 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

Detailed Class Syllabus

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 SQL Installing 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: 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

Module 5: Performing Database Maintenance

Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Module 6: Database Storage Options

SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Microsoft Azure
Stretch Database

Module 7: Planning to Deploy SQL Server on Microsoft Azure

SQL Server Virtual Machines in Azure
Azure Storage
Azure SQL Authentication
Deploying an Azure SQL Database

Module 8: Migrating Databases to Azure SQL Database

Database Migration Testing Tools
Database Migration Compatibility Issues
Migrating a SQL Server Database to Azure SQL Database

Module 9: 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

Module 10: Managing databases in the Cloud

Managing Azure SQL Database Security
Configure Azure storage
Azure Automation