SQL Platform & Installation Best Practices

SQL Server 2016 | Intermediate

12 Videos | 1h 10m 16s
Includes Assessment
Earns a Badge

It's important to understand the various components, editions, and versions that exist when discussing SQL Server 2016. Explore the SQL Server platform and best practices and guidelines to follow when preparing for an installation.

WHAT YOU WILL LEARN

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

IN THIS COURSE

1.

SQL Server Components

9m 21s

UP NEXT
2.

SQL Server Instances

5m 42s
3.

SQL Server Editions

4m 26s

FREE ACCESS
4.

SQL Server Versions

5m 24s

FREE ACCESS
5.

32-bit Systems

3m 45s

FREE ACCESS
6.

64-bit Systems

3m 10s

FREE ACCESS
7.

SQL Server Hardware Requirements

5m 30s

FREE ACCESS
8.

SQL Server Software Requirements

4m 7s

FREE ACCESS
9.

I/O Subsystems for SQL Server

4m 23s

FREE ACCESS
10.

SQLIOSim Tool

9m 37s

FREE ACCESS
11.

Diskspd Tool

6m 37s

FREE ACCESS
12.

Exercise: SQL Server 2016 Installation Requirements

2m 46s

FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.