1­-855­-778­-7246

Provisioning SQL Databases (20765)

 

Course Content

This three-day instructor-led course teaches you how to provision SQL Server 2016 both on-premise and in Azure, and it also covers installing from new and migrating from an existing install.

Who should attend

  • SQL Server Administrators
  • Anyone pursuing the MCSA: SQL Server 2016 Database Administration certification
  • Application Developers who use SQL Server to deliver content

Certifications

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
  • Querying Data with Transact-SQL (20761) is recommended if you do not meet all the above prerequisites.

Outline: Provisioning SQL Databases (20765)

Module 1: SQL Server 2016 Components

  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options

Module 2: Installing SQL Server 2016

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

Module 3: Upgrading SQL Server to SQL Server 2016

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

Module 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

Module 5: Working with Databases

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

Module 6: Database Storage Options

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

Module 7: Performing Database Maintenance

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

Labs

  • SQL Server Versions ( Discussion session)
  • Installing SQL Server
  • Upgrading SQL Server
  • Migrating SQL Server with Azure
  • Managing Database Storage
  • Implementing Stretch Database
  • Performing Ongoing Database Maintenance
Online Training

Duration 5 days

Price
  • CAD 1,750
  • SA Voucher: 3
Classroom Training

Duration 5 days

Price
  • Canada: CAD 1,750
  • SA Voucher: 3
 
Click on town name to book Schedule
This is an Instructor-Led Classroom course
This is a FLEX course, which is delivered both virtually and in the classroom.
  *   This class is delivered by a partner.
Canada

Currently there are no training dates scheduled for this course.  For enquiries please write to info@fastlaneca.com.

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.