SQL Platform & Installation Best Practices

SQL Server 2016    |    Intermediate
  • 12 videos | 1h 4m 46s
  • Includes Assessment
  • Earns a Badge
Likes 74 Likes 74
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 Database Fundamentals: Getting Started with SQL
Course Microsoft Azure Fundamentals: Management Tools
Book Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Backup Management
Likes 110 Likes 110  
Course Database Programmability Objects & Non-relational Data
Likes 49 Likes 49  
Course Upgrading to SQL Server 2016
Likes 57 Likes 57