20765-Provisioning SQL Databases
Course Details

20765-Provisioning SQL Databases

Category ID Duration Price
Microsoft SQL Server M20765 5 Day(s) $2,850.00
  View Schedule


This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.


Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
· Provision a Database Server
· Upgrade SQL Server
· Configure SQL Server
· Manage Databases and Files (shared)


To ensure successful completion of this course, we recommend the following:

· 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
· These prerequisites can be achieved by attending course 20761A – Querying Data with Transact-SQL.


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

Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.

PPLS Headquarters
1580 Sawgrass Corporate Parkway
Suite 205
Sunrise, Florida 33323
United States

T 1-844-238-8607
P 1-954-425-6141
F 1-954-928-9057
E info@productivitypointls.com

© Copyright 2020 Productivity Point Learning Solutions. All Rights Reserved.