20765B: Provisioning SQL Databases




    3 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    This 3-days Microsoft 20765B Provisioning SQL Databases Certification Course is Part 2 of the series of two courses of MCSA 2016: SQL Database Administration, that imparts fundamental knowledge, skills and abilities to professionals to be able to provision a Microsoft SQL Server 2016 database.

    The training focuses on provisioning of SQL Server, both on premises and in Azure, that covers new installation migrating from an existing install.

    After completing this course, participants will be able to:

    • Upgrade SQL Server
    • Configure SQL Server
    • Provision a Database Server
    • Manage Databases and Files (shared)

    This course qualifies you for the exam 70-765: Provisioning SQL Databases Certification.

    Module 1: SQL Server 2016 Components

    This module introduces the SQL Server services, SQL Server platform, and SQL Server configuration options.


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

    Module 2: Installing SQL Server 2016

    This module explains the process to install SQL Server 2016.


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

    Module 3: Upgrading SQL Server to SQL Server 2016

    This module explains how you go about upgrading your current SQL Server installation to SQL Server 2016.


    • Upgrade SQL Server Services
    • Upgrade Requirements
    • Migrating SQL Server Data and Applications

    Module 4: Deploying SQL Server on Microsoft Azure

    This module discusses the options available to run SQL Server on Azure.


    • SQL Server Virtual Machines in Azure
    • Migrating an On-Premise Database to an Azure SQL Database
    • Deploying an Azure SQL Database

    Module 5: Working with Databases

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


    • Overview of SQL Server Databases
    • Database Files and File groups
    • Creating Databases
    • Buffer Pool Extension
    • Moving Database Files

    Module 6: Database Storage Options

    At the end of this module, you will be able to explain the database storage options.


    • SQL Server storage Performance
    • SQL Server Storage in Azure
    • SMB File share
    • Stretch Databases

    Module 7: Performing Database Maintenance

    This module describes database maintenance.


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

    The primary audience for 70-765 provisioning SQL databases course is professionals who cater to SQL Server databases.

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

    Participants who attend this training should have the following technical knowledge:

    • Working knowledge of Transact-SQL & relational databases.
    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Elementary experience with database design.

    Name Code Fee
    Microsoft Certified Professional (MCP) - [70-765] 70-765 USD 127



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.