IL - SQL Server 2016 Advanced Features

Course Overview

This is a custom 3-day SQL Server 2016 training course. This 400 level course covers In-Memory OLTP, Column store Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

Course Details
  • Duration: 3 Days
  • Level: 400

Who this course is designed for
  • Experienced Database Administrators
  • Database Developers
  • Database Architects


Module 1: In-Memory OLTP

In this module, students will learn how to implement In-Memory OLTP. We will cover Memory-Optimized Table architecture, accessing memory-optimized tables, indexing, concurrency, checkpointing, and native compilation.

Module 2: Columnstore Indexing

In this module, the student will learn the architecture and usage of Columnstore Indexing in SQL Server 2016. We will start with an architectural overview of columnstore indexing. We will discuss the different access patterns for columnstore indexes and best practices for loading data into columnstores including columnstore maintenance. We will finish up with a look into ideal use cases and anti-patterns for columnstore indexing.

Module 3: Real-time Operational Analytics   

In this module, students will combine the skills learned in the previous modules to implement real-time analytics in SQL Server 2016.

Module 4: Query Store and Live Query Statistics

In this module, students will learn how to use Query Store in SQL 2016. We will cover configuration and management of the Query Store. We will also look into key use patterns such as identifying query regression and forcing query plans.

Module 5: Leverage JSON in SQL Server 2016
In this module, the student will learn how to manage and work with JSON data in SQL Server 2016. This module will cover DML processes with JSON data. We will look at import and export of JSON and indexing JSON data.

Module 6: Troubleshooting SQL Server 2016 Availability Groups Using Extended Events 

This module will focus on troubleshooting Availability Groups using Extended Events traces. We start off with a review of extended event architecture then jump into a review of several key scenarios for leveraging extended events to troubleshoot Availability Groups.


Contact the experts at Opsgility to schedule this class at your location or to discuss a more comprehensive readiness solution for your organization. Contact us to enroll or book a class

Contact Us
Looking for on-demand training?