Pluralsightintermediateen

SQL Server 2016 New Features for Developers

Learn SQL Server 2016 developer features: Drop If Exists, dynamic data masking, row-level security, Always Encrypted & more. Modern database development skills.

4.8(97)
3h 42m
Certificate
Leonard Lobel
Leonard LobelInstructor

Course Content

SQL Server 2016 New Features for Developers is an intermediate-level Pluralsight course taught by Leonard Lobel. It runs 3h 42m, is taught in English, and includes a certificate of completion. Learners rate it 4.8 out of 5 from 97 reviews. It is a paid course, first published July 2024.

Unlock the power of SQL Server 2016 for developers with this comprehensive, demo-rich course! Dive into the latest advancements and learn how to leverage key features to build robust and secure applications.

Master New SQL Server 2016 Developer Features:

  • Enhanced Security: Explore cutting-edge security enhancements designed to protect your data. Learn to implement:

    • Dynamic Data Masking (DDM): Mask sensitive data to control access and protect privacy.
    • Row-Level Security (RLS): Implement granular access control at the row level for enhanced data security.
    • Always Encrypted: Encrypt sensitive data within the database, ensuring data remains protected even from database administrators.
  • Innovative Capabilities: Discover game-changing features that expand the possibilities of your SQL Server development:

    • SQL Server Stretch Database: Transparently extend your on-premises SQL Server database to Azure SQL Database, enabling efficient data management and scalability. Learn how to seamlessly relocate select tables to Azure.
    • Temporal Tables: Gain the ability to track data changes over time. Enable "time travel" to access historical data as it existed at any point in the past.
  • Built-in JSON Support: Simplify working with modern data formats. This course covers the new, built-in JavaScript Object Notation (JSON) support in SQL Server, allowing for:

    • Bi-directional JSON manipulation: Easily work with JSON data both inside and outside of SQL Server.

By the end of this course, you'll be well-equipped to harness the full potential of SQL Server 2016 and its exciting new developer features. Become proficient in building secure, scalable, and modern data applications.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0
2h 50m
intermediate
pluralsight
5.0
1h 11m
beginner
pluralsight
5.0
43m
beginner
pluralsight
5.0
4h 43m
expert
pluralsight