• Online, Self-Paced
Course Description

It is important to understand the various components, editions, and versions that exist when discussing SQL Server 2016. This course provides and introduction for both the SQL Server platform and SQL Server architecture, while also providing an overview of best practices and guidelines to follow when preparing for an installation of SQL Server 2016. 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 Platform

  • start the course
  • recognize the SQL Server 2016 components
  • describe SQL Server 2016 instances
  • describe SQL Server 2016 editions
  • describe SQL Server versions
  • explain SQL Server 2016 32-bit systems
  • explain SQL Server 2016 64-bit systems

SQL Server Architecture

  • recognize the different SQL Server 2016 architecture layers
  • explain SQL Server 2016 CPU usage
  • explain SQL Server 2016 Server memory management
  • describe parallelism in SQL Server 2016
  • explain I/O operations in SQL Server 2016
  • describe the various services used by SQL Server 2016
  • describe the various account types available in SQL Server 2016
  • explain the different network protocols supported by SQL Server 2016

Best Practices for Installation

  • understand the various hardware requirements for SQL Server 2016
  • understand the various software requirements for SQL Server 2016
  • describe considerations when implementing I/O subsystems for SQL Server 2016
  • demonstrate how to use the SQLIOSim tool in SQL Server 2016
  • demonstrate how to use the Diskspd tool in SQL Server 2016

Practice: Installation Prerequisites

  • determine the requirements for a successful SQL Server deployment

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.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.