Components of a SQL Server 2016 Installation

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

---

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

Target Audience
SQL Server database administrators and application developers

Prerequisites
None

Expected Duration (hours)
2.0

Lesson Objectives

Components of a SQL Server 2016 Installation

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

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

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

determine the requirements for a successful SQL Server deployment

Course Number:
df_sqlp_a01_it_enus

Expertise Level
Intermediate