- 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
Finance Certifications Goldman Sachs & Amazon Teams Trust
Google, IBM & Meta Certificates — 40% Off for a Limited Time
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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