• Online, Self-Paced
Course Description

SQL Server uses instances to allow more than one copy of a SQL Server component to be installed on a single server. This course covers deploying SQL Server instances in IaaS and on-premise, as well as how to provision and install SQL Server on Azure virtual machines. Also covered in this course are the various storage solutions available in SQL Server 2016 and the considerations associated with each. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Learning Objectives

SQL Server Instances

  • start the course
  • describe SQL Server instances
  • explain how to host a SQL Server instance using Azure VMs
  • recognize the benefits of using Azure automation
  • explain how and when to use Azure Resource Manager
  • demonstrate how to deploy SQL Server using templates

Storage Considerations

  • provide an introduction to data storage with SQL Server
  • discuss considerations when planning disk storage devices
  • explain the different types of RAID configurations
  • differentiate between the five SQL Server system databases
  • demonstrate how to create user databases in SQL Server 2016
  • explain the use of filegroups in SQL Server 2016
  • describe how SQL Server uses the buffer pool extension
  • demonstrate how to configure the storage buffer pool extension
  • explain how storage spaces can be used in SQL Server 2016
  • describe storage layout considerations when using virtual machines
  • describe other possible storage solutions, including NAS, DAS, and SAN

Practice: Storage Options

  • determine effective disk or storage configuration for a given scenario

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.