Microsoft Azure SQL Database Security


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
Determining how to secure databases in SQL Server 2016 is one of the most important parts of a deployment strategy. This course covers how to implement firewalls, authentication, and auditing to ensure Microsoft Azure SQL database security. In addition, this course covers dynamic data masking, a feature in SQL Server 2016 that can be used to limit exposure to sensitive data. This course is one of a series of courses that cover the objectives for the 20765A: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Prerequisites
None

Expected Duration (hours)
1.6

Lesson Objectives

Microsoft Azure SQL Database Security

  • start the course
  • describe the benefits of enabling a SQL Server firewall
  • demonstrate how to configure SQL Server 2016 firewall rules
  • demonstrate how to manage existing firewall rules in the Azure portal
  • explain how to restrict and secure a connection to a SQL Server database
  • explain how the connection process redirects machines to a different IP address and port
  • describe how to implement authentication in SQL Server 2016
  • describe considerations involving the implementation of contained database users
  • explain the restrictions involving managing logins and users
  • describe how to implement SQL database auditing
  • explain how authorization can be used when securing SQL Server databases
  • 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

    • Course Number:
    df_sqlp_a05_it_enus

    Expertise Level
    Intermediate