SQL Server 2016 Advanced Features

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,
4 (8)
INDIVIDUAL

For those who are on a technical journey of self improvement

TRY FREE FOR 10 DAYS
TEAMS

Ideal for 5 or more in need of upskilling

TRY FOR FOR FREE
(Trial or Pilot)
ENTERPRISE

Ideal for 200 or more in need of upskilling and scalability

LEARN MORE
1 Lectures
3 Labs
Advanced
4h 44m
Lecture
Feb 23 2017
2h 44m

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

0%
Real Time Lab
Jan 10 2018
Skill Me Up
40m

In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.

0%
Real Time Lab
Jul 23 2020
Skill Me Up
40m

In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.

0%
Real Time Lab
Jul 23 2020
Skill Me Up
40m

In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries ...

0%