MOC 20765 - Provisioning SQL Databases

Customized Onsite Training

  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

or 3 vouchers
  • Live Online Training
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

Upcoming Classes

  • See More Classes

Please select a class.

This three-day Provisioning SQL Databases training class 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.
Audience profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

  1. Learn to provision a Database Server.
  2. Learn to upgrade SQL Server.
  3. Learn to configure SQL Server.
  4. Learn to manage Databases and Files (shared).
  1. SQL Server 2016 ComponentsDescribe the SQL Server platform, SQL Server services, and SQL Server configuration options.Lessons
    1. Introduction to the SQL Server Platform
    2. Overview of SQL Server Architecture
    3. SQL Server Services and Configuration Options
    4. Lab: SQL Server Versions ( Discussion session)
  2. Installing SQL Server 2016This modules describes the process to install SQL Server 2016.Lessons
    1. Considerations for installing SQL Server
    2. TempDB Files
    3. Installing SQL Server 2016
    4. Automating Installation
    5. Lab: Installing SQL Server
  3. Upgrading SQL Server to SQL Server 2016
    1. Upgrade Requirements
    2. Upgrade SQL Server Services
    3. Migrating SQL Server Data and Applications
    4. Lab: Upgrading SQL Server
  4. Deploying SQL Server on Microsoft Azure
    1. SQL Server Virtual Machines in Azure
    2. Deploying an Azure SQL Database
    3. Migrating an On-Premise Database to an Azure SQL Database
    4. Lab: Migrating SQL Server with Azure
  5. Working with Databases
    1. Overview of SQL Server Databases
    2. Creating Databases
    3. Database Files and Filegroups
    4. Moving Database Files
    5. Buffer Pool Extension
    6. Lab: Managing Database Storage
  6. Database Storage OptionsAt the end of this module you will be able to describe the database storage options.Lessons
    1. SQL Server storage Performance
    2. SMB Fileshare
    3. SQL Server Storage in Azure
    4. Stretch Databases
    5. Lab: Implementing Stretch Database
  7. Performing Database Maintenance
    1. Ensuring Database Integrity
    2. Maintaining Indexes
    3. Automating Routine Database Maintenance
    4. Lab: Performing Ongoing Database Maintenance
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • 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.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing


Students who have taken Live Online Training


Organizations who trust Webucator for their training needs


Satisfaction guarantee and retake option


Students rated our trainers 9.41 out of 10 based on 5,236 reviews

Contact Us or call 1-877-932-8228