Discover essential tips and tricks for mastering Microsoft SQL 2016 in this concise 35-minute tutorial. Explore key features such as Row-Level Security, Data Masking, and Encryption. Learn how to implement Row-Level Security through a practical demonstration, understand the process of masking sensitive data, and gain insights into encryption techniques. Dive into backwards script examples, table alterations, and the addition of masks and partials. Examine the strengths and weaknesses of these security measures, and understand data conversion processes. Enhance your SQL skills and improve database security with expert guidance from Learnit Training professionals.
Overview
Syllabus
Introduction
RowLevel Security
RowLevel Security Demo
RowLevel Security Overview
Data Mask
Sensitive Data
Encryption
Backwards
Script Example
Alter Table
Add Mask
Add Partial
View Original Data
Weaknesses
Conversion
Taught by
Learnit Training
Related Courses
-
Data Management with Azure: Implement Compliance Controls
-
AZ-500: Secure compute, storage, and databases
-
SC-400: Implement Information Protection in Microsoft 365
-
Implement a secure environment for a database service
-
Microsoft SQL Server Development for Everyone
-
Complete Microsoft SQL Server Database Administration Course
