After this day you can run PostgreSQL as a managed service on Azure. You understand how Azure Database for PostgreSQL handles connections, queries, write-ahead logging and concurrent access, configure the server and manage encryption, sign-in and permissions. You tune queries and migrate existing databases online or offline to Flexible Server. The course suits database administrators who already look after PostgreSQL on premises or in another cloud and are preparing the move to Azure.
What you’ll take away.
- Understand the architecture and deployment options of Azure Database for PostgreSQL
- Configure servers and read metadata from system catalogs and views
- Set up encryption, authentication and user permissions
- Understand queries and concurrency and improve performance in a targeted way
- Migrate databases online or offline to Flexible Server
Your training in detail
- Who is it for?
- Database administrators who run PostgreSQL databases as a managed service on Azure or are moving them there.
- Prerequisites
- You understand relational databases and can write basic SQL queries. Experience with PostgreSQL and Azure networking makes it easier.
- Format & planning
- Standard length: 1 training day. A different length can be arranged for companies.
Agenda: from understanding to application
Our independently developed agenda proposal. Focus areas, lab environment and scope are agreed before booking.
PostgreSQL architecture and client-server communication in Azure
Query processing, procedures and functions
Security: encryption, authentication and permissions
Write-ahead logging and concurrency
Configuration and management using system catalogs and views
Tuning queries in Azure Database for PostgreSQL
Migrating to Flexible Server: online and offline methods
You set up a Flexible Server with restricted network access and dedicated roles, migrate a sample database to it and then analyse a slow query.
Exams, licences & credentials
The course prepares you for much of the Microsoft Applied Skills assessment "Configure and migrate to Azure Database for PostgreSQL". The assessment also tests high availability, replication and disaster recovery, which you should practise separately. The assessment and any fees are only included if the offer confirms this. The credential is issued by Microsoft. It is not an official Microsoft course unless the offer explicitly says so.
Vendor references & review date
Sources checked on 2026-11-10. These sources describe the technology or external exam requirements. They do not imply a partnership with NextNowa.
Your learning content
These objectives describe the training topic. The specific syllabus, dates and trainer are agreed before booking; the written offer is binding.
Frequently asked questions
How does this differ from a general PostgreSQL course?
The course looks at PostgreSQL in the context of the managed Azure service: server configuration, Azure security features and migration to Flexible Server are the focus.
Can I migrate from other clouds as well?
Microsoft documents migration routes from on-premises installations, Azure VMs and other cloud services. In the course you learn the online and offline methods available for these routes.
Does DP-3021 Configure and migrate to Azure Database for PostgreSQL: setting up Flexible Server include a certificate?
The course prepares you for much of the Microsoft Applied Skills assessment "Configure and migrate to Azure Database for PostgreSQL". The assessment also tests high availability, replication and disaster recovery, which you should practise separately. The assessment and any fees are only included if the offer confirms this. The credential is issued by Microsoft. It is not an official Microsoft course unless the offer explicitly says so.