Outline updated November 2026
Azure PostgreSQL Flexible Server
Class Duration
21 hours of live training delivered over 3-5 days to accommodate your scheduling needs
Student Prerequisites
- No prior experience with PostgreSQL is necessary
- Students should have a basic understanding of SQL and relational databases
Target Audience
Software engineers, DBAs, data engineers, SREs, and cloud architects who are new to PostgreSQL or to Azure and will deploy and run it in production. For self-managed engine internals, pair this with PostgreSQL for Administrators. Teams on AWS can compare Amazon RDS for PostgreSQL.
Description
This course teaches Azure Database for PostgreSQL flexible server, Microsoft's managed PostgreSQL service. It is for developers, DBAs, and architects who build or run databases on Azure. Students create servers with the portal and the Azure CLI, configure high availability, and secure access with Microsoft Entra ID. They tune queries with Query Store and index tuning, monitor with Azure Monitor, and plan backups and read replicas. Final modules cover elastic clusters, the migration service, and how flexible server compares with Azure HorizonDB, which is in public preview.
Learning Outcomes
- Explain PostgreSQL architecture and where it fits among database types.
- Plan Azure subscriptions, regions, availability zones, and cost controls.
- Provision flexible servers with the Azure portal and the Azure CLI.
- Secure servers with Microsoft Entra ID, PostgreSQL roles, and private networking.
- Administer server parameters, extensions, and major version upgrades.
- Back up and restore databases with automated, on-demand, and long-term backups.
- Scale with read replicas, virtual endpoints, and elastic clusters.
- Tune queries with EXPLAIN, Query Store, and index tuning.
- Monitor servers with Azure Monitor, Log Analytics, and Grafana.
- Migrate databases to flexible server with the migration service.
Training Materials
All students receive comprehensive courseware covering all topics in the course. Courseware is distributed via GitHub in the form of documentation and extensive code samples. Students practice the topics covered through challenging hands-on lab exercises.
Software Requirements
Students will need a free, personal GitHub account to access the courseware. Students are provided a cloud-based environment for all demonstrations and lab exercises. The course is taught on PostgreSQL 18 on Azure Database for PostgreSQL flexible server, with notes for servers on earlier major versions.
Training Topics
Relational Databases
- Database management systems
- Relational database management systems
- NoSQL and other database types
- The SQL language
PostgreSQL
- Overview
- PostgreSQL history
- Single Server retirement and flexible server
- Use cases
- Architecture
- On-premises options
- Cloud options
Azure
- Overview
- Subscriptions
- Managing costs
- Regions
- Availability zones
- Resource groups
- Cloud Shell
- Azure CLI
- Log Analytics workspace
- Microsoft Fabric
- Azure Database for PostgreSQL flexible server
PostgreSQL Flexible Server
- Creating a server in the portal
- Creating a server with the Azure CLI
- Region and availability zone
- Server version and support policy
- Workload type
- Compute tier and size
- Storage type and size
- Performance tier
- High availability
- Authentication
- Firewall rules
- Exploring the portal
- Resource locks
- Activity log
- Tags
Manage Database Server
- Deleting a server
- Stopping and starting a server
- Resetting the password
- In-place major version upgrades
- Public access and private networking
- Server parameters
- Static parameters
- Dynamic parameters
- Read-only parameters
- Extensions
- pgvector and DiskANN for vector search
Connect
- VS Code PostgreSQL extension
- psql in Cloud Shell
- psql locally
- pgAdmin
- DBeaver
- Built-in PgBouncer connection pooling
Databases
- Create and drop with the portal
- Create and drop with psql
- Create and drop with pgAdmin
- Create and drop with DBeaver
Security
- User authentication methods
- Microsoft Entra ID authentication
- Managed identities for applications
- PostgreSQL roles
- Managing roles with SQL
- Granting and revoking privileges
- Encryption at rest
- Customer-managed keys
- Encryption in transit with TLS
- Private endpoints and virtual network integration
- Microsoft Defender for Cloud
Backup and Restore
- Backups and compute tier
- Backups and region or zone
- Geo-redundant backups
- Automated backups
- On-demand backups
- Long-term retention with Azure Backup
- Point-in-time restore
pg_dumpandpg_restore
Scaling Resources
- Scaling options
- Scaling compute
- Scaling storage
- Vertical scaling
- Horizontal scaling
- Near-zero downtime scaling
Replication and High Availability
- Replication overview
- Virtual endpoints
- Same-region and cross-region read replicas
- High availability
- Same-zone
- Zone-redundant
- Automatic failover
- Elastic clusters for horizontal scale-out
- Nodes and distributed tables
Performance Tuning
- Optimizing queries with EXPLAIN
- Query Store
- Query Performance Insight
- Index tuning
Observability and Diagnostics
- Resource Visualizer
- Advisor recommendations
- Alerts
- Metrics
- Diagnostic settings
- Streaming logs
- Server logs
- Power BI
- Azure Monitor
- Azure Log Analytics
- Azure dashboards
- Grafana integration
- Mirroring to Microsoft Fabric
Migration
- The Azure Database for PostgreSQL migration service
- From on-premises servers
- From Azure virtual machines
- From Amazon RDS for PostgreSQL
- From Amazon Aurora PostgreSQL
- From Google Cloud SQL for PostgreSQL
- From PostgreSQL on EC2 or Compute Engine
- Validate and migrate options
- Offline and online modes
- Runtime server and Azure networking
Choosing a Managed PostgreSQL Platform on Azure
- Flexible server vs. elastic clusters
- Azure HorizonDB architecture
- HorizonDB use cases
- Choosing a platform