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

The DP-3021: Configure and Migrate to Azure Database for PostgreSQL course provides essential training in PostgreSQL architecture and the practical steps for configuring and managing PostgreSQL databases in Azure. Participants will explore security features, query tuning, and migration strategies using online and offline tools. Hands-on labs ensure learners gain practical experience in managing, configuring, and migrating databases. This Azure DP-3021 training prepares professionals to tackle real-world database migration and management scenarios effectively.

Retail Price: $675.00

Next Date: Request Date

Course Days: 1


Request a Date

Request Custom Course


Course Objectives
• Explore PostgreSQL architecture
• Understand client-server communication in PostgreSQL
• Understand PostgreSQL query processing
• Secure Azure Database for PostgreSQL
• Procedures and functions in PostgreSQL
• Understand write-ahead logging
• Configure and manage Azure Database for PostgreSQL
• Understand concurrency in PostgreSQL
• Tune queries in Azure Database for PostgreSQL
• Migrate to Azure Database for PostgreSQL flexible server

Target Audience
• Database Administrator

Prerequisites Required:
• Demonstrate an understanding of relational databases.
• Demonstrate an understanding of basic SQL. 


Course Outline

1) Explore PostgreSQL architecture
• Describe the architecture of PostgreSQL
• Describe the options for creating an Azure Database for PostgreSQL server
• Understand PostgreSQL shared memory
• Lab: Explore Azure Database for PostgreSQL

2) Understand clientserver communication in PostgreSQL
• Understand connection handling
• Understand the PostgreSQL client tools
• Lab: Explore PostgreSQL with client tools

3) Understand PostgreSQL query processing
• Identify the query processing components
• Understand EXPLAIN
• Lab: Execute the EXPLAIN statement

4) 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
• Lab: Configure permissions in Azure Database for PostgreSQL

5) 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
• Lab: Create a stored procedure in Azure Database for PostgreSQL

6) Understand writeahead logging
• Describe write-ahead logging
• Describe replication and logical decoding
• Lab: List table changes with logical decoding

7) 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
• Lab: Configure system parameters and explore metadata with system catalogs and views

8) 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
• Lab: Understand locking

9) Tune queries in Azure Database for PostgreSQL
• Describe statistics in Azure Database for PostgreSQL
• Assess query performance with the Query Store
• Lab: Assess query performance using Query Store

10) 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
• Lab: Offline PostgreSQL database migration
• Lab: Online PostgreSQL database migration



Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com


Request a Date