Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

MOD+DMOC: Provisioning SQL Databases (M20765)

Learn to provision an on-premise and cloud Microsoft SQL Server 2016 database.

GK# 5505

Course Overview

TOP

This course provides you with the knowledge and skills to provision a Microsoft SQL Server 2016 database. You will cover SQL Server 2016 provision both on-premise and in Azure, and you’ll cover installing from new and migrating from an existing install.

This course incorporates material from the Official Microsoft Learning Product 20765: Provisioning SQL Databases, and it can assist you in your preparation for Exam 70-765: Provisioning SQL Databases

Redeem five SATVs for an individual GK Digital Learning course plus digital Microsoft Official Courseware (dMOC). For more information on Microsoft SATVs click here.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Provision a database server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage databases and files (shared)

Outline

TOP
Viewing outline for:

GK Digital Learning Outline

1. SQL Server 2016 Components

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

2. Installing SQL Server 2016

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

3. Upgrading SQL Server to SQL Server 2016

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

4. Working with Databases

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

5. Performing Database Maintenance

  • Ensuring Database Integrity
    Maintaining Indexes
    Automating Routine Database Maintenance

6. Database Storage Options

  • SQL Server Storage Performance
    SMB Fileshare
    SQL Server Storage in Azure
    Stretch Databases

7. Planning to Deploy SQL Server on Microsoft Azure

  • SQL Server Virtual Machines in Azure
    Azure Storage
    Azure SQL Authentication
    Deploying an Azure SQL Database

8. Migrating Databases to Azure SQL Database

  • Database Migration Testing Tools
    Database Migration Compatibility Issues
    Migrating a SQL Server Database to Azure SQL Database

9. Deploying SQL Server on a Microsoft Azure Virtual Machine

  • Deploying SQL Server on an Azure VM
    The Deploy Database to a Microsoft Azure VM Wizard

10. Managing Databases in the Cloud

  • Managing Azure SQL Database Security
    Configure Azure storage
    Azure Automation

Labs

TOP
Viewing labs for:

GK Digital Learning Labs

Lab 1: SQL Server Versions (Discussion Session)
Lab 2: Installing SQL Server
Lab 3: Upgrading SQL Server
Lab 4: Managing Database Storage
Lab 5: Performing Database Maintenance
Lab 6: Implementing Stretch Database
Lab 7: Plan and Deploy an Azure SQL Database
Lab 8: Migrating SQL Server Databases to Azure
Lab 9: Deploying SQL Server on an Azure Virtual Machine
Lab 10: Managing Databases in the Cloud

Prerequisites

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

Who Should Attend

TOP
  • Individuals who administer and maintain SQL Server databases, performing database administration and maintenance as their primary area of responsibility, or who work in environments where databases play a key role in their primary job
  • Individuals who develop applications that deliver content from SQL Server databases

Follow-On Courses

TOP
Training Exclusives

This course comes with three months, 24x7 access to: 

  • HD-quality streaming videos that adapt to your connection speed and device
  • Hands-on live labs with integrated lab steps and ability to save and resume labs
  • Knowledge checks for comprehensive assessments
  • 24x7 mentoring via chat, email and phone
  • Digital Microsoft Official Courseware (dMOC)
Course Delivery

This course is available in the following formats:

GK Digital Learning

Experience high-quality online learning combined with reliable expert guidance and skills development activities.



Request this course in a different delivery format.
Enroll