Index Design Guidelines

SQL Server 2016
  • 11 Videos | 1h 8m 45s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
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 15 Likes 15  
Likes 23 Likes 23  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Functions
Likes 16 Likes 16  
COURSE Transactions
Likes 14 Likes 14  
Likes 19 Likes 19