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

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

Overview
Dive into the world of PostgreSQL in Azure with our comprehensive 8-hour course. You'll gain essential knowledge of PostgreSQL architecture and learn practical steps for configuring and managing PostgreSQL databases in the Azure environment. From exploring security features to mastering query tuning and migration strategies, this course covers it all.

Through a combination of expert instruction and hands-on labs, you'll develop the skills to manage, configure, and migrate databases effectively. Whether you're looking to enhance your database administration skills or prepare for real-world migration scenarios, this course equips you with the tools and knowledge to excel in PostgreSQL management on Azure.

Who Should Attend
This course is designed for database administrators who want to expand their skills into Azure PostgreSQL management. If you're looking to transition your PostgreSQL databases to Azure or enhance your ability to manage and optimize Azure Database for PostgreSQL, this course is perfect for you.

Prerequisites
Demonstrate an understanding of relational databases and basic SQL. No prior experience with Azure or PostgreSQL is required, but familiarity with database concepts will be beneficial.

Course Outline

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 Content Control 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

View outline in Word

ADP3C1

Attend hands-on, instructor-led DP-3021: Configure and Migrate to Azure Database for PostgreSQL training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.