search3
    
    20765B: Provisioning SQL Databases

    QUICK

    INFORMATION

    course-duration

    3 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Training

    customize-batch

    Customize Your Batch

    one-o-one

    1:1 Training Available on Demand

    Course Information

    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.

    COURSE OUTLINE

    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

    WHO SHOULD ATTEND

    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.

    Pre-requisites

    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.

    Exam

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

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.