Microsoft Logo

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
| DP-3021: Configure and migrate to Azure Database f

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
Apr 17, 2026 9:00 am - 5:00 pm 1 Day online
$599
May 01, 2026 9:00 am - 5:00 pm 1 Day online
$599
May 15, 2026 9:00 am - 5:00 pm 1 Day online
$599
May 29, 2026 9:00 am - 5:00 pm 1 Day online
$599
+ 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

Please enter Name
Please enter a valid email address.
Please enter a valid phone number in international format (e.g., +14155552671).
Please enter Message
Please agree to I agree to Terms & Privacy Policy*.
Please agree to I authorize Microtek Learning to contact me via Phone/Email*.

📘 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.

Actemium
US Dept of Defense
Education Advisory Board
GE Digital
Department of Homeland Security
Pacific Life
MetLife
AIG
Chase
DC Gov
Johnson & Johnson
William Osler Health System
Google

Our Awards

Microsoft Award

Microsoft Learning
Partner of the Year

Inc 5000

5000 List of the Fastest-Growing Private Companies in America

Top IT Training

Top IT Training Companies
(Multiple Years)

Why We Are Best To Choose?

Team Support

Professional Team Support

Our expert counseling team provides round-the-clock assistance with the best value offers.

Experienced Trainers

Experienced Trainers

Certified trainers with 5–15 years of real-world industry experience guide your learning.

Satisfaction Guarantee

100% Satisfaction Guarantee

We guarantee satisfaction with top-quality content and instructor delivery.

Real-World Experience

Real-World Experience

Train with industry projects and curricula aligned to current standards.

Best Price Guarantee

Best Price Guarantee

We promise the lowest pricing and best offers in the market.

Guaranteed to Run

Guaranteed to Run

All courses are assured to run on scheduled dates via all delivery methods.

Azure Learning Resources

Explore our collection of free resources to boost your Azure learning journey

Blogs

Azure Expert Blogs

Explore insights from industry experts to stay ahead in tech—dive into our Expert Blogs now!

Read Blogs
Talk to Advisor