Configure and migrate to Azure Database for PostgreSQL (DP-3021) (M-DP3021)

Explore PostgreSQL architecture

• • Describe the architecture of PostgreSQL.
• • Describe the options for creating an Azure Database for PostgreSQL server.
• • Understand PostgreSQL shared memory.

Understand client-server communication in PostgreSQL

• • Understand connection handling.
• • Understand the PostgreSQL client tools.

Understand PostgreSQL query processing

• • Identify the query processing components.
• • Understand EXPLAIN.

Secure Azure Database for PostgreSQL

• • Describe the security features of Azure Database for PostgreSQL.
• • Create database users and grant permissions.
• • Understand encryption in Azure Database for PostgreSQL.

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 PostrgreSQL.

Understand write-ahead logging

• • Describe write-ahead logging.
• • Describe replication and logical decoding.

Configure and manage Azure Database for PostgreSQL

• • Describe system catalogs and system views in Azure Database for PostgreSQL.
• • Investigate metadata in Azure Database for PostgreSQL.
• • Explain the purpose of the vacuum process.
• • Configure vacuum server parameters.

Understand concurrency in PostgreSQL

• • Describe Multi-Version Content Control and snapshots in Azure Database for PostgreSQL.
• • Describe isolation levels in Azure Database for PostgreSQL.
• • Describe locking in Azure Database for PostgreSQL.

Tune queries in Azure Database for PostgreSQL

• • Describe statistics in Azure Database for PostgreSQL.
• • Assess query performance with the Query Store.

Migrate to Azure Database for PostgreSQL flexible server

• • Understand the different online and offline migration options.
• • Identify the different migration tools available.
• • Select the appropriate migration tool for your specific scenario.