Outline updated November 2026

Foundation21 hours delivered over 3-5 daysLive, online or on-site

Request this course

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_dump and pg_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

Private team training

Bring this course to your team

Tell us about your team and we will tailor this outline to your tools, stack, and schedule. Courses can also be combined into a longer program.

  1. Tell us what you needYour tools, stack, team size, and timeline.
  2. We send a proposalA course or program, an outline adjusted to your team, and possible dates.
  3. Your team trains liveOnline or on-site, with courseware for every student.

Prefer to talk? Call +1 434-509-6890 or email help@cloudcontraptions.com.

We reply within 1 business day.

Training partner?