Dynamic Data Masking

SQL Server 2016    |    Intermediate
  • 9 videos | 40m 25s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 9 users Rating 4.3 of 9 users (9)
Part of your deployment strategy should be to secure not only the databases but also the data itself. Examine dynamic data masking, a feature in SQL Server 2016 that can be used to limit exposure to sensitive data.

WHAT YOU WILL LEARN

  • Describe dynamic data masking
    Describe the four types of dynamic data masks
    Explain how to implement dynamic data masking policies and permissions
    Demonstrate how to query masked columns in sql server 2016
    Explain the limitations and restrictions of dynamic data masking
  • Demonstrate how to create a dynamic data mask
    Demonstrate how to configure dynamic data masking using the azure portal
    Demonstrate how to configure dynamic data masking using powershell
    Configure firewall rules in azure sql database

IN THIS COURSE

  • 4m 36s
    After completing this video, you will be able to describe dynamic data masking. FREE ACCESS
  • 4m 25s
    Upon completion of this video, you will be able to describe the four types of dynamic data masks. FREE ACCESS
  • Locked
    3.  Dynamic Data Masking Polices and Permissions
    3m 59s
    After completing this video, you will be able to explain how to implement dynamic data masking policies and permissions. FREE ACCESS
  • Locked
    4.  Querying for Masked Columns
    4m 40s
    In this video, you will learn how to query columns with masked data in SQL Server 2016. FREE ACCESS
  • Locked
    5.  Dynamic Data Masking Limitations and Restrictions
    2m 22s
    After completing this video, you will be able to explain the limitations and restrictions of dynamic data masking. FREE ACCESS
  • Locked
    6.  Creating a Dynamic Data Mask
    7m 23s
    In this video, you will learn how to create a dynamic data mask. FREE ACCESS
  • Locked
    7.  Configure Dynamic Data Masking in the Azure Portal
    4m 58s
    In this video, you will learn how to configure dynamic data masking using the Azure portal. FREE ACCESS
  • Locked
    8.  Configure Dynamic Data Masking Using PowerShell
    4m 13s
    In this video, you will learn how to configure dynamic data masking using PowerShell. FREE ACCESS
  • Locked
    9.  Exercise: Configure Azure SQL Database Firewall Rules
    3m 50s
    During this video, you will learn how to configure firewall rules in Azure SQL Database. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Filtering Data
Rating 4.5 of 86 users Rating 4.5 of 86 users (86)
Course Querying with Joins
Rating 4.6 of 89 users Rating 4.6 of 89 users (89)
Course Data Engineering on Microsoft Azure: Securing Data Access
Rating 4.7 of 28 users Rating 4.7 of 28 users (28)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Securing Azure SQL Databases
Rating 4.6 of 19 users Rating 4.6 of 19 users (19)
Course Configuring Operators & Alerts
Rating 4.4 of 10 users Rating 4.4 of 10 users (10)
Course Data Access & Permissions
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)