1. Relational #
Managed SQL Server, PostgreSQL, MySQL.
Choosing #
| Service | For |
|---|---|
| Azure SQL Database | Modern applications, serverless or provisioned, elastic |
| Azure SQL Managed Instance | Migrating SQL Server with near-complete compatibility |
| Database for PostgreSQL / MySQL (flexible) | Managed open source engines, zone-redundant HA |
Commands #
az postgres flexible-server create -g rg-data -n pg-app-123 --tier GeneralPurpose --sku-name Standard_D2ds_v5 \
--high-availability ZoneRedundant --version 16 --public-access None
az sql db create -g rg-data -s sql-app-123 -n app --compute-model Serverless --edition GeneralPurpose --family Gen5 --capacity 22. Cosmos DB #
Global NoSQL.
Principles #
Cosmos DB is a globally distributed NoSQL database (NoSQL, MongoDB, Cassandra, Gremlin, Table APIs), with multi-region replication and multi-region writes. Throughput is provisioned in request units (RU/s) or serverless; the partition key determines scalability.
3. Cache and best practices #
Speeding up and protecting.
Rules #
- Azure Cache for Redis (or Azure Managed Redis) for sessions and load reduction.
- Connect with a managed identity and Entra ID rather than passwords.
- Private Endpoint, TDE encryption, automatic backups and point-in-time restore.
- Choose the Cosmos DB partition key based on the most frequent queries.
Good practice: The Cosmos DB emulator (Docker image) lets you develop locally; it is used in the optional hands-on labs.
My progress
Sign in to track your progress and take notes. Sign in
💬 Questions about this lesson
No questions yet: be the first to ask for help or share your configuration.
Recommended Articles
Azure storage: storage accounts, Blob, Files, disks and redundancy
Store data on Azure: storage accounts, Blob (hot, cool, archive tiers, lifecycle), Files, Queue a...
Microsoft Entra ID, RBAC and Azure Policy: identities, permissions and governance
Manage identities and access on Azure: Microsoft Entra ID (users, groups, MFA, conditional access...
Azure best practices: landing zone, security, reliability and costs
Best practices for running Azure in production: landing zone and management groups, identities an...
Preparing for the Microsoft Azure Fundamentals certification (AZ-900)
Preparation guide for the AZ-900: format, the three domains and their weightings, notions to mast...
Preparing for the Azure Administrator Associate certification (AZ-104)
Preparation guide for the AZ-104: format, the five domains (identities and governance, storage, c...
Compute on Azure: virtual machines, App Service, Functions and containers
Choose and use Azure compute: virtual machines and scale sets (VMSS), App Service, Azure Function...
Understanding Azure: regions, resource hierarchy, tools and pricing
Microsoft Azure basics: geographies, regions, region pairs and availability zones, the hierarchy ...
Azure networking: VNet, NSG, peering, load balancing and hybrid connectivity
Design networking on Azure: virtual networks and subnets, network security groups (NSG), peering ...
Monitoring and protecting Azure: Monitor, Log Analytics, Defender, Key Vault and Backup
Operate Azure: Azure Monitor (metrics, activity logs, alerts), Log Analytics and KQL, Application...