Columnstore Indexes
SQL Server 2016
| Intermediate
- 10 Videos | 43m 46s
- 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 indexesdetermine when to implement a columnstore indexcreate a clustered columnstore indexdescribe columnstore index data loadingdescribe columnstore versioned feature summary
-
improve columnstore index query performanceimplement real-time operational analyticsdescribe columnstore index data warehousingimplement columnstore index defragmentationdifferentiate 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.