Roadmap › 3. Cloud & DevOps › Step 39
AzDB
Azure Databases — Azure SQL, Managed Instance, Cosmos DB, PostgreSQL and Migration
Choosing a database on Azure; Azure SQL Database (single database, elastic pools, DTU vs vCore, General Purpose / Business Critical / Hyperscale, serverless), Azure SQL Managed Instance and SQL Server on Azure VMs; security (firewall, private endpoints, Microsoft Entra authentication, managed identity, TDE, Always Encrypted, auditing), high availability, geo-replication, failover groups and backups/point-in-time restore; performance (Query Store, automatic tuning, Intelligent Insights); Cosmos DB (APIs, partition keys, RU/s, consistency levels), Azure Database for PostgreSQL/MySQL, Azure Cache for Redis; migrating on-premises SQL Server (DMA, Azure Database Migration Service) and cost optimisation.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: Azure SQL
- 1.Azure SQL Database, Managed Instance and SQL on VM — choosingBasic ★ Must know
- 2.Purchasing models and service tiers — DTU, vCore, serverless, Hyperscale, elastic poolsIntermediate ★ Must know
- 3.Security — networking, Entra authentication, managed identity, encryption, auditingIntermediate ★ Must know
- 4.High availability, geo-replication, failover groups and backupsIntermediate ★ Must know
- 5.Performance monitoring and tuning in Azure SQLIntermediate Medium
Module 2: Other Azure Data Services
- 6.Azure Cosmos DB — APIs, partitioning, RU/s and consistencyIntermediate ★ Must know
- 7.Azure Database for PostgreSQL/MySQL, Azure Cache for Redis and choosing storageIntermediate Medium
Module 3: Migration and Cost
- 8.Migrating on-premises SQL Server to AzureAdvanced ★ Must know
- 9.Cost optimisation for Azure databasesIntermediate Medium
Next course in the roadmap: 40. Amazon Web Services (AWS) for .NET and Full Stack Developers →