> > 20765-3D

Provisioning SQL Databases (20765-3D)

Cursusbeschrijving Beschikbare data Gedetailleerde cursusinhoud

Gedetailleerde cursusinhoud

Module 1: SQL Server 2016 Components

Describe 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 2016

This 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 2016

This 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 Azure

This 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 Databases

This 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 Options

At 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 Maintenance

This 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)