Configure and migrate to Azure Database for PostgreSQL (DP-3021) Virtual Classroom Live September 26, 2025

Course Overview

1 - Explore PostgreSQL architecture

• Describe Azure Database for PostgreSQL
• Understand PostgreSQL architecture
• Understand PostgreSQL shared memory

2 - Understand client-server communication in PostgreSQL

• Understand connection handling
• Understand the PostgreSQL client tools

3 - Understand PostgreSQL query processing

• Identify the query processing components
• Understand the EXPLAIN statement

4 - Secure Azure Database for PostgreSQL

• Describe Azure Database for PostgreSQL security
• Describe built-in Azure Database for PostgreSQL server roles
• Grant permissions in Azure SQL Database for PostgreSQL
• Understand encryption in Azure Database for PostgreSQL

5 - Procedures and functions in PostgreSQL

• Create a stored procedure in Azure Database for PostgreSQL
• Call a stored procedure in Azure Database for PostgreSQL
• Create and use a function in Azure Database for PostgreSQL

6 - Understand write-ahead logging

• Describe write ahead logging
• Describe replication and logical decoding

7 - Configure and manage Azure Database for PostgreSQL

• Understand the system catalogs and system views
• Investigate metadata with system catalogs and system views
• Explain the purpose of vacuum and autovacuum
• Configure autovacuum server parameters

8 - Understand concurrency in PostgreSQL

• Understand multi-version concurrency control (MVCC) and snapshots
• Describe isolation levels
• Understand locking

9 - Tune queries in Azure Database for PostgreSQL

• Understand statistics
• Assess query performance with the Query Store

10 - Migrate to Azure Database for PostgreSQL flexible server

• Compare online and offline migrations
• Identify migration tool options
• Analyze the decision criteria for tool selection and migration model

Prerequisites

• Demonstrate an understanding of relational databases.
• Demonstrate an understanding of basic SQL.