Columnstore Indexes
SQL Server 2016
| Intermediate
- 10 Videos | 48m 16s
- Includes Assessment
- Earns a Badge
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
-
1.Columnstore Index Overview6m 49sUP NEXT
-
2.When to Implement a Columnstore Index3m 17s
-
3.Creating a Clustered Columnstore Index5m 11s
-
4.Columnstore Indexes Data Loading3m 17s
-
5.Columnstore Versioned Feature Summary2m 41s
-
6.Columnstore Indexes Query Performance5m 21s
-
7.Columnstore for Real-time Operational Analytics3m 51s
-
8.Columnstore Indexes for Data Warehousing3m 13s
-
9.Columnstore Indexes Defragmentation4m 56s
-
10.Exercise: Configure Columnstore Indexes5m 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.
