Duration:

5 Days

Audience:

Employees of federal, state and local governments; and businesses working with the government.

Course Description:

In the Provisioning SQL Databases course, you will learn how to configure and manage SQL Server databases both on-premises and in SQL Azure.

Learning Objectives:

After finishing this course, you’ll understand the key steps involved in provisioning SQL Server databases. You’ll be able to configure, upgrade and manage SQL Server with confidence.

This course empowers you to:

  • Provision a database server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage shared databases and files
  • Set up, migrate and manage databases in the cloud

Course Outline

1 – SQL SERVER COMPONENTS
  • Navigate the SQL Server Platform
  • Learn About the SQL Server Architecture
  • Get to Know SQL Server Services and Configuration Options
2 – INSTALLING SQL SERVER 2016
  • Describe Key Considerations for Installing SQL Server
  • Get Exposed to TempDB files
  • Install SQL Server 2016
  • Automate the Installation Process
  • Lab: Installing SQL Server
3 – UPGRADING SQL SERVER TO SQL SERVER 2017
  • Understand Upgrade Requirements
  • Upgrade SQL Server Services
  • Migrate SQL Server Data and Applications
  • Perform a Side-by-Side Upgrade: Migrate SQL Server Data and Applications
  • Lab : Upgrading SQL Server
4 – WORKING WITH DATABASES
  • Learn How Data Storage Works with SQL Server
  • Manage Storage for System and User Databases
  • Move and Copy Database Files
  • Configure Buffer Pool Extensions
  • Lab : Managing Database Storage
5 – PERFORMING DATABASE MAINTENANCE
  • Understand and Check Database Integrity
  • Maintain Indexes
  • Automate Routine Database Maintenance
  • Lab: Performing Database Maintenance
6 – DATABASE STORAGE OPTIONS
  • Get Familiar with SMB Fileshare
  • Analyze SQL Server Storage Performance
  • Configure SQL Server Storage in Microsoft Azure
  • Work with Stretch Databases
  • Lab: Implementing Stretch Database
7 – PLANNING TO DEPLOY SQL SERVER ON MICROSOFT AZURE
  • Learn About SQL Server Virtual Machines in Azure
  • Gain Exposure to Azure Storage
  • Navigate Azure SQL Authentication, Auditing and Compliance
  • Deploy an Azure SQL Database
  • Lab: Plan and Deploy an Azure SQL Database
8 – MIGRATING DATABASES TO AZURE SQL DATABASE
  • Practice Using Database Migration Testing Tools
  • Resolve Migration Compatibility Issues
  • Migrate a SQL Server Database to Azure SQL Database
  • Lab: Migrating SQL Server Databases to Azure
9 – DEPLOYING SQL SERVER ON A MICROSOFT AZURE VIRTUAL MACHINE
  • Deploy SQL Server on an Azure VM
  • Move On-Premises Data Using the Deploy Database to an Azure VM Wizard
  • Lab: Deploying SQL Server on an Azure Virtual Machine
10 – MANAGING DATABASES IN THE CLOUD
  • Manage Azure SQL Database Security
  • Configure Azure Storage
  • Implement Azure Automation
  • Lab: Managing Databases in the Cloud