Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
IL - SQL Server 2016 Advanced Features
Instructor-Led Training
3 Days
Onsite or Virtual
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.

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.

Dedicated Training
Contact Us Today

Dedicated instructor-led training is designed for group training and is delivered by the experts at Opsgility. Delivery availability is anywhere in the world at your location or using advanced virtual training software.

  • Standard or Customized Curriculum
  • Globally Available for Delivery
  • Holistic Learning Plans are Available
  • Industry Recognized Subject Matter Experts