Columnstore Indexes

SQL Server 2016    |    Intermediate
  • 10 videos | 43m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 37 users Rating 4.6 of 37 users (37)
Columnstore indexes work differently from traditional indexes in SQL Server 2016. Discover how to implement columnstore indexes in SQL Server 2016.

WHAT YOU WILL LEARN

  • Recognize when to use columnstore indexes
    Determine when to implement a columnstore index
    Create a clustered columnstore index
    Describe columnstore index data loading
    Describe columnstore versioned feature summary
  • Improve columnstore index query performance
    Implement real-time operational analytics
    Describe columnstore index data warehousing
    Implement columnstore index defragmentation
    Differentiate between clustered and nonclustered columnstore indexes in sql sever 2016

IN THIS COURSE

  • 6m 49s
    Upon completion of this video, you will be able to recognize when to use column store indexes. FREE ACCESS
  • 3m 17s
    During this video, you will learn how to determine when to implement a column store index. FREE ACCESS
  • Locked
    3.  Creating a Clustered Columnstore Index
    5m 11s
    In this video, you will create a clustered column store index. FREE ACCESS
  • Locked
    4.  Columnstore Indexes Data Loading
    3m 17s
    After completing this video, you will be able to describe data loading for a columnstore index. FREE ACCESS
  • Locked
    5.  Columnstore Versioned Feature Summary
    2m 41s
    After completing this video, you will be able to describe the columnstore versioned feature summary. FREE ACCESS
  • Locked
    6.  Columnstore Indexes Query Performance
    5m 21s
    In this video, find out how to improve the performance of queries that use a columnstore index. FREE ACCESS
  • Locked
    7.  Columnstore for Real-time Operational Analytics
    3m 51s
    During this video, you will learn how to implement operational analytics in real time. FREE ACCESS
  • Locked
    8.  Columnstore Indexes for Data Warehousing
    3m 13s
    After completing this video, you will be able to describe columnstore index data warehousing. FREE ACCESS
  • Locked
    9.  Columnstore Indexes Defragmentation
    4m 56s
    In this video, you will learn how to defragment a columnstore index. FREE ACCESS
  • Locked
    10.  Exercise: Configure Columnstore Indexes
    5m 11s
    In this video, you will learn the difference between clustered and nonclustered columnstore indexes in 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

Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition
Course Subqueries & the EXISTS Predicate
Rating 4.7 of 53 users Rating 4.7 of 53 users (53)
Course Architecture
Rating 4.2 of 30 users Rating 4.2 of 30 users (30)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Platform & Installation Best Practices
Rating 4.5 of 50 users Rating 4.5 of 50 users (50)
Course Optimize Locking Behavior
Rating 4.6 of 39 users Rating 4.6 of 39 users (39)
Course New Project Manager Essentials
Rating 4.5 of 4091 users Rating 4.5 of 4091 users (4091)