SQL Server: Security, Encryption, and Masking

1hBeginner2018-09-19

Authors

Joey D'Antoni

Consultant and Thought Leader

Course details

Learn how to build more secure applications using the advanced security features in SQL Server 2017. Instructor Joey D'Antoni takes a deep dive into SQL Server row-level security, which allows you to restrict access to specific table data, and shows how to encrypt data using the built-in features in SQL Server, such as Always Encrypted, which protects sensitive client data without revealing encryption keys. Plus, discover how to perform data masking to prevent low-privileged users from seeing confidential information.

Learning objectives
Designing row-level security
Using views to implement row-level security in SQL Server pre-2016
Data encryption
Configuring Always Encrypted
Dynamic data masking

Skills covered

SQLDatabase AdministrationDatabase ManagementPersonaOpen Source

Concepts

0. Introduction

01 - Reduce coding pains by optimizing security features in SQL 2017
02 - Course software

1. Row-Level Security (RLS)

03 - Get started with row-level security
04 - Design a row-level security model
05 - Demo - Row-level security
06 - Implement row-level security
07 - Use views to implement RLS pre-2016
08 - Demo - RLS with views
09 - Other options for multi-tenant databases

2. Encryption in SQL Server

10 - Introduction to encryption in SQL Server
11 - What data should I encrypt
12 - Cell-level encryption
13 - Demo - Cell-level encryption
14 - Always Encrypted
15 - Demo - Implement Always Encrypted
16 - Demo - Azure Key Vault with Always Encrypted
17 - Manage Always Encrypted keys

3. Data Masking in SQL Server

18 - Data masking and SQL Server
19 - Demo - Dynamic data masking
20 - Demo - Build a masked set of data for testing
21 - Limits of dynamic masking

Conclusion

22 - Next steps