Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-20765 - Provisioning SQL Databases

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Click here to print this page »

Prerequisites


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