Implement a secure environment for a database service

Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
SQL Database
SQL Server

Implement SQL Server-based options for authentication and authorization, as well as Azure options for securing Azure SQL databases. Explore encryption, firewalls and advanced threat protection.

Prerequisites

  • Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based
  • Understanding of why security is a crucial part of database system planning
  • Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
  • Experience creating and configuring resources using the Azure portal

Modules in this learning path

Contrast authentication using Azure Active Directory, Windows Active Directory, and SQL Server authentication. Implement various security principals and configure permissions.

Explore encryption options available within Azure SQL, including firewall rules, Always Encrypted, and Transport Layer Security. Understand how SQL Injection works.

Explore data classification capabilities and degrees of confidentiality. Implement security options to maintain private data safe, including Azure SQL auditing, Microsoft Defender for SQL, row-level security, Dynamic Data Masking and Azure SQL Database Ledger.