Training Courses

search courses

20765: Provisioning SQL 2016 Databases

Guaranteed to Run Scheduled Fully Booked
Location
Wellington
Oct 2020
12
Nov 2020
23
Jan 2021
18
Mar 2021
1
Apr 2021
12
May 2021
24
Jul 2021
5
Aug 2021
16
Sep 2021
27
Nov 2021
8
Voucher
Voucher: 5-day voucher
Code: 20765
Length: 5 Days
Overview

Learn to provision an on-premise and cloud Microsoft SQL Server 2016 database.

Delivery format(s)
On-Site
On-Site
On-Demand
On-Demand
Classroom
Classroom
Anywhere
Anywhere
OBJECTIVES
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
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)
WHAT YOU’LL LEARN
  • Provision a database server.
  • Upgrade SQL Server.
  • Configure SQL Server.
  • Manage databases and files (shared).
  • Provision, migrate and manage databases in cloud
WHO SHOULD ATTEND
  • Individuals who administer and maintain SQL Server databases, performing database administration and maintenance as their primary area of responsibility, or who work in environments where databases play a key role in their primary job.
  • Individuals who develop applications that deliver content from SQL Server databases.
COURSE OUTLINE

1. SQL Server 2016 Components

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

2. Installing SQL Server 2016

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

3. Upgrading SQL Server to SQL Server 2017

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

4. Working with Databases

  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databses
  • Moving and Copying Database Files
  • Buffer Pool Extension

5. Perform Data Maintenance

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

6. Database Storage Options

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

7. Planning to Deploy SQL Server on Microsoft Azure

  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Deploying an Azure SQL Database

8. Migrating Databases to Azure SQL Database

  • Database Migration Testing Tools
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database

9. Deploying SQL Server on a Microsoft Azure Virtual Machine

  • Deploying SQL Server on an Azure VM
  • ###li/li###

10. Managing databases in the Cloud

  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation

Enquiry Form