SQL Platform & Installation Best Practices

SQL Server 2016    |    Intermediate
  • 12 videos | 1h 4m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 50 users Rating 4.5 of 50 users (50)
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

  • 9m 21s
    After completing this video, you will be able to recognize the components of SQL Server 2016. FREE ACCESS
  • 5m 42s
    After completing this video, you will be able to describe SQL Server 2016 instances. FREE ACCESS
  • Locked
    3.  SQL Server Editions
    4m 26s
    Upon completion of this video, you will be able to describe the different editions of SQL Server 2016. FREE ACCESS
  • Locked
    4.  SQL Server Versions
    5m 24s
    After completing this video, you will be able to describe different SQL Server versions. FREE ACCESS
  • Locked
    5.  32-bit Systems
    3m 45s
    After completing this video, you will be able to explain SQL Server 2016 32-bit systems. FREE ACCESS
  • Locked
    6.  64-bit Systems
    3m 10s
    After completing this video, you will be able to explain SQL Server 2016 64-bit systems. FREE ACCESS
  • Locked
    7.  SQL Server Hardware Requirements
    5m 30s
    After completing this video, you will be able to recognize the different layers of the SQL Server 2016 architecture. FREE ACCESS
  • Locked
    8.  SQL Server Software Requirements
    4m 7s
    After completing this video, you will be able to explain SQL Server 2016 CPU usage. FREE ACCESS
  • Locked
    9.  I/O Subsystems for SQL Server
    4m 23s
    After completing this video, you will be able to explain SQL Server 2016 Server memory management. FREE ACCESS
  • Locked
    10.  SQLIOSim Tool
    9m 37s
    Upon completion of this video, you will be able to describe parallelism in SQL Server 2016. FREE ACCESS
  • Locked
    11.  Diskspd Tool
    6m 37s
    After completing this video, you will be able to explain I/O operations in SQL Server 2016. FREE ACCESS
  • Locked
    12.  Exercise: SQL Server 2016 Installation Requirements
    2m 46s
    Upon completion of this video, you will be able to describe the various services used by SQL Server 2016. 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 Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Journey Working with Google Cloud SQL
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Auditing, Logging, & Event Handling
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)
Course Querying & Manipulating Data
Rating 4.7 of 132 users Rating 4.7 of 132 users (132)
Course Introduction to SQL Bootcamp: Session 1 Replay
Rating 4.3 of 375 users Rating 4.3 of 375 users (375)