Applying SQL Server 2016 Features to Real-world Data Problems

Pluralsight
Course Summary
Explore the newest features and performance improvements of SQL Server 2016, quickly after its release on the market. This course will teach you about some amazing new functionality that will help enhance the performance of your solution.
-
+
Course Description
Along with the release of SQL Server 2016 comes some amazing new functionality that will help enhance the performance of your solution, improve security, integrate and analyze data from all types of sources, and scale your solution to the cloud. In this course, Applying SQL Server 2016 Features to Real-world Data Problems, you'll be able to apply these functionalities to any real-world data problem you may have. First, you'll learn about improving the performance database solution by using in-memory OLTP enhancements, query data store, temporal database, and JSON support. Next, you'll learn how to enhance security at a database level using AlwaysEncrypted, dynamic data masking, and row level security. Finally you'll learn how to head towards the cloud and how HappyScoopers can easily adapt their existent solution to use the powers of the cloud. By the end of this course, you'll have a strong foundational understanding on how to apply the amazing new features of SQL Server 2016 to solve your own real world problems.
-
+
Course Syllabus
Getting Started- 6m 46s
—Introduction to SQL Server 2016 3m 15s
—Introduction to the Sample Company 3m 31sImproving the Performance of Your Database- 38m 17s
—Introduction 1m 17s
—Query Store - General Information 2m 57s
—Query Store - Usage Scenarios 3m 20s
—How Does Query Store Work? 2m 32s
—Demo: Using Query Store for Performance Troubleshooting 6m 17s
—Live Query Statistics 1m 34s
—Demo: Live Query Statistics 3m 14s
—Built-in JSON Support 1m 15s
—Demo: Built-in JSON Support 5m 31s
—Temporal Tables - General Information 2m 10s
—Temporal Tables - Under the Hood 3m 29s
—Demo: Keeping History with Temporal Tables 4m 36sEnhancing Security at Database Level- 46m 45sAchieving Deeper Data Insights- 30m 41sHeading Towards the Cloud- 33m 51s