search
    

    Home Microsoft 20765B: Provisioning SQL Databases

    QUICK

    INFORMATION

    icon

    3 Day(s) Course

    icon

    Official Courseware

    icon

    Exam Voucher

    icon

    Certified Trainer

    icon

    1:1 Training Available on Demand

    icon

    Customize Your Batch

    ABOUT

    THE COURSE

    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.

    Lessons

    • 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.

    Lessons

    • 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.

    Lessons

    • 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.

    Lessons

    • 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.

    Lessons

    • 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.

    Lessons

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

    Module 7: Performing Database Maintenance

    This module describes database maintenance.

    Lessons

    • 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 108

    gorm icon

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.5 stars by www.facebook.com/mercurysol based on 17 reviews.