Call us at 1-800-413-0939
Hands On Technology Transfer, Inc.

Provisioning SQL Databases

Attend face-to-face, remote-live or on site at your facility.

Travel Packages Discount Programs

Provisioning SQL Databases

Duration: 5 Days

Price: $2795 *California residents and government employees call for pricing.

Discounts: We offer multiple discount options. Click here for more info.

Delivery Options: Attend face-to-face in the classroom or remote-live attendance.

Students Will Learn

  • Provisioning a database server
  • Upgrading SQL Server
  • Configuring SQL Server
  • Managing databases and files (shared)
  • Provisioning, migrating and managing databases in the cloud
  • Creating a database maintenance plan
  • Deploying SQL Server on Microsoft Azure

Course Description

Microsoft Certified PartnerThis course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure. Topics include an overview SQL Server 2016 components and versions; database maintenance plans;SQL Server storage options; planning to deploy SQL Server on Azure; migrating databases to Azure SQL Database; deploying SQL Server on Microsoft Azure virtual machines and managing SQL Server on Azure.

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

Course Prerequisites

Familiarity with database concepts, Windows desktop navigation and Transact-SQL. Attendance at the Microsoft Transact-SQL Programming course is highly recommended although not required.

Course Overview

SQL Server 2016 Components
  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture and Resource Usage
  • SQL Server Services and Configuration Options
  • Separate Installation of SQL Server vs a Separate Instance
  • Deciding Which Version of SQL Server is Most Suitable
Installing SQL Server 2016
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server 2016
    • Performing Post Installation Checks
  • Automating a SQL Server Installation
Upgrading SQL Server to SQL Server 2016
  • Upgrade Requirements for SQL Server
  • Upgrading SQL Server Services
  • Migrating SQL Server Data and Applications
  • Creating the Application Logins
  • Restoring Database Backups
Working with Databases
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving and Copying Database Files
  • Migrating SQL Server Data and Applications
  • Using Buffer Pool Extensions
  • Configuring TempDB Storage
  • Creating Databases
  • Attaching a Database
Performing Database Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Using DBCC CHECKDB to Verify Database Integrity
  • Rebuilding Indexes
  • Creating a Database Maintenance Plan
Database Storage Options
  • SQL Server Storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Implementing Stretch Databases
  • Running Stretch Database Advisor
Deploying SQL Server on Microsoft Azure
  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Planning an Azure SQL Database, Networking, Performance Tiers and Security
  • Provisioning an Azure SQL Database
  • Connecting to an Azure SQL Database
  • Deploying an Azure SQL Database
Migrating Databases to Azure SQL Database
  • Performing Migration Testing
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database
  • Testing a Migrated Database
Deploying SQL Server on a Microsoft Azure Virtual Machine
  • Deploying SQL Server on an Azure Virtual Machine
  • Using the Deploy Database to a Microsoft Azure Virtual Machine Wizard
  • Provisioning an Azure Virtual Machine
Managing Databases in the Cloud
  • Managing Azure SQL Database Security
  • Configuring Azure storage
  • Automating Azure Automation

Related Courses

Course Benefits

  • Course materials include student guide, hands-on lab manual and USB flash drive for examples and lab work
  • Students receive a certificate of completion at the end of class
  • Students can retake any portion of a class that has been completed, within 12 months at no extra cost
  • There are no registration fees or cancellation fees

Course Schedule - Face-to-Face in the Classroom or Remote-Live

Choose a city below to view a schedule. If you have any questions, please call us at 978-250-4299 between 9:00 am - 5:00 pm EST.