Provisioning SQL Databases (MS20765)

Module 1: SQL Server Components

This module describes the various SQL Server components and versions.

• Introduction to the SQL Server Platform
• Overview of SQL Server Architecture
• SQL Server Services and Configuration Options

Module 2: Installing SQL Server

This modules describes the process to install SQL Server 2016.

• Considerations for SQL Installing Server
• TempDB Files
• Installing SQL Server
• Automating Installation

Module 3: Upgrading SQL Server to SQL Server 2017

This module describes the process for upgrading to SQL Server 2017.

• Upgrade Requirements
• Upgrade SQL Server Services
• Side by Side Upgrade: Migrating SQL Server Data and Applications

Module 4: Working with Databases

This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

• Introduction to Data Storage with SQL Server
• Managing Storage for System Databases
• Managing Storage for User Databases
• Moving and Copying Database Files
• Buffer Pool Extension

Module 5: Performing Database Maintenance

This module covers database maintenance plans.

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

Module 6: Database Storage Options

Describe SQL Server storage options.

• SQL Server storage Performance
• SMB Fileshare
• SQL Server Storage in Microsoft Azure
• Stretch Databases

Module 7: Planning to Deploy SQL Server on Microsoft Azure

This module describes how to plan to deploy SQL Server on 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

This module describes how to migrate 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

This module describes how to deploy SQL Server on Microsoft Azure VMs.

• Deploying SQL Server on an Azure VM
• The Deploy Database to a Microsoft Azure VM Wizard

Module 10: Managing databases in the Cloud

• This module describes how to manage SQL Server on Azure.
• Managing Azure SQL Database Security
• Configure Azure storage
• Azure Automation