SQL Server 2016 New Features for Developers
Offered By: Pluralsight
Course Description
Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 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.
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 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.
Syllabus
- 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
Taught by
Leonard Lobel
Related Courses
Using Microsoft Azure Database ServicesA Cloud Guru Azure Data Factory : Implement SCD Type 1
Coursera Project Network via Coursera Working with Relational Data Stores in Azure
Coursera Project Network via Coursera Bases de Datos SQL en Azure
Coursera Project Network via Coursera Choose Azure SQL Database Service Tier that Suits Your Needs
Coursera Project Network via Coursera