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

Go to class Write review
Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More → Udacity Ad

Master AI & Data—50% Off Udacity (Code CC50)

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.