Provisioning SQL Databases


Course Description

This five-day course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Who Should Attend

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 Information


Length: 5 day

Format: Lecture and Lab

Delivery Method: Virtual / Onsite

Max. Capacity: 16



Learning Objectives

  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
  • Provision, migrate and manage databases in the cloud

Labs

  • Installing SQL Server
  • Upgrading SQL Server
  • Managing Database Storage
  • Performing Database Maintenance
  • Implementing Stretch Database
  • Plan and Deploy an Azure SQL Database
  • Migrating SQL Server Databases to Azure
  • Deploying SQL Server on an Azure Virtual Machine
  • Managing Databases in the Cloud