DP-3021 · PostgreSQL on Azure
Why Is Everyone Suddenly Talking About PostgreSQL?
The database powering the AI era. Learn to run, secure, tune, and migrate it on Azure in just one day.
The market shift
Why PostgreSQL Now
PostgreSQL has moved from trusted open-source database to a core platform for cloud applications, analytics, and production AI.
Nearly $1.25B in 2025 deals
Databricks agreed to acquire Neon for approximately $1 billion, while Snowflake agreed to acquire Crunchy Data in another major PostgreSQL transaction.
Lakebase runs on Postgres
Databricks built Lakebase on Neon's serverless PostgreSQL technology, bringing operational Postgres directly into the Databricks platform.
Proven at massive scale
Notion has documented scaling PostgreSQL beyond 200 billion block rows and hundreds of terabytes, using 96 physical database instances.
AI search with pgvector
The open-source pgvector extension adds vector embeddings and similarity search to PostgreSQL, so many RAG workloads do not need a separate vector database.
Runs across every major cloud
PostgreSQL is available through AWS RDS, Azure Database for PostgreSQL, Google Cloud SQL, Supabase, Neon, and other managed platforms.
Developers keep choosing it
PostgreSQL was the most-used database in Stack Overflow's 2024 Developer Survey for the second consecutive year.
Sources: Databricks and Neon announcements; Notion Engineering; pgvector documentation; Stack Overflow Developer Survey 2024.
Configure and Migrate to Azure Database for PostgreSQL
DP-3021 is a one-day, instructor-led Microsoft Applied Skills course for professionals who need to configure PostgreSQL, diagnose performance, protect workloads, and plan an offline migration to Azure Database for PostgreSQL.
The course combines PostgreSQL fundamentals with production administration skills. You will work through architecture, security, concurrency, query analysis, performance tuning, and Azure migration decisions in one focused day.
Who Should Take This Course
What You Will Learn
Module 1
PostgreSQL Architecture
Understand PostgreSQL processes, memory, storage, databases, schemas, and core server architecture.
Module 2
Client-Server Communication
Connect clients securely, configure connection behavior, and understand PostgreSQL network communication.
Module 3
Query Processing with EXPLAIN
Read query plans with EXPLAIN and EXPLAIN ANALYZE to understand how PostgreSQL executes SQL.
Module 4
Security and Permissions
Manage roles, authentication, object privileges, and least-privilege access for production workloads.
Module 5
Stored Procedures and Functions
Create reusable PostgreSQL functions and procedures for reliable database-side logic.
Module 6
Write-Ahead Logging
Understand WAL, checkpoints, recovery concepts, and how PostgreSQL protects data durability.
Module 7
System Parameters and Metadata
Inspect system catalogs and tune configuration parameters for workload requirements.
Module 8
Concurrency and Locking
Work with transactions, isolation, MVCC, locks, and blocking-session diagnosis.
Module 9
Performance and Azure Migration
Use Query Store for performance analysis and complete an offline migration to Azure Database for PostgreSQL.
Already working with Databricks?
Connect operational PostgreSQL with the lakehouse
Lakebase is built on Neon's PostgreSQL technology, so Postgres and Databricks skills increasingly overlap. Build both sides with our specialist training and consulting services.