Columnstore Indexes

SQL Server 2016    |    Intermediate
  • 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 T-SQL Queries
Likes 173 Likes 173  
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 26 Likes 26  
Likes 20 Likes 20  
COURSE SOLID & GRASP
Likes 3218 Likes 3218