Intermediate
    DP-3021

    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.

    1 days · 8 hoursLive online · Instructor-ledMicrosoft Applied Skills
    Microsoft Certified Trainer (MCT)
    Official Microsoft labs included
    Small cohort · personalised attention
    Member of the Claude Partner Network

    Starting from

    $549USD · per participant

    💬 Group & early-bird discounts available — ask on WhatsApp

    Everything included

    • Official Microsoft courseware & slides
    • Individual Microsoft lab environment access
    • Microsoft digital achievement badge
    • Exam preparation support & tips
    • WhatsApp community group access
    • 1-on-1 WhatsApp support post-training
    • Flexible scheduling — dates that suit you
    • Free 1-1 Zoom consultation before enrolling
    Duration1 days (8h)
    FormatLive · Virtual Classroom
    Group bookingDiscounted rates
    Cohort sizeSmall · personalised

    💬 Usually replies within minutes · No payment needed to enquire

    How it works

    • →1. WhatsApp us with your course of interest
    • →2. We schedule a free Zoom call to walk you through the course
    • →3. Pick your dates — we flex around your schedule
    • →4. Train, get certified, and join our WhatsApp community

    Course Overview

    DP-3021 is a practical Microsoft Applied Skills course for professionals who need to operate PostgreSQL on Azure. In one instructor-led day, you will examine how PostgreSQL works, configure security and server settings, diagnose query performance, manage concurrency, and plan an offline migration to Azure Database for PostgreSQL.

    Why PostgreSQL Now

    PostgreSQL combines a mature relational database with an open extension ecosystem, making it relevant to both established production systems and new AI applications.

    $1 billion vote of confidence

    Databricks announced its approximately $1 billion acquisition of serverless Postgres company Neon in May 2025. Snowflake also announced its acquisition of PostgreSQL specialist Crunchy Data in June 2025; that deal's value was not publicly disclosed.

    Source: Databricks announcement

    Postgres underpins Databricks Lakebase

    Databricks launched Lakebase in June 2025 as a fully managed, Postgres-based operational database built on Neon's technology, connecting transactional application data with the Databricks platform.

    Source: Databricks Lakebase announcement

    Proven at very large scale

    Notion reported scaling its PostgreSQL estate from about 20 billion rows in 2021 to more than 200 billion by 2024 through horizontal sharding—strong evidence of PostgreSQL's ability to support demanding production systems.

    Source: Notion Engineering

    AI search inside PostgreSQL

    The open-source pgvector extension adds vector similarity search for embeddings. For many RAG and semantic-search workloads, teams can keep relational and vector data together instead of operating a separate vector database.

    Source: Microsoft pgvector guidance

    Available across the cloud ecosystem

    PostgreSQL is offered as a managed database on AWS, Microsoft Azure, and Google Cloud, as well as PostgreSQL-focused platforms including Supabase and Neon.

    Developers keep choosing PostgreSQL

    PostgreSQL was the most-used database among professional developers in Stack Overflow's 2024 Developer Survey, continuing its lead for a second year.

    Source: Stack Overflow 2024 survey

    What You Will Learn

    • Explain PostgreSQL architecture and client-server communication
    • Read query plans and investigate performance with EXPLAIN
    • Configure roles, permissions, and database security
    • Work with stored procedures, functions, and write-ahead logging
    • Manage server parameters, metadata, concurrency, and locking
    • Tune workloads with Query Store for Azure Database for PostgreSQL
    • Plan and perform an offline PostgreSQL migration to Azure
    • Understand where PostgreSQL and pgvector fit in AI and RAG applications

    Certification & Exam

    DP-3021 supports the Microsoft Applied Skills credential: Configure and migrate to Azure Database for PostgreSQL. This is an Applied Skills credential validated through an interactive, hands-on assessment rather than a traditional certification exam.

    Already working with Databricks?

    PostgreSQL and Databricks skills increasingly overlap. Lakebase is Postgres-based and powered by Neon technology, so teams building operational AI applications can benefit from understanding both ecosystems. Explore our Databricks training and consulting options.

    Explore Databricks training

    Frequently Asked Questions

    Why is PostgreSQL important for AI applications?

    PostgreSQL can store application data and, with pgvector, vector embeddings used for semantic search and retrieval-augmented generation. This lets many teams support relational and AI search workloads in one familiar database platform.

    What is pgvector?

    pgvector is an open-source PostgreSQL extension for storing embeddings and running vector similarity searches. Azure Database for PostgreSQL supports the extension for AI search and RAG scenarios.

    What is Databricks Lakebase and how does it relate to PostgreSQL?

    Lakebase is Databricks' managed, Postgres-based operational database, built on technology from Neon. It connects PostgreSQL application workloads with the broader Databricks data and AI platform.

    Do I need PostgreSQL experience before taking this course?

    No advanced PostgreSQL experience is required. You should understand relational database concepts and basic SQL before attending.

    Is DP-3021 a Microsoft certified course?

    DP-3021 is Microsoft Official Course content aligned to the Microsoft Applied Skills credential, Configure and migrate to Azure Database for PostgreSQL. The credential uses an interactive lab assessment rather than a traditional certification exam.

    What will I learn in this course?

    You will learn PostgreSQL architecture, client-server communication, query plans, security, procedures and functions, write-ahead logging, configuration, concurrency, Query Store performance tuning, and offline migration to Azure Database for PostgreSQL.

    Starting from

    $549USD

    Group & early-bird discounts available

    • Official Microsoft labs included
    • Microsoft achievement badge
    • Exam prep support
    • WhatsApp community + 1-on-1 support
    • Free Zoom consultation

    No payment needed · Usually replies in minutes

    Stay Updated with Instrovate

    Get the latest insights on Microsoft certifications, cloud technologies, and training updates delivered to your inbox.

    📘 New Course Just Launched: DP-600 with Pearson IT CertificationView Course