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

  • Playable
    1. 
    Columnstore Index Overview
    6m 49s
    UP NEXT
  • Playable
    2. 
    When to Implement a Columnstore Index
    3m 17s
  • Locked
    3. 
    Creating a Clustered Columnstore Index
    5m 11s
  • Locked
    4. 
    Columnstore Indexes Data Loading
    3m 17s
  • Locked
    5. 
    Columnstore Versioned Feature Summary
    2m 41s
  • Locked
    6. 
    Columnstore Indexes Query Performance
    5m 21s
  • Locked
    7. 
    Columnstore for Real-time Operational Analytics
    3m 51s
  • Locked
    8. 
    Columnstore Indexes for Data Warehousing
    3m 13s
  • Locked
    9. 
    Columnstore Indexes Defragmentation
    4m 56s
  • Locked
    10. 
    Exercise: Configure Columnstore Indexes
    5m 11s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 110 Likes 110  
Likes 405 Likes 405  
Likes 57 Likes 57