Architecture

SQL Server 2016    |    Intermediate
  • 8 videos | 47m 7s
  • Includes Assessment
  • Earns a Badge
Understanding the architecture of SQL Server 2016 is important to being able to effectively work with it. Explore the SQL Server architecture, including parallelism, I/O operations, account types, and network protocols.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 7m 4s
    After completing this video, you will be able to describe the various account types available in SQL Server 2016. FREE ACCESS
  • 5m 9s
    After completing this video, you will be able to explain the different network protocols supported by SQL Server 2016. FREE ACCESS
  • Locked
    3.  SQL Server Memory Management
    5m 25s
    Upon completion of this video, you will understand the various hardware requirements for SQL Server 2016. FREE ACCESS
  • Locked
    4.  Parallelism
    4m 26s
    After completing this video, you will understand the various software requirements for SQL Server 2016. FREE ACCESS
  • Locked
    5.  I/O Operations
    3m 50s
    After completing this video, you will be able to describe considerations for implementing I/O subsystems for SQL Server 2016. FREE ACCESS
  • Locked
    6.  SQL Server Services
    7m 26s
    In this video, you will learn how to use the SQLIOSim tool in SQL Server 2016. FREE ACCESS
  • Locked
    7.  Account Types
    8m 43s
    In this video, you will learn how to use the Diskspd tool in SQL Server 2016. FREE ACCESS
  • Locked
    8.  Network Protocols
    5m 4s
    In this video, you will learn how to determine the requirements for a successful SQL Server deployment. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition
Course Data Types & Normalization
Course Auditing

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Architecture Concepts
Course Backup Management
Course Subqueries & the EXISTS Predicate