- Configure database authentication and authorization
After completing this module, you will be able to:
- Learn about authentication options for Azure SQL
- Create various security principals
- Configure permissions within a SQL database
- Identify authentication and authorization failures
- Protect data in-transit and at rest
After completing this module, you will be able to:
- Understand the data encryption options available in the various platforms
- Implement object level encryption
- Understand the difference between database and server firewall rules for Azure SQL Database
- Explore Always Encrypted with secure enclaves
- Implement compliance controls for sensitive data
After completing this module, you will be able to:
- Plan and implement data classification in Azure SQL Database
- Understand and configure row-level security and dynamic data masking
- Understand the usage of Microsoft Defender for SQL
- Explore how Ledger works
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Syllabus
- Configure database authentication and authorization
- Introduction
- Describe authentication and identities
- Describe Security Principals
- Describe database and object permissions
- Identify authentication and authorization failures
- Exercise: Authorize Access to Azure SQL Database with Microsoft Entra ID
- Module assessment
- Summary
- Protect data in-transit and at rest
- Introduction
- Explore Transparent Data Encryption
- Configure server and database firewall rules
- Explain object encryption and secure enclaves
- Enable encrypted connections
- Describe SQL injection
- Understand Azure Key Vault
- Exercise: Configure a server-based firewall rule using the Azure portal
- Module assessment
- Summary
- Implement compliance controls for sensitive data
- Introduction
- Explore data classification
- Explore server and database audit
- Implement Dynamic Data Masking
- Implement Row Level security
- Understand Microsoft Defender for SQL
- Explore Ledger
- Implement Microsoft Purview
- Exercise: Enable Microsoft Defender for SQL and Data Classification
- Module assessment
- Summary