Address
Level 8/25 Restwell Street, Bankstown NSW 2200, Australia
Business Hours
Monday to Friday: 10AM - 6PM
Weekend: CLOSED
DP-3021: Configure and migrate to Azure Database for PostgreSQL
This intermediate course shows database administrators how to configure, manage and migrate PostgreSQL databases to Azure. You’ll explore PostgreSQL architecture, client-server communication, query processing and security, then learn performance tuning, concurrency and migration strategies for Azure Database for PostgreSQL Flexible Server.
Duration
8 Hours (1 Day)
Modules
1 Modules
Course type
Microsoft
Course Overview
This intermediate-level learning path is designed for database administrators looking to configure, manage, and migrate PostgreSQL databases to Azure. You’ll explore PostgreSQL architecture, client-server communication, query processing, and security features. The course also covers performance tuning, concurrency, and migration strategies using Azure Database for PostgreSQL Flexible Server.
Before You Begin
- Understanding of relational database concepts
- Basic SQL knowledge and query writing
- Familiarity with Azure portal and resource setup
- Experience with database administration tasks
Key outcomes
- Configure PostgreSQL Servers Optimize for performance, scale, and availability.
- Secure & Tune Databases Use encryption, permissions, and query tuning techniques.
- Understand Architecture & Logs Explore PostgreSQL internals and logging mechanisms.
- Migrate with Flexibility Use flexible server options for seamless migration.
Tools you’ll use
Azure Portal
Azure Database for PostgreSQL
PgAdmin 4 Version 9.6
Azure Data Migration Service
Skills you’ll gain
- PostgreSQL Server Setup
- Database Security Features
- Query Performance Tuning
- Seamless Migration Tools
- Multi-User Concurrency
- Azure Database Management
- Authentication and Permissions
- Optimized Query Execution
What You’ll Learn
1 module
1Lesson 1: Configure and migrate to Azure Database for PostgreSQL
Module 1: Explore PostgreSQL Architecture Module 2: Understand Client-Server Communication in PostgreSQL Module 3: Understand PostgreSQL Query Processing Module 4: Secure Azure Database for PostgreSQL Module 5: Procedures and Functions in PostgreSQL Module 6: Understand Write-Ahead Logging Module 7: Configure and Manage Azure Database for PostgreSQL Module 8: Understand Concurrency in PostgreSQL Module 9: Tune Queries in Azure Database for PostgreSQL Module 10: Migrate to Azure Database for PostgreSQL Flexible Server
Certification & Credentials
Certificate track
8 Hours (1 Day)
Frequently asked questions
What is Azure Database for PostgreSQL?
It’s a managed PostgreSQL service on Azure offering high availability, security, and scalability.
Do I need PostgreSQL experience?
Basic SQL and relational database knowledge is required to follow the course.
Can I migrate existing PostgreSQL databases?
Yes, the course covers both online and offline migration methods.
Is this course suitable for DBAs?
Absolutely. It’s tailored for database administrators managing PostgreSQL in Azure.
What are the key benefits of using Azure PostgreSQL?
Built-in backups, high availability, security features, and flexible scaling options.
| Duration | 8 Hours (1 Day) |
|---|---|
| Modules | 1 Modules |
| Course type | Microsoft |
| Category | Microsoft |
| Prerequisites | Understanding of relational database concepts, Basic SQL knowledge and query writing, Familiarity with Azure portal and resource setup, Experience with database administration tasks |
Be the first to review “DP-3021: Configure and migrate to Azure Database for PostgreSQL”
Reviews
There are no reviews yet.