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:

    $

Provisioning SQL Databases (M20765)

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

GK# 4397

$2195 - $2295 CAD

Enroll Request Group Training

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.

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:

Virtual Classroom Live Outline

Course 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. Deploying SQL Server on Microsoft Azure

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

5. Working with Databases

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

6. Database Storage Options

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

7. Performing Database Maintenance

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

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

Labs:

Lab 1: SQL Server Versions (Discussion Session)
Lab 2: Installing SQL Server
Lab 3: Upgrading SQL Server
Lab 4: Migrating SQL Server with Azure
Lab 5: Working with SQL Server Databases
Lab 6: Implementing Stretch Database
Lab 7: Performing Database Maintenance

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 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 3 day

Request this course in a different delivery format.
Enroll