• Online, Self-Paced
Course 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.

Learning 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

Nonclustered indexes

  • differentiate between clustered and nonclustered columnstore indexes in SQL Server 2016
  • create a nonclustered columnstore index
  • change data in a nonclustered columnstore index

In-memory Indexes

  • describe in-memory nonclustered hash indexes
  • create tables with nonclustered hash indexes
  • describe in-memory index performance considerations

XML Indexes

  • describe XML indexes
  • describe secondary XML indexes
  • describe XML index performance considerations

Practice: Implementing Columnstore Indexes

  • implement and configure columnstore indexes

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development