SQL Server 2019 - Security Features
Lab
Beginner
0 h 30 m
2020-04-06
Lab Overview
In this lab, you will learn how to use SQL Server Management Studio (SSMS) and T-SQL to classify columns of tables in a database. You will use the WideWorldImporters sample database to classify specific columns in tables of that database.

Related Learning Path(s):
What is new with SQL Server 2019
Objectives
  • Understand how to use Data Discovery and Classification with SQL Server 2019
  • Understand how to use SQL Server Audit with Data Classification
Exercises
In this exercise, you will learn how to use SQL Server Management Studio (SSMS) and T-SQL to classify columns of tables in a database. You will use the **WideWorldImporters** sample database to classify specific columns in tables of that database.
In this exercise you will learn how to audit users trying to view columns that were marked for data classification.
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More