Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Implement a secure environment for a database service

Microsoft via Microsoft Learn

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • 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

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

Reviews

Start your review of Implement a secure environment for a database service

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.