Explore PostgreSQL Architecture
- Overview of Azure Database for PostgreSQL.
- Understand architecture and shared memory.
- Hands-on: Explore PostgreSQL on Azure.
Client-Server Communication
- Connection handling and PostgreSQL client tools.
- Exercise: Utilize PostgreSQL client tools.
Query Processing
- Components of query processing and the EXPLAIN statement.
- Exercise: Analyze queries with EXPLAIN.
Secure Azure Database for PostgreSQL
- Encryption, authentication, and role-based permissions.
- Exercise: Configure database permissions.
Stored Procedures and Functions
- Create reusable stored procedures and functions.
- Exercise: Implement stored procedures in PostgreSQL.
Write-Ahead Logging
- Understand ACID compliance and logical decoding.
- Exercise: List table changes using logical decoding.
Configure and Manage PostgreSQL
- System catalogs, metadata, and autovacuum configuration.
- Exercise: Optimize database configurations.
Concurrency Management
- Multi-version concurrency control (MVCC), isolation levels, and locking.
- Exercise: Explore locking mechanisms.
Query Tuning
- Query performance metrics and the Query Store.
- Exercise: Assess and optimize queries.
Migrate to Azure Database for PostgreSQL
- Compare online vs. offline migration methods.
-Exercises: Perform online and offline migrations.