When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
SQL Server 2016 New Features for Developers
This course teaches the new developer features in SQL Server 2016, including Drop If Exists (DIE), SESSION_CONTEXT, dynamic data masking (DDM), row-level security (RLS), Always Encrypted, stretch database, temporal data, and built-in JSON support.
This Course Includes
pluralsight
5 (97 reviews )
3 hour 42 minutes 
english
Online - Self Paced
core courses
pluralsight
About SQL Server 2016 New Features for Developers
This demo-packed course, SQL Server 2016 New Features for Developers, teaches the many powerful features for developers that have been added in SQL Server 2016. First, you'll discover new security features such as dynamic data masking (DDM), row-level security (RLS), and Always Encrypted. Next, you'll learn about the innovative capabilities, including "stretch" database (allow select tables in an on-premises database to be transparently relocated in Azure SQL Database), and temporal data (enable "time travel" to access data as it existed at any point in time). You'll also learn about the new built-in Javascript Object Notation (JSON) support which enables bi-directional manipulation of JSON data in SQL Server. By the end of this course, you'll be ready for SQL Server 2016 and its exciting new developer features.
What You Will Learn?
- Course Overview : 2mins.
- Introduction and Overview : 19mins.
- Dynamic Data Masking : 20mins.
- Row-level Security : 38mins.
- Always Encrypted : 36mins.
- Stretch Database : 34mins.
- Temporal Data : 28mins.
- Built-in JSON Support : 41mins.