Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SQL Server: Security, Encryption, and Masking

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
Learn how to build more secure applications using the advanced security features in SQL Server 2017: row-level security, data encryption, and data masking.

Syllabus

Introduction
  • Reduce coding pains by optimizing security features in SQL 2017
  • Course software
1. Row-Level Security (RLS)
  • Get started with row-level security
  • Design a row-level security model
  • Demo: Row-level security
  • Implement row-level security
  • Use views to implement RLS pre-2016
  • Demo: RLS with views
  • Other options for multi-tenant databases
2. Encryption in SQL Server
  • Introduction to encryption in SQL Server
  • What data should I encrypt?
  • Cell-level encryption
  • Demo: Cell-level encryption
  • Always Encrypted
  • Demo: Implement Always Encrypted
  • Demo: Azure Key Vault with Always Encrypted
  • Manage Always Encrypted keys
3. Data Masking in SQL Server
  • Data masking and SQL Server
  • Demo: Dynamic data masking
  • Demo: Build a masked set of data for testing
  • Limits of dynamic masking
Conclusion
  • Next steps

Taught by

Joey D'Antoni

Reviews

4.8 rating at LinkedIn Learning based on 28 ratings

Start your review of SQL Server: Security, Encryption, and Masking

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.