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.;