Skip to content
Pluralsight Logo
  • Pluralsight
  • Skills
  • Flow
  • Blog
    • Sign in to

      Sign in to Pluralsight Skills
    • Sign in to

      Sign in to Pluralsight Flow
Logo for Pluralsight Skills
Pluralsight Logo
  • Sign in
  • Menu
  • Sign in to Pluralsight Skills

    Sign in to Skills

  • Sign in to Pluralsight Flow

    Sign in to Flow

  • Pluralsight
  • Skills
  • Flow
  • Blog
  • Why Skills?
    • Ways to upskill
    • Icon for Courses Courses
    • Icon for Skills assessments Skill assessments
    • Icon for Labs Labs
    • Icon for Hands-on learning Hands-on learning
    • Icon for Certification prep Certification prep
    • See our entire course library
    • Skills for
    • Icon for Software development Software development
    • Icon for IT ops IT Ops
    • Icon for Info & cyber security Info & cybersecurity
    • Icon for Cloud computing Cloud computing
    • Icon for Machine learning Machine learning
    • Icon for Data professional Data professional
    • For individuals
    • Top trending paths
    • Microsoft Azure Deployment
      Microsoft Azure
    • Cleaning Data with R
      Cleaning data with R
    • Ruby Language Fundamentals
      Ruby Language Fundamentals
    • AWS Operations
      AWS Operations
    • Core Python
      Core Python
  • View plans
  • For individuals
  • Contact Sales
  • Try for free

Contact Sales

1020 Redirect Link
Thank you!
Our team will be in touch shortly.

Loading form...

If this message remains, it may be due to cookies being disabled or to an ad blocker.

Close button
✖
Pluralsight Skills
Pluralsight Skills

Free Weekend

Free Weekend

February 3 - 5

February 3 - 5

Sign up now
Sign up now
Pluralsight Skills
Pluralsight Skills

Free Weekend

Free Weekend

February 3 - 5

February 3 - 5

Sign up now
Sign up now
pluralsight skills

Free Weekend

February 3 - 5

Sign up now
✖
Pluralsight Skills
Pluralsight Skills

Free Weekend

Free Weekend

February 3 - 5

February 3 - 5

Sign up now
Sign up now
Pluralsight Skills
Pluralsight Skills

Free Weekend

Free Weekend

February 3 - 5

February 3 - 5

Sign up now
Sign up now
pluralsight skills

Free Weekend

February 3 - 5

Sign up now
×
Azure Labs
Labs badge iconLAB

Manage Sensitive Data with Dynamic Data Masking and Data Encryption

In this lab, you’ll manage sensitive data with Azure SQL Database through dynamic data masking and data encryption. When you’re finished with this lab, you’ll have experience setting up dynamic data masking and data encryption in the Azure portal.

* Our Labs are Available for Enterprise and Professional plans only.
Terms and conditions apply.
Contact sales
Labs - Manage Sensitive Data with Dynamic Data Masking and Data Encryption

Lab info

Rating (85)
Level
Beginner
Duration
55m
Released
Nov 02, 2021

Lab author

Lab Author: Bismark Adomako
Bismark Adomako
Bismark believes that education is no longer a one-time investment, but instead a lifelong pursuit and that great authors and mentors can play an invaluable role in finding and developing a fulfilling career. He holds a Bachelor of Science degree in Computer Engineering specializing in Software Engineering, Artificial Intelligence and Distributed computing. He taught courses in robotics and computer vision as a student leader whiles in school, and interned and consulted for the British Counci... morel as a Software Engineer and Project Assistant. He currently works as a Business Intelligence and Big Data developer doubling up as a Data Scientist at Ecobank eProcess International S.A. developing machine learning models some of which includes the Customer360 model consisting of a customer segmentation model, customer churn model, and customer cross selling (product recommendation) model. He has enterprise level knowledge in data integration for BI & Data Management domain applications.
  • Table of contents
  • What's a lab?
  • Prerequisites
Challenge

Create a Sample Database

Create a database with sample data to demonstrate dynamic data masking.

Challenge

Create an SQL User Account

You will create an SQL user account and login to demonstrate the access capabilities.

Challenge

Set up Dynamic Data Masking from the Azure Portal

You will add masks to the necessary columns in your database and add masking rules to columns.

Challenge

Mask String Values with a Custom Format

Mask string values with your preferred format.

Challenge

Grant Access to Users to View Masked Data

Remove masking from a column and grant access to users to view masked data.

Challenge

Manage Transparent Data Encryption in Azure Portal

Locate and enable or disable data encryption.

Labs - code icon

Provided environment for hands-on practice

We will provide the credentials and environment necessary for you to practice right within your browser.

Labs - list icon

Guided walkthrough

Follow along with the author’s guided walkthrough and build something new in your provided environment!

Labs - analytic icon

Did you know?

On average, you retain 75% more of your learning if you get time for practice.

Recommended prerequisites

  •  Download and install Azure Data Studio

Start learning by doing today

Contact sales

Contact Sales

1020 Redirect Link
Thank you!
Our team will be in touch shortly.

Loading form...

If this message remains, it may be due to cookies being disabled or to an ad blocker.

Close button

Ready to skill up
your entire team?

10
Subscriptions
Need more subscriptions? Contact sales.
Continue to checkout Continue to checkout
Cancel

With your Pluralsight plan, you can:

With your 30-day pilot, you can:

  • Access thousands of videos to develop critical skills
  • Give up to 10 users access to thousands of video courses
  • Practice and apply skills with interactive courses and projects
  • See skills, usage, and trend data for your teams
  • Prepare for certifications with industry-leading practice exams
  • Measure proficiency across skills and roles
  • Align learning to your goals with paths and channels

Ready to skill up
your entire team?

10
Subscriptions
Need more subscriptions? Contact sales.
Continue to checkout
Cancel

With your Pluralsight plan, you can:

With your 30-day pilot, you can:

  • Access thousands of videos to develop critical skills
  • Give up to 10 users access to thousands of video courses
  • Practice and apply skills with interactive courses and projects
  • See skills, usage, and trend data for your teams
  • Prepare for certifications with industry-leading practice exams
  • Measure proficiency across skills and roles
  • Align learning to your goals with paths and channels
  • Support

    • Contact
    • Help Center
    • IP Allowlist
    • Site Map
    • Download Pluralsight
    • Skills Plans
    • Flow Plans
  • Community

    • Guides
    • Teach
    • Partner with Pluralsight
    • Affiliate Partners
    • Pluralsight One
    • Authors
  • Company

    • About Us
    • Careers
    • Newsroom
    • Resources
  • Industries

    • Public Sector
    • Non-Profit

Newsletter

Sign up with your email to join our mailing list.

1041 Redirect Link Form Submitted Successfully!

Loading form...

If this message remains, it may be due to cookies being disabled or to an ad blocker.

  • Facebook Logo Icon
  • Twitter Logo Icon
  • Instagram Logo Icon
  • LinkedIn Logo Icon
  • Youtube Logo Icon
Pluralsight Logo Copyright © 2004 - 2023 Pluralsight LLC. All rights reserved
  • Terms of Use
  • Privacy Notice
  • Modern Slavery Statement