SQL Server Instances and Storage Considerations


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
SQL Server database administrators and application developers

Prerequisites
None

Expected Duration (hours)
1.6

Lesson Objectives

SQL Server Instances and Storage Considerations

  • 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
  • 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
  • determine effective disk or storage configuration for a given scenario

    • Course Number:
    df_sqlp_a04_it_enus

    Expertise Level
    Intermediate