Columnstore Indexes

SQL Server 2016
  • 10 Videos | 48m 16s
  • Includes Assessment
  • Earns a Badge
Likes 13 Likes 13
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.

YOU MIGHT ALSO LIKE

COURSE Triggers
Likes 24 Likes 24  
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 166 Likes 166  
Likes 72 Likes 72  
Likes 21 Likes 21