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.
