Home / Courses / Microsoft Technology / 20765A: Provisioning SQL Databases

SQL

20765A: Provisioning SQL Databases

Module 1: SQL Server 2016 ComponentsDescribe the SQL Server platform, SQL Server services, and SQL Server configuration options.Lessons
  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options

Lab : SQL Server Versions ( Discussion session)

After completing this module, you will be able to:

  • Describe the SQL Server platform and architecture

  • Describe the SQL Server services and configuration..

 

Module 2: Installing SQL Server 2016This modules describes the process to install SQL Server 2016.Lessons

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

Lab : Installing SQL Server

After completing this module, you will be able to:

  • Describe the considerations when installing SQL Server 2016

  • Be able to install SQL Server

  • Be able to automate the installation

 

Module 3: Upgrading SQL Server to SQL Server 2016This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016.Lessons

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

Lab : Upgrading SQL Server

After completing this module, you will be able to:

  • Describe the requirements for upgrading to SQL Server 2016

  • Describe how to upgrade SQL Server services

  • Be able to migrate SQL Server Data and Applications

 

Module 4: Deploying SQL Server on Microsoft AzureThis module describes the options available to run SQL Server on Azure.Lessons

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

Lab : Migrating SQL Server with Azure

After completing this module, you will be able to:

  • Describe how SQL Server Virtual Machines work in Azure

  • Describe how to deploy and Azure SQL database

  • Describe how to migrate and on-premise database to Azure

 

Module 5: Working with DatabasesThis module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.Lessons

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

Lab : Managing Database Storage

After completing this module, you will be able to:

  • Be able to create SQL Server databases

  • Describe database files and filegroups

  • Be able to move database files

  • Describe the buffer pool extension

 

Module 6: Database Storage OptionsAt the end of this module you will be able to describe the database storage options.Lessons

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

Lab : Implementing Stretch Database

After completing this module, you will be able to:

  • Explain the elements impacting storage performance

  • Describe SMB fileshare

  • Describe SQL Server storage in Azure

  • Describe Stretch Databases

 

Module 7: Performing Database MaintenanceThis module covers database maintenance.Lessons

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
Lab : Performing Ongoing Database Maintenance

After completing this module, you will be able to:

  • Describe how to ensure database integrity

  • Be able to maintain indexes

  • Be able to automate routine database maintenance

Additional Reading

After completing this course, students will be able to:

  • Provision a Database Server

  • Upgrade SQL Server

  • Configure SQL Server

  • Manage Databases and Files (shared)

Course Registration

 

3 days
$1,675.00

 

Course Outline

 

Request