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 SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Book Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries
Book High Performance SQL Server: Consistent Response for Mission-Critical Applications, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Types & Normalization
Rating 4.6 of 124 users Rating 4.6 of 124 users (124)
Course Data Integrity & Constraints
Rating 4.3 of 168 users Rating 4.3 of 168 users (168)
Course Memory-optimized Tables & Native Stored Procedures
Rating 4.6 of 27 users Rating 4.6 of 27 users (27)