Secure, optimize, and deploy database solutions

  • Learning Path
  • 4 Modules

At a glance

Take your database solutions from development to production. You learn to protect sensitive data with encryption, masking, and row-level security. You tune query performance using execution plans, Query Store, and dynamic management views. You automate deployments with CI/CD pipelines using SQL Database Projects. Finally, you expose your databases through REST and GraphQL APIs with Data API Builder.

Prerequisites

Before starting this learning path, you should have:

  • Experience writing T-SQL queries.
  • Familiarity with SQL Server or Azure SQL Database.
  • Basic understanding of security concepts like authentication and authorization.
  • Experience with Git version control and CI/CD concepts.

Modules in this learning path

Implement data security and compliance with SQL

Learn how to protect sensitive data and meet compliance requirements by implementing encryption, masking, access controls, and auditing across Microsoft's SQL platforms.

Optimize database performance

Optimize Azure SQL Database performance by choosing the right service tier and managing concurrency with transaction isolation levels. Analyze queries with execution plans and DMVs. Use Query Store for plan management and diagnose blocking and deadlocks.

Implement CI/CD by using SQL Database Projects

Implement CI/CD for SQL Database Projects with source control, branching, schema drift detection, automated pipelines, and testing strategies using GitHub Actions and Azure DevOps.

Integrate SQL solutions with Azure services

Create REST and GraphQL APIs for SQL databases using Data API Builder, deploy to Azure hosting services, and implement monitoring and event-driven change patterns.

Start