DP-3021: Configure and migrate to Azure Database for PostgreSQL

Course Description:

Unlock the full potential of open-source relational databases in the cloud with Azure Database for PostgreSQL. This instructor-led course guides you through configuring, securing, and migrating workloads to Azure's managed PostgreSQL database service, helping you modernize your data estate with minimal disruption.

From sizing and provisioning the right deployment model to configuring security and performance optimization, this course covers the essential steps for a successful PostgreSQL migration to Azure. Whether you're working with PostgreSQL on-premises or in another cloud environment, you'll gain the confidence to plan, execute, and optimize your migration using Microsoft-recommended tools and best practices.

This course includes 40% to 50% hands-on content, allowing you to apply key skills in real-world scenarios.

Target Audience:

This course is ideal for:

• Database administrators planning or performing migrations to Azure Database for PostgreSQL

• Cloud solution architects responsible for designing scalable, secure, and cost-effective PostgreSQL workloads on Azure

• Data engineers and DevOps professionals supporting open-source data platform modernization

• IT professionals preparing for Microsoft certifications in cloud data services (e.g., DP-300)

Prerequisites: Basic knowledge of relational databases, PostgreSQL, and familiarity with core Azure services.

Course Outline:

Module 1: Introduction to Azure Database for PostgreSQL

• Explore the benefits of a managed PostgreSQL service on Azure

• Compare Single Server, Flexible Server, and Hyperscale (Citus) deployment models

• Evaluate use cases for each model based on workload requirements

Module 2: Plan and Configure Azure Database for PostgreSQL Deployments

• Provision and configure PostgreSQL servers using Azure Portal, CLI, and ARM templates

• Set up networking, VNet integration, and private endpoints for secure access

• Implement scaling strategies, storage sizing, and high availability

Module 3: Secure and Monitor PostgreSQL in Azure

• Apply role-based access control (RBAC), firewalls, and SSL enforcement

• Integrate Azure Active Directory authentication

• Monitor performance and usage with Azure Monitor, Query Performance Insight, and Alerts

Module 4: Plan and Execute PostgreSQL Migration to Azure

• Assess source environments using Azure Database Migration Guide

• Choose migration strategies: offline, online, or replication-based

• Use Azure Database Migration Service (DMS) and pg_dump/pg_restore tools for effective transitions

Module 5: Optimize Performance and Cost in Azure PostgreSQL

• Tune queries and indexes using pg_stat_statements and other PostgreSQL tools

• Configure automatic vacuuming, connection pooling, and caching

• Optimize infrastructure costs using scaling policies, reserved instances, and performance tiers

Module 6: Ensure High Availability and Business Continuity

• Configure backup retention, point-in-time restore, and read replicas

• Design for disaster recovery and failover with Azure PostgreSQL Flexible Server

• Implement redundant architectures across zones and regions

Module 7: Automate Operations and DevOps Integration

• Automate provisioning and updates using Terraform, Ansible, and Bicep

• Integrate PostgreSQL deployments into CI/CD pipelines with GitHub Actions and Azure DevOps

• Use alerts and logging to enable proactive operations and compliance tracking

Delivery Format:

• Live instructor-led sessions

• 40%–50% hands-on activities in a real Azure environment

• Course includes guided exercises, demonstrations, and real-world configuration examples