Columnstore Indexes

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
Columnstore indexes work differently from traditional indexes in SQL Server 2016. This course covers how to implement columnstore indexes in SQL Server 2016, as well as the various columnstore performance considerations that can impact operations. This course also covers nonclustered indexes, in-memory indexes, and XML indexes. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisites
None

Expected Duration (hours)
1.5

Lesson Objectives

Columnstore Indexes

start the course

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 Server 2016

create a nonclustered columnstore index

change data in a nonclustered columnstore index

describe in-memory nonclustered hash indexes

create tables with nonclustered hash indexes

describe in-memory index performance considerations

describe XML indexes

describe secondary XML indexes

describe XML index performance considerations

implement and configure columnstore indexes

Course Number:
df_sqld_a03_it_enus

Expertise Level
Intermediate