21 reviews

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

Item: configure-and-migrate-to-azure-database-for-postgresql-dp-3021-course
Rating: 10
Author: Stephen Ridgway

The "Configure and Migrate to Azure Database for PostgreSQL (DP-3021)" course equips database administrators with essential skills to migrate and manage databases in Azure PostgreSQL. The course covers configuration, migration strategies, and performance optimization for cloud-based databases.

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

Duration: 1 day

Format: Virtual or Classroom

Attend this and 60+ other Microsoft courses for FREE with Unlimited Microsoft Training

Overview

The DP-3021 course focuses on configuring and migrating databases to Azure Database for PostgreSQL. Participants will learn to assess on-premises databases, plan migration strategies, configure Azure PostgreSQL settings, and optimize performance for cloud environments. This course is ideal for database administrators and cloud engineers looking to enhance their skills in cloud-based database management. Through hands-on labs, participants will gain practical experience in ensuring secure and scalable database migration.

This course includes

Instructor-led training
Personal Learning Path
Email, chat and phone support

Who is the Configure and migrate to Azure Database for PostgreSQL (DP-3021) course for?

The "Configure and Migrate to Azure Database for PostgreSQL (DP-3021)" course is designed for database administrators, cloud engineers, and IT professionals who are responsible for managing databases and migrating them to the cloud. It is also ideal for data engineers looking to gain expertise in configuring, migrating, and optimizing PostgreSQL databases within the Azure environment. This course suits anyone aiming to enhance their skills in cloud-based database solutions, ensuring secure and scalable database management in Azure.

Curriculum

What you will learn during our Configure and migrate to Azure Database for PostgreSQL (DP-3021) course.

Explore PostgreSQL architecture

PostgreSQL is an opensource relational database system that is available as an Azure service. In this module, you learn about the PostgreSQL architecture, and how to manage different aspects of Azure Database for PostgreSQL.
Introduction
Describe Azure Database for PostgreSQL
Understand PostgreSQL architecture
Understand PostgreSQL shared memory
Exercise – Explore Azure Database for PostgreSQL
Knowledge check
Summary

Understand client-server communication in PostgreSQL

PostgreSQL is a clientserver system, which allows many clients to connect to a central server. In this module, you learn how PostgreSQL manages connections from clients, and look at some common PostgreSQL client tools.
Introduction
Understand connection handling
Understand the PostgreSQL client tools
Exercise Explore PostgreSQL with client tools
Knowledge check
Summary

Understand PostgreSQL query processing

The Azure Database for PostgreSQL server receives SQL queries and returns the relevant results. Each SQL query goes through several stages in order to return the correct results as quickly as possible.
Introduction
Identify the query processing components
Understand the EXPLAIN statement
Exercise Execute the EXPLAIN statement
Knowledge check
Summary

Secure Azure Database for PostgreSQL

Azure Database for PostgreSQL includes comprehensive security features including encryption, authentication, and granting permissions to database users. In this module, you learn about the security features of Azure Database for PostgreSQL.
Introduction
Describe Azure Database for PostgreSQL security
Describe builtin Azure Database for PostgreSQL server roles
Grant permissions in Azure SQL Database for PostgreSQL
Understand encryption in Azure Database for PostgreSQL
Exercise: Configure permissions in Azure Database for PostgreSQL
Knowledge check
Summary

Procedures and functions in PostgreSQL

PostgreSQL supports stored procedures and functions to make SQL queries reusable. In this module, you learn how to create and run stored procedures and functions.
Introduction
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 PostgreSQL
Exercise Create a stored procedure in Azure Database for PostgreSQL
Knowledge check
Summary

Understand write-ahead logging

Azure Database for PostgreSQL is an ACID compliant database service. Writeahead logging ensures changes are both atomic and durable. In this module, you learn how Azure Database for PostgreSQL implements writeahead logging.
Introduction
Describe write ahead logging
Describe replication and logical decoding
Exercise List table changes with logical decoding
Knowledge check
Summary

Configure and manage Azure Database for PostgreSQL

Azure Database for PostgreSQL employs system catalogs and views to manage metadata efficiently. Understanding these can significantly enhance database performance and streamline the administration of PostgreSQL systems.
Introduction
Understand the system catalogs and system views
Investigate metadata with system catalogs and system views
Explain the purpose of vacuum and autovacuum
Configure autovacuum server parameters
Exercise Configure system parameters and explore metadata with system catalogs and views
Knowledge check
Summary

Understand concurrency in PostgreSQL

Azure Database for PostgreSQL is a multiuser relational database solution. The increase in users brings a risk of conflicts and so it is important to understand the concurrency systems that are in place.
Introduction
Understand multiversion concurrency control (MVCC) and snapshots
Describe isolation levels
Understand locking
Exercise Understand locking
Knowledge check
Summary

Tune queries in Azure Database for PostgreSQL

Database management systems (DBMSs) need systems to understand the data and the queries that are running against this data. It's important to understand how performance tuning works and how you can assess performance metrics.
Introduction
Understand statistics
Assess query performance with the Query Store
Exercise Assess query performance using Query Store
Knowledge check
Summary

Migrate to Azure Database for PostgreSQL flexible server

Azure Database for PostgreSQL Flexible Server supports data migration from PostgreSQL servers. This module covers online and offline migration tools and methods, helping you choose the right approach for your scenario.
Introduction
Compare online and offline migrations
Identify migration tool options
Analyze the decision criteria for tool selection and migration model
Exercise – Offline PostgreSQL database migration
Exercise – Online PostgreSQL database migration
Knowledge check
Summary

