DP-3021: Configure and migrate to Azure Database for PostgreSQL
Overview
In this course, you will learn the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You will learn about the different Azure Database for PostgreSQL implementation options, and how to configure a server for your needs.
Who should attend
This course is for PostgreSQL developers and administrators migrating to Azure Database for PostgreSQL.
Prerequisites
Before attending this course, students should have:
- An understanding of relational databases
- An understanding of basic SQL
What you'll learn
After completing this course, students will be able to:
- Understand connection handling
- Understand the PostgreSQL client tools
- Identify the query processing components
- Understand EXPLAIN
- Create database users and grant permissions
- Understand encryption in Azure Database for PostgreSQL
- Call a stored procedure in Azure Database for PostgreSQL
- Create and use a function in Azure Database for PostrgreSQL
- Describe write-ahead logging
- Describe replication and logical decoding
- Describe system catalogs and system views in Azure Database for PostgreSQL
- Investigate metadata in Azure Database for PostgreSQL
- Configure vacuum server parameters
- 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
- Describe statistics in Azure Database for PostgreSQL
- Assess query performance with the Query Store
- Understand the different online and offline migration options
- Select the appropriate migration tool for your specific scenario
Course content
Course Subjects:
- 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
Common questions
When does DP-3021: Configure and migrate to Azure Database for PostgreSQL next run?
The next date is Fri, 11 Sept 2026, and there are 3 further dates scheduled. Delivered ACE Training Wellington, ACE Training Auckland, live online. Every date and its format is listed on this page.
How much does DP-3021: Configure and migrate to Azure Database for PostgreSQL cost?
From $895 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
Before attending this course, students should have: An understanding of relational databases An understanding of basic SQL
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code DP3021 when you enquire.