Cart 0

Configure and migrate to Azure Database for PostgreSQL (DP-3021)
Course 8734
1 DAY COURSE

Course Outline

Azure Database for PostgreSQL is a robust Platform as a Service (PaaS) offering from Microsoft, built on the open-source PostgreSQL database. This course equips you to explore PostgreSQL architecture, configure and secure your database, optimize performance, and migrate data effectively to Azure Database for PostgreSQL Flexible Server. Learn essential skills like query tuning, concurrency management, and leveraging PostgreSQL's built-in features to enhance your database management experience.

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

  • In this course, you will:

    • Gain practical skills to configure and manage Azure Database for PostgreSQL.
    • Understand PostgreSQL architecture and advanced features like multi-version concurrency control (MVCC).
    • Learn to optimize query performance and implement security best practices.
    • Explore hands-on data migration techniques, including online and offline methods.
    • Master advanced features like write-ahead logging, stored procedures, and tuning tools for efficient database operations.

  • Prerequisites

    • Familiarity with relational databases
    • Basic understanding of SQL

Configure and Migrate to Azure Database for PostgreSQL Training Outline

Learning Objectives

Explore PostgreSQL Architecture

  • Overview of Azure Database for PostgreSQL.
  • Understand architecture and shared memory.
  • Hands-on: Explore PostgreSQL on Azure.

Client-Server Communication

  • Connection handling and PostgreSQL client tools.
  • Exercise: Utilize PostgreSQL client tools.

Query Processing

  • Components of query processing and the EXPLAIN statement.
  • Exercise: Analyze queries with EXPLAIN.

Secure Azure Database for PostgreSQL

  • Encryption, authentication, and role-based permissions.
  • Exercise: Configure database permissions.

Stored Procedures and Functions

  • Create reusable stored procedures and functions.
  • Exercise: Implement stored procedures in PostgreSQL.

Write-Ahead Logging

  • Understand ACID compliance and logical decoding.
  • Exercise: List table changes using logical decoding.

Configure and Manage PostgreSQL

  • System catalogs, metadata, and autovacuum configuration.
  • Exercise: Optimize database configurations.

Concurrency Management

  • Multi-version concurrency control (MVCC), isolation levels, and locking.
  • Exercise: Explore locking mechanisms.

Query Tuning

  • Query performance metrics and the Query Store.
  • Exercise: Assess and optimize queries.

Migrate to Azure Database for PostgreSQL

  • Compare online vs. offline migration methods.
  • Exercises: Perform online and offline migrations.
Course Dates
Attendance Method
Note about the Certification Exam

When you register for the course, you will be prompted to choose Y/N to take the exam. Please select yes, as all HHS CISO employees are required to attempt the exam if one is offered for the course. Please be advised, if your course if funded by DIR, the Certification Organization has agreed to provide DIR the pass/fail status of your exam. DIR will only share this information in an aggregated report to state leadership that reflects total exam pass or fails. No individual names of any students will be included in any reports.

DIR requires that you submit the request for your exam voucher within one month of the last day of your course. DIR requires that you take your exam within six months of the last day of your course.

Additional comments or questions (optional)