Securing, Monitoring and Optimizing Azure SQL

Authentication, encryption, auditing, performance monitoring and query tuning for Azure SQL, shared by DP-300 and DP-800.

MSAZ-281 12 lessons planned ▶ Video lessons coming soon

Offered by HSM University · Microsoft Certification Prep

Course content

  1. 1Microsoft Entra authentication for databasesComing
  2. 2Logins, users and permissionsComing
  3. 3Encryption at rest and in transitComing
  4. 4Always EncryptedComing
  5. 5Dynamic data masking and row-level securityComing
  6. 6Auditing and Defender for SQLComing
  7. 7Monitoring with Database Watcher and Query StoreComing
  8. 8Dynamic management viewsComing
  9. 9Index design and maintenanceComing
  10. 10Query plans and tuningComing
  11. 11Automatic tuningComing
  12. 12Resource governanceComing

Requirements

Recommended background. You can start any course at any time.

Description

Authentication, encryption, auditing, performance monitoring and query tuning for Azure SQL, shared by DP-300 and DP-800.