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

  • Playable
    1. 
    SQL Server Components
    9m 21s
    UP NEXT
  • Playable
    2. 
    SQL Server Instances
    5m 42s
  • Locked
    3. 
    SQL Server Editions
    4m 26s
    FREE ACCESS
  • Locked
    4. 
    SQL Server Versions
    5m 24s
    FREE ACCESS
  • Locked
    5. 
    32-bit Systems
    3m 45s
    FREE ACCESS
  • Locked
    6. 
    64-bit Systems
    3m 10s
    FREE ACCESS
  • Locked
    7. 
    SQL Server Hardware Requirements
    5m 30s
    FREE ACCESS
  • Locked
    8. 
    SQL Server Software Requirements
    4m 7s
    FREE ACCESS
  • Locked
    9. 
    I/O Subsystems for SQL Server
    4m 23s
    FREE ACCESS
  • Locked
    10. 
    SQLIOSim Tool
    9m 37s
    FREE ACCESS
  • Locked
    11. 
    Diskspd Tool
    6m 37s
    FREE ACCESS
  • Locked
    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.

YOU MIGHT ALSO LIKE

COURSE Azure Data Fundamentals: Provisioning & Configuring Relational Data Services
BOOK Azure SQL Revealed: A Guide to the Cloud for SQL Server Professionals
BOOK Beginning T-SQL: A Step-by-Step Approach, Fourth Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL 2016 Tables
Likes 166 Likes 166  
COURSE SQL Developer
Likes 285 Likes 285  
COURSE Upgrading to SQL Server 2016
Likes 48 Likes 48