Columnstore Indexes

SQL Server 2016    |    Intermediate
  • 10 videos | 43m 46s
  • Includes Assessment
  • Earns a Badge
Likes 25 Likes 25
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 Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries
Course Querying with Joins
Likes 62 Likes 62  
Course Querying & Manipulating Data
Likes 112 Likes 112  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Integrity & Constraints
Likes 49 Likes 49  
Course Memory-optimized Tables & Native Stored Procedures
Likes 29 Likes 29  
Course Extended Events & SQL Trace
Likes 40 Likes 40