Index Design Guidelines

SQL Server 2016    |    Intermediate
  • 11 Videos | 1h 8m 45s
  • Includes Assessment
  • Earns a Badge
Likes 33 Likes 33
SQL Server 2016 uses indexes to speed up the performance of queries and improve overall database performance. Discover how to design and implement the various index types available in SQL Server 2016.

WHAT YOU WILL LEARN

  • recognize the basic guidelines to follow when designing and implementing indexes
    describe when to use tables without clustered indexes
    recognize the basic guidelines to follow when designing and implementing indexes
    create clustered indexes
    create nonclustered indexes
    create unique indexes
  • create filtered indexes
    create indexes with included columns
    delete indexes
    modify indexes
    describe the use of views

IN THIS COURSE

  • Playable
    1. 
    Index Design Basics
    9m 23s
    UP NEXT
  • Playable
    2. 
    Tables Without Clustered Indexes
    7m 1s
  • Locked
    3. 
    Clustered vs. Nonclustered Indexes
    10m 32s
  • Locked
    4. 
    Creating Clustered Indexes
    5m 14s
  • Locked
    5. 
    Creating Nonclustered Indexes
    4m 30s
  • Locked
    6. 
    Creating Unique Indexes
    3m 39s
  • Locked
    7. 
    Creating Filtered Indexes
    5m 20s
  • Locked
    8. 
    Creating Indexes with Included Columns
    4m 27s
  • Locked
    9. 
    Deleting Indexes
    2m 38s
  • Locked
    10. 
    Modifying Indexes
    4m 29s
  • Locked
    11. 
    Exercise: Create Indexes with Included Columns
    6m 32s

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

Likes 26 Likes 26  
COURSE T-SQL Queries
Likes 173 Likes 173  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 20 Likes 20  
Likes 26 Likes 26  
COURSE Functions
Likes 26 Likes 26