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

DP-3021 is about moving PostgreSQL databases to Azure and managing them once they're there. Database migrations are tricky. You need to understand PostgreSQL architecture, plan your approach, and make sure nothing breaks along the way. This course walks through all of that step by step.

📘 Azure 👥 149 Enrolled ⏱️ 1 Day 💼 Intermediate Level ⭐ 5 | 99 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$599

Course Overview

DP-3021: Configure and migrate to Azure Database for PostgreSQL Training covers PostgreSQL architecture and how to configure and manage PostgreSQL databases on Azure. You'll learn security setup, query tuning, and migration strategies using online and offline tools. The labs put you through actual migration and configuration tasks, the same kind of work you'd face if someone told you to move a production database to Azure by next quarter.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

Upcoming Schedules

Start Date	Time	Duration	Mode	Price
Apr 03, 2026	9:00 am - 5:00 pm	1 Day	online	$599	GTR
Apr 17, 2026	9:00 am - 5:00 pm	1 Day	online	$599	GTR
May 01, 2026	9:00 am - 5:00 pm	1 Day	online	$599	GTR
May 15, 2026	9:00 am - 5:00 pm	1 Day	online	$599	GTR
May 29, 2026	9:00 am - 5:00 pm	1 Day	online	$599	GTR
Jun 12, 2026	9:00 am - 5:00 pm	1 Day	online	$599	GTR
Jun 26, 2026	9:00 am - 5:00 pm	1 Day	online	$599	GTR

+ View more schedules

What you will learn

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

Who Should Attend This Course?

Database Administrator

Prerequisites

Demonstrate an understanding of relational databases.
Demonstrate an understanding of basic SQL.

📞 Talk to a Learning Advisor

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

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

Understand connection handling.
Understand the PostgreSQL client tools.
Lab: Explore PostgreSQL with client tools

Identify the query processing components.
Understand EXPLAIN.
Lab: Execute the EXPLAIN statement

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

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

Describe write-ahead logging.
Describe replication and logical decoding.
Lab: List table changes with logical decoding

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

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

Describe statistics in Azure Database for PostgreSQL.
Assess query performance with the Query Store.
Lab: Assess query performance using Query Store

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

Still have questions?

Reach out to our learning advisors for personalized guidance on choosing the right course, group training, or enterprise packages.

📞 Talk to an Advisor

What You Get with Microtek Learning

Instructor-Led Excellence

✓ Certified Instructor-led Training
✓ Top Industry Trainers
✓ Official Student Handbooks

Measurable Learning Outcomes

✓ Pre- & Post-Training Assessments
✓ Practice Tests
✓ Exam-Oriented Curriculum

Real-World Skill Building

✓ Hands-on Activities & Scenarios
✓ Interactive Online Courses
✓ Peer Collaboration (Not in self-paced)

Full Support & Perks

✓ Exam Scheduling Support ^*
✓ Learn & Earn Program ^*
✓ Support from Certified Experts
✓ Gov. & Private Pricing ^*

Our Clients

For over 10 years, Microtek Learning has helped organizations, leaders, students and professionals to reach their maximum potential. We have led the path by addressing their challenges and advancing their performances.