Preparation

How to best be prepared for our Configure and migrate to Azure Database for PostgreSQL (DP-3021) course.

At Readynez, we provide many resources and have experienced experts in the field. That is why we are also very successful with many satisfied customers. You can therefore safely take your course with us.

In order to take the Configure and migrate to Azure Database for PostgreSQL (DP-3021) course, however, some prerequisites are required:

Knowledge of database administration and SQL.
Familiarity with cloud platforms, especially Azure.
Experience with PostgreSQL databases is recommended.

Meet our instructors

Meet some of the Readynez Instructors you can meet on your course. They are experts, passionate about what they do, and dedicated to give back to their industry, their field, and those who want to learn, explore, and advance in their careers.

Michel Aguilera

Michel Aguilera delivers high-impact, LIVE instructor-led training in Microsoft Cloud, infrastructure and cybersecurity for professionals seeking real-world skills and certification readiness. With 20+ years of global experience and deep technical expertise, he helps teams master modern IT environments - from hybrid cloud to secure digital workplaces - with clarity and practical guidance.

Meet the Instructor: Michel Aguilera

When it comes to real-world experience in cloud, cybersecurity, and infrastructure, Michel Aguilera brings the full package.

With over 20 years in IT, Michel has worn many hats: consultant, trainer, project manager, and integration expert. Whether it’s large-scale Windows migrations, Datacenter consolidations, ITSM rollouts, cloud implementations, and cybersecurity solutions, he brings clarity, structure, and deep technical expertise to the table.

Michel is not only a Microsoft and cybersecurity specialist, but also fluent in five languages, making him a sought-after instructor across borders and industries.
His multicultural perspective and agile approach help organizations navigate everything from hybrid infrastructures to the adoption of AI tools like Microsoft Copilot and ChatGPT.

As a passionate trainer and consultant, he empowers professionals to implement resilient, secure, and scalable IT environments, keeping pace with the ever-evolving tech landscape.

With Michel, you can expect a training experience that is structured, practical, multilingual if needed, and deeply insightful.

Find your next Readynez courses with Michel here.

Read Less

Julian Sharp

Julian Sharp delivers high-quality, LIVE instructor-led training in Microsoft Dynamics 365 and Power Platform for professionals seeking real-world skills and certification readiness. With decades of industry experience and deep technical expertise, he helps learners master complex solutions efficiently.

Meet the Instructor: Julian Sharp
MCT | MVP | Solution Architect | Dynamics 365 & Power Platform Expert

With 20+ years of experience and over 16 years specializing in Dynamics CRM/365 and Power Platform, Julian has trained thousands of professionals and helped organizations solve real business challenges using Microsoft technologies.

A Microsoft Certified Trainer since 2007 and a Microsoft MVP, Julian brings a rare combination of deep technical knowledge and a practical, business-first mindset.

He’s not just an instructor - he’s a community leader, consultant, and solution architect trusted by enterprises across the globe.

Microsoft MVP – Business Applications 
Specialist in Dynamics 365, Power Platform & Azure 
Developer of Microsoft courseware
Speaker & mentor at Microsoft community events

Ready to build solutions with one of the best in the field?

Explore upcoming courses with Julian Sharp to get started.

Read Less

FAQ

FAQs for the Configure and migrate to Azure Database for PostgreSQL (DP-3021) course.

What is the Configure and Migrate to Azure Database for PostgreSQL (DP-3021) course for?

The DP-3021 course is designed for database administrators and cloud engineers who want to migrate databases to Azure Database for PostgreSQL. It covers configuration, migration planning, and performance optimization in cloud-based environments.

How do I prepare for the DP-3021 course?

To prepare, participants should have basic knowledge of SQL, experience with database administration, and familiarity with cloud platforms like Azure. Understanding PostgreSQL database concepts will also enhance the learning experience.

What are the prerequisites for the DP-3021 course?

Prerequisites include knowledge of database administration, experience with SQL, and familiarity with cloud platforms such as Azure. Prior experience with PostgreSQL databases is also recommended.

How much does the DP-3021 course cost?

The course costs €705, providing live sessions, hands-on labs, and course materials focused on migrating and configuring databases in Azure Database for PostgreSQL.

What topics are covered in the DP-3021 course?

Topics include assessing on-premises databases, planning migration strategies, configuring Azure PostgreSQL settings, performance tuning, and security measures for cloud-based databases.

Is completing the DP-3021 course worth it for my career?

Yes, completing this course enhances your database management and cloud migration skills, making you more qualified for roles like cloud database administrator or migration specialist.

What credential does the DP-3021 course provide?

While this course doesn’t offer a formal certification, it provides hands-on skills in configuring and migrating databases to Azure Database for PostgreSQL, boosting your qualifications for cloud database roles.

Can I take the DP-3021 course online?

Yes, the DP-3021 course is available online, offering live interactive sessions, practical labs, and flexible learning options suitable for busy professionals.

How easy or difficult is the DP-3021 course?

The course is moderately challenging, especially for those unfamiliar with PostgreSQL databases. It’s designed to guide participants step-by-step, making it manageable for learners with some database experience.

How much salary can I get after completing the DP-3021 course?

Completing this course can qualify you for roles like cloud database administrator or migration specialist, with salaries ranging from €65,000 to €125,000 annually, depending on experience and location.

Reviews

Feedback from our delegates.

Johan Andersson

Easy to attend over Teams and an excellent instructor gave me great value for the time I invested.

Stephen Ridgway

Readynez is the best training provider I've used for many years. Their customer service is first class, prices are very competitive and instruction excellent.