DP-3021: Configure and Migrate to Azure Database for PostgreSQL

Course Description:

Overview

• Explore PostgreSQL architecture and shared memory concepts
• Configure Azure Database for PostgreSQL servers and client tools
• Understand query processing components and EXPLAIN use
• Secure databases with users, permissions, and encryption
• Implement stored procedures, functions, and write-ahead logging
• Manage concurrency via MVCC, snapshots, and isolation levels
• Tune queries using statistics and Query Store insights
• Plan and execute online and offline migrations to Azure

Objectives

• Understand PostgreSQL internal architecture
• Set up and manage Azure Database for PostgreSQL servers
• Perform query performance assessment and tuning
• Secure PostgreSQL with RBAC and encryption
• Use WAL, replication, and logical decoding
• Manage metadata, VACUUM, and concurrency controls
• Execute migrations using Azure migration tools

Target Audience

• Database Administrators seeking Azure PostgreSQL expertise
• DBAs planning real-world PostgreSQL migrations

Prerequisites

• Understanding of relational databases and basic SQL
• No prior Azure or PostgreSQL experience required

Explore PostgreSQL architecture

• Architecture of PostgreSQL
• Options for creating an Azure Database for PostgreSQL server
• PostgreSQL shared memory

Understand client–server communication in PostgreSQL

• Connection handling
• PostgreSQL client tools

Understand PostgreSQL query processing

• Query processing components
• EXPLAIN statement

Secure Azure Database for PostgreSQL

• Security features of Azure Database for PostgreSQL
• Create database users and grant permissions
• Encryption in Azure Database for PostgreSQL

Procedures and functions in PostgreSQL

• Create and call stored procedures
• Create and use functions

Understand write–ahead logging

• Write–ahead logging concepts
• Replication and logical decoding

Configure and manage Azure Database for PostgreSQL

• System catalogs and system views
• Metadata investigation
• VACUUM process and configuration

Understand concurrency in PostgreSQL

• Multi-Version Concurrency Control (MVCC) and snapshots
• Isolation levels
• Locking in Azure Database for PostgreSQL

Tune queries in Azure Database for PostgreSQL

• Statistics in Azure Database for PostgreSQL
• Query performance assessment with Query Store

Migrate to Azure Database for PostgreSQL flexible server

• Online and offline migration options
• Migration tools overview
• Selecting appropriate migration tools
• Offline and online PostgreSQL database migration

Explore PostgreSQL architecture

• Architecture of PostgreSQL
• Options for creating an Azure Database for PostgreSQL server
• PostgreSQL shared memory

Understand client–server communication in PostgreSQL

• Connection handling
• PostgreSQL client tools

Understand PostgreSQL query processing

• Query processing components
• EXPLAIN statement

Secure Azure Database for PostgreSQL

• Security features of Azure Database for PostgreSQL
• Create database users and grant permissions
• Encryption in Azure Database for PostgreSQL

Procedures and functions in PostgreSQL

• Create and call stored procedures
• Create and use functions

Understand write–ahead logging

• Write–ahead logging concepts
• Replication and logical decoding

Configure and manage Azure Database for PostgreSQL

• System catalogs and system views
• Metadata investigation
• VACUUM process and configuration

Understand concurrency in PostgreSQL

• Multi-Version Concurrency Control (MVCC) and snapshots
• Isolation levels
• Locking in Azure Database for PostgreSQL

Tune queries in Azure Database for PostgreSQL

• Statistics in Azure Database for PostgreSQL
• Query performance assessment with Query Store

Migrate to Azure Database for PostgreSQL flexible server

• Online and offline migration options
• Migration tools overview
• Selecting appropriate migration tools
• Offline and online PostgreSQL database migration

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation