Microsoft Applied Skills badge
9.00

Fill-starFill-starFill-starFill-starFill-starFill-starFill-starFill-starFill-starunfill-star

21 reviews

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

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

ktk-icon 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
  • intructor-icon Instructor-led training
  • intructor-icon Personal Learning Path
  • intructor-icon Email, chat and phone support

Top companies trust Readynez

Who is this course for?

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.

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

  • Orange-check Knowledge of database administration and SQL.
  • Orange-check Familiarity with cloud platforms, especially Azure.
  • Orange-check 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 excels with a vast expertise in the fields of consulting, training and project management.

Michel excels with a vast expertise in the fields of consulting, training and project management. During his 20 year IT career he has acquired a wide range of skills, both technical and management wise.  He is a keen lover of challenges and keeps up to date with market expectations. Having a multi-cultural approach, he can even train in 5 different languages ​​with ease.

In addition to this, he is very experienced as a hands-on consultant and has worked with various integrations and migrations including Windows migrations, Datacenter consolidations, multiple solution integrations, ITSM implementations. He is also an expert on Cloud environments and in virtualization techniques as well (Operating systems and applications).

 

READ MORE
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 MORE
Read Less

FAQ

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

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.

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.

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.

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

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

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.

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.

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

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.

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

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.

Why Pay More??

Go beyond one certification Achieve Complete Mastery medal-icon

Why settle for just one certification course when you can attend ALL certification courses for the price of less than one single course?

Unlimited Training delegate
  • Orange-check 60+ Courses for the price of less than one
  • Orange-check LIVE Instructor-led courses
  • Orange-check Expert Instructors at your fingertips
  • Orange-check Money-back Guarantee
  • Orange-check Flexible payment options
EXPLORE UNLIMITED TRAINING

A perfect tool to help us develop the skills and competencies we need for success

Its IT Icon Kasper Meyer Christensen


A training solution so good that it pays for itself

50%
MINIMUM SAVINGS

Businesses leveraging Readynez Unlimited save at least 50% on their training and certifications - and many up to 80%

2.4 x
COURSES PER LICENSE

Unlimited license holders attend on average 2.4 courses per year


Get more for less with Unlimited Training

Courses

60+ INSTRUCTOR-LED COURSES

For the price of less than one course.

Quality

SAME HIGH READYNEZ QUALITY

Just cheaper and more flexible.

Flexible

FLEXIBLE PAYMENT OPTIONS

The easiest, most flexible and cheapest way to get Certified.

Unlimited

UNLIMITED ACCESS

Attend as many courses you want - no limitations!

Money Gaurantee

MONEY-BACK GUARANTEE

Refund provided if license costs surpass the value of your training.

Training

LIVE TRAININGS ONLY

Interact 1-on-1 with 50+ seasoned instructors.

Basket

{{item.CourseTitle}}

Price: {{item.ItemPriceExVatFormatted}} {{item.Currency}}