MOC 20765A - Provisioning SQL Databases

Customized Onsite Training

3
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

$1,425.00
or 3 vouchers
  • Live Online Training
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

Upcoming Classes

  • See More Classes

Please select a class.
Overview

This three-day Provisioning SQL Databases training class provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.
Audience profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

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

Goals
  1. Learn to provision a Database Server.
  2. Learn to upgrade SQL Server.
  3. Learn to configure SQL Server.
  4. Learn to manage Databases and Files (shared).
Outline
  1. SQL Server 2016 ComponentsDescribe the SQL Server platform, SQL Server services, and SQL Server configuration options.Lessons
    1. Introduction to the SQL Server Platform
    2. Overview of SQL Server Architecture
    3. SQL Server Services and Configuration Options
    4. Lab: SQL Server Versions ( Discussion session)
  2. Installing SQL Server 2016This modules describes the process to install SQL Server 2016.Lessons
    1. Considerations for installing SQL Server
    2. TempDB Files
    3. Installing SQL Server 2016
    4. Automating Installation
    5. Lab: Installing SQL Server
  3. Upgrading SQL Server to SQL Server 2016
    1. Upgrade Requirements
    2. Upgrade SQL Server Services
    3. Migrating SQL Server Data and Applications
    4. Lab: Upgrading SQL Server
  4. Deploying SQL Server on Microsoft Azure
    1. SQL Server Virtual Machines in Azure
    2. Deploying an Azure SQL Database
    3. Migrating an On-Premise Database to an Azure SQL Database
    4. Lab: Migrating SQL Server with Azure
  5. Working with Databases
    1. Overview of SQL Server Databases
    2. Creating Databases
    3. Database Files and Filegroups
    4. Moving Database Files
    5. Buffer Pool Extension
    6. Lab: Managing Database Storage
  6. Database Storage OptionsAt the end of this module you will be able to describe the database storage options.Lessons
    1. SQL Server storage Performance
    2. SMB Fileshare
    3. SQL Server Storage in Azure
    4. Stretch Databases
    5. Lab: Implementing Stretch Database
  7. Performing Database Maintenance
    1. Ensuring Database Integrity
    2. Maintaining Indexes
    3. Automating Routine Database Maintenance
    4. Lab: Performing Ongoing Database Maintenance
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • 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.
Preparing for Class
Certifications

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

76,057

Students who have taken Live Online Training

15,320

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.40

Students rated our trainers 9.40 out of 10 based on 5,229 reviews

The class was great. I learned a lot and will more than likely go back to Webucator.

Jessica Reeves, Coast Central Credit Union
McKinleyville CA

I very much enjoyed my Introductory Word 2010 training. I didn't expect I would get to be the only student in my class.

Marthanne Glenn, n/a
Silver Spring MD

The staff at Webucator was amazingly helpful, and willing to make things happen at the last minute. They definitely went above and beyond what I have experienced with any other training organization. Thanks!!!

Nina Nussbaum-Jones, Lockheed Martin
Ventnor City NJ

Good overview of VBA basics.

Grace Lee, UnitedHealth Group
Columbia Heights MN

Contact Us or call 1-877-932-8228