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

Course DP-3021 Configure and migrate to Azure Database for PostgreSQL

Azure Database for PostgreSQL is a platform-as-a-service database offering from Microsoft's cloud. It's built on the open-source PostgreSQL relational database and includes built-in high availability, automatic backup and restore, and comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scalability. In this course, you'll learn the core features of PostgreSQL and how they work with Azure Database for PostgreSQL . You'll also learn about the different deployment options for Azure Database for PostgreSQL and how to configure a server to meet your specific needs.

Intermediate - Database Administrator - Azure Database for PostgreSQL

Objectives of the DP-3021 training

• Configure and manage Azure Database for PostgreSQL, optimizing its performance and ensuring its scalability.
  
• Learn about the available deployment options and data migration tools, such as Azure Database Migration Service.
  
• Acquire practical skills to manage PostgreSQL databases in Azure environments
• Develop advanced skills in security, monitoring and optimization of cloud databases.

Course content DP-3021

Module 1 Exploring the PostgreSQL Architecture

• Description of Azure Database for PostgreSQL.
• Description of the PostgreSQL architecture
  
• Description of PostgreSQL shared memory
  
• Exercise: Exploring Azure Database for PostgreSQL

Module 2 Description of client-server communication in PostgreSQL

• Description of connection control
  
• Description of PostgreSQL client tools
  
• Exercise: Exploring PostgreSQL with client tools

Module 3 Description of PostgreSQL Query Processing

• Identifying the query processing components
  
• Description of the EXPLAIN instruction
  
• Exercise: Execution of the EXPLAIN instruction

Module 4: Protecting Azure Database for PostgreSQL

• Azure Database for PostgreSQL Security Overview
  
• Description of the built-in Azure Database for PostgreSQL server roles
  
• Granting permissions in Azure SQL Database for PostgreSQL
  
• Description of encryption in Azure Database for PostgreSQL
  
• Exercise: Configuring permissions in Azure Database for PostgreSQL

Module 5 Procedures and functions in PostgreSQL

• Creating a stored procedure in Azure Database for PostgreSQL
  
• Calling a stored procedure in Azure Database for PostgreSQL
  
• Creating and using a function in Azure Database for PostgreSQL
  
• Exercise: Creating a stored procedure in Azure Database for PostgreSQL

Module 6 Description of the previous writing record

• Description of the previous writing record
  
• Description of replication and logical decoding
  
• Exercise: Enumeration of table changes with logical decoding

Module 7 Configure and manage Azure Database for PostgreSQL

• Understand system catalogs and system views
  
• Metadata research using system catalogs and system views
  
• Explanation of the purpose of emptying and automatic emptying
  
• Automatic emptying server parameter configuration
  
• Exercise: Configure system parameters and explore metadata using system catalogs and views

Module 8 Description of concurrency in PostgreSQL

• Description of Multi-Version Concurrency Control (MVCC) and snapshots
  
• Description of insulation levels
  
• Block description
  
• Exercise: Block Description

Module 9 Optimizing queries in Azure Database for PostgreSQL

• Description of the statistics
  
• Evaluating the performance of queries with the Query Store
  
• Exercise: Evaluating query performance using Query Store

Module 10 Migration to the Azure Database for PostgreSQL Flexible Server

• Comparison between online and offline migrations
  
• Identifying migration tool options
  
• Analysis of the decision criteria for tool selection and the migration model
  
• Exercise: Offline PostgreSQL database migration
  
• Exercise: Online PostgreSQL Database Migration

Prerequisites

Knowledge of relational databases and basic SQL is recommended.

Language

• Course: English / Spanish
  

Microsoft Applied Skills

This course is part of the Microsoft Applied Skills Credentials.

Earn this Microsoft Applied Skills credential. In this course, you will learn how to configure and migrate to Azure Database for PostgreSQL.

Applied Skills: Explore all credentials in one guide