Data Private Public

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

1 day
PostgreSQLAzure

Learn to configure, secure, tune, manage, and migrate PostgreSQL workloads to Azure Database for PostgreSQL Flexible Server in this focused one-day course.

Talk to a Learning ConsultantRegister for a Public ClassRequest a Private Class

Register or Request Training

Price per student
$681.10
Guaranteed to run
Select a date
Please select a class.
Interested in a private class?
  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Azure Database for PostgreSQL is a fully managed cloud database service with built-in high availability, backup and restore capabilities, security features, and flexible scaling. In this one-day course, you will explore PostgreSQL architecture and query processing, configure and secure Azure Database for PostgreSQL, tune database performance, and evaluate options for migrating to Flexible Server.

Course Benefits

  • Explain PostgreSQL architecture, shared memory, client-server communication, and query processing.
  • Use PostgreSQL client tools and the EXPLAIN statement.
  • Configure security, server roles, permissions, and encryption in Azure Database for PostgreSQL.
  • Create and use PostgreSQL stored procedures and functions.
  • Explain write-ahead logging, replication, logical decoding, concurrency, and locking.
  • Manage system metadata, vacuum, autovacuum, and related server parameters.
  • Assess and tune query performance using statistics and Query Store.
  • Compare migration approaches and tools for moving to Azure Database for PostgreSQL Flexible Server.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .
Private Class
Delivered for your team at your site or online.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Microsoft Certified Partner

Course Outline

  1. Explore PostgreSQL Architecture
    1. Describe Azure Database for PostgreSQL
    2. Understand PostgreSQL architecture
    3. Understand PostgreSQL shared memory
    4. Module assessment
  2. Understand Client-Server Communication in PostgreSQL
    1. Understand connection handling
    2. Understand the PostgreSQL client tools
    3. Module assessment
  3. Understand PostgreSQL Query Processing
    1. Identify the query-processing components
    2. Understand the EXPLAIN statement
    3. Module assessment
  4. Secure Azure Database for PostgreSQL
    1. Describe Azure Database for PostgreSQL security
    2. Describe built-in Azure Database for PostgreSQL server roles
    3. Grant permissions in Azure Database for PostgreSQL
    4. Understand encryption in Azure Database for PostgreSQL
    5. Module assessment
  5. Procedures and Functions in PostgreSQL
    1. Create a stored procedure in Azure Database for PostgreSQL
    2. Call a stored procedure in Azure Database for PostgreSQL
    3. Create and use a function in Azure Database for PostgreSQL
    4. Module assessment
  6. Understand Write-Ahead Logging
    1. Describe write-ahead logging
    2. Describe replication and logical decoding
    3. Module assessment
  7. Configure and Manage Azure Database for PostgreSQL
    1. Understand system catalogs and system views
    2. Investigate metadata with system catalogs and system views
    3. Explain the purpose of vacuum and autovacuum
    4. Configure autovacuum server parameters
    5. Module assessment
  8. Understand Concurrency in PostgreSQL
    1. Understand multi-version concurrency control (MVCC) and snapshots
    2. Describe isolation levels
    3. Understand locking
    4. Module assessment
  9. Tune Queries in Azure Database for PostgreSQL
    1. Understand statistics
    2. Assess query performance with Query Store
    3. Module assessment
  10. Migrate to Azure Database for PostgreSQL Flexible Server
    1. Compare online and offline migrations
    2. Identify migration tool options
    3. Analyze decision criteria for tool selection and migration model
    4. Module assessment

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this PostgreSQL class:

  • Understanding of relational databases
  • Understanding of basic SQL

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant