Index Design Guidelines

SQL Server 2016    |    Intermediate
  • 11 videos | 1h 3m 45s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 97 users Rating 4.5 of 97 users (97)
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

  • 9m 23s
    After completing this video, you will be able to recognize the basic guidelines for designing and implementing indexes. FREE ACCESS
  • 7m 1s
    Upon completion of this video, you will be able to describe when to use tables without clustered indexes. FREE ACCESS
  • Locked
    3.  Clustered vs. Nonclustered Indexes
    10m 32s
    Upon completion of this video, you will be able to recognize the basic guidelines for designing and implementing indexes. FREE ACCESS
  • Locked
    4.  Creating Clustered Indexes
    5m 14s
    During this video, you will learn how to create indexes that are clustered. FREE ACCESS
  • Locked
    5.  Creating Nonclustered Indexes
    4m 30s
    In this video, you will learn how to create nonclustered indexes. FREE ACCESS
  • Locked
    6.  Creating Unique Indexes
    3m 39s
    Learn how to create indexes that are unique. FREE ACCESS
  • Locked
    7.  Creating Filtered Indexes
    5m 20s
    In this video, you will learn how to create filtered indexes. FREE ACCESS
  • Locked
    8.  Creating Indexes with Included Columns
    4m 27s
    In this video, you will learn how to create indexes with included columns. FREE ACCESS
  • Locked
    9.  Deleting Indexes
    2m 38s
    In this video, you will learn how to delete indexes. FREE ACCESS
  • Locked
    10.  Modifying Indexes
    4m 29s
    In this video, you will modify indexes. FREE ACCESS
  • Locked
    11.  Exercise: Create Indexes with Included Columns
    6m 32s
    Upon completion of this video, you will be able to describe the use of views. 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 Designing & Implementing Views
Rating 4.6 of 70 users Rating 4.6 of 70 users (70)
Course MySQL Database Development: Query & Performance Optimization
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Keeping Business Calls Professional
Rating 4.6 of 3767 users Rating 4.6 of 3767 users (3767)
Course Querying with Joins
Rating 4.6 of 89 users Rating 4.6 of 89 users (89)
Course Functions
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)