Architecture

SQL Server 2016    |    Intermediate
  • 8 videos | 47m 7s
  • Includes Assessment
  • Earns a Badge
Rating 4.2 of 30 users Rating 4.2 of 30 users (30)
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

Course Querying SQL Databases: Learning SQL Using Prompt Engineering
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers, 2nd Edition
Journey Introduction to Computer Architecture
Rating 4.8 of 4 users Rating 4.8 of 4 users (4)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Installation & Configuration
Rating 4.6 of 31 users Rating 4.6 of 31 users (31)
Course T-SQL Queries
Rating 4.3 of 218 users Rating 4.3 of 218 users (218)
Course Getting Started with Power Query in Power BI
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)