Disclaimer: This course is independently developed and not affiliated with Microsoft. It covers concepts and skills that closely align with the objectives of Microsoft’s DP-3021: Configure and migrate to Azure Database for PostgreSQL training, making it a strong preparatory or complementary learning experience.
Modernizing PostgreSQL Workloads: Configuring and Migrating to Azure Database for PostgreSQL
This intermediate-level custom training equips learners to configure and migrate PostgreSQL workloads to Azure Database for PostgreSQL. Participants will understand PostgreSQL architecture, query processing, and client-server communication; configure and secure Azure Database for PostgreSQL; migrate on-premises databases to Azure; and optimize performance while setting up high availability and disaster recovery.
Before enrolling in this training, it is ideal for participants to be database administrators or engineers with PostgreSQL experience and familiarity with Azure networking and identity management.
Module Breakdown:
Explore PostgreSQL Architecture: Understand the core components and structure of PostgreSQL.
Understand Client-Server Communication in PostgreSQL: Learn how PostgreSQL handles connections and data exchange.
Understand PostgreSQL Query Processing: Dive into how queries are parsed, planned, and executed.
Secure Azure Database for PostgreSQL: Configure authentication, encryption, and network security.
Procedures and Functions in PostgreSQL: Implement stored procedures and user-defined functions.
Understand Write-Ahead Logging: Explore WAL for durability and crash recovery.
Configure and Manage Azure Database for PostgreSQL: Set up, monitor, and optimize Azure-hosted PostgreSQL instances. This module also includes migration steps from on-premises PostgreSQL to Azure.