Provisioning SQL Databases 20765

Description

This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016/2017 database. The course covers SQL Server 2016/2017 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

After completing this course, students will be able to:

  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)

Prérequis

This course requires that you meet the following prerequisites:

  • 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

These prerequisites can be achieved by attending course

20761 – Querying Data with Transact-SQL.


Éléments du contenu

Module 1: SQL Server 2016/2017 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/2017

This modules describes the process to install SQL Server 2016/2017.

Lessons

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

Lab : Installing SQL Server

After completing this module, you will be able to:

  • Describe the considerations when installing SQL Server 2016/2017
  • Be able to install SQL Server
  • Be able to automate the installation

Module 3: Upgrading SQL Server to SQL Server 2016/2017

This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016/2017.

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)

Partager

[ssba]


Durée : 3 Jours

Tarif régulier : 1 575 $

Tarif préférentiel : 1 395 $

Note : Formation donnée en français, logiciel et manuel en anglais.

Notre tarification inclut le matériel pédagogique


Dates ‡à venir

[ESPRESSO_TICKET_SELECTOR event_id=9596]

Durée : 3 Jours
Tarif régulier : 1,575.00 $
Tarif préférentiel : 1,395.00 $
Note : Formation donnée en français, logiciel et manuel en anglais.

Notre tarification inclut le matériel pédagogique
Dates à venir :
prix
qté
Montréal, 10 au 12 Oct. 2018 - 8:30 à 16:30
1,575.00 $
Québec, 10 au 12 Oct. 2018 - 8:30 à 16:30
1,575.00 $
Classe Virtuelle, 10 au 12 Oct. 2018 - 8:30 à 16:30
1,575.00 $
Montréal, 17 au 19 Déc. 2018 - 8:30 à 16:30
1,575.00 $
Québec, 17 au 19 Déc. 2018 - 8:30 à 16:30
1,575.00 $
Classe Virtuelle, 17 au 19 Déc. 2018 - 8:30 à 16:30
1,575.00 $