Data Private Public

Build AI Apps with Azure Database for PostgreSQL (AI-3019)

1 day
PostgreSQLAzureDatabasesAI

Build AI-powered apps with Azure Database for PostgreSQL using semantic search, RAG, AI agents, Azure AI Services, Machine Learning, and GitHub Copilot.

Talk to a Learning ConsultantRegister for a Public ClassRequest a Private Class

Register or Request Training

Price per student
$681.10
Guaranteed to run
Select a date
Please select a class.
Interested in a private class?
  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Explore how integrations provided by the Azure AI extension for Azure Database for PostgreSQL Flexible Server can support AI-powered application development. Learn to work with generative AI models, embeddings, vector storage, semantic search, Azure AI Services, and Azure Machine Learning.

The course also covers retrieval-augmented generation (RAG), vector indexes, advanced RAG architectures, GraphRAG, and generative AI agents. You will also learn how the PostgreSQL extension for Visual Studio Code and GitHub Copilot can help you generate, refine, and troubleshoot SQL queries.

Course Benefits

  • Explain how generative AI models and the Azure AI extension work with Azure Database for PostgreSQL.
  • Explore Azure OpenAI, Azure Cognitive, and Azure Machine Learning schemas and semantic operators.
  • Store vectors, create embeddings, and enable semantic search in PostgreSQL.
  • Use Azure AI Services to summarize, analyze, extract insights from, and translate data.
  • Use Azure Machine Learning for inference from Azure Database for PostgreSQL.
  • Build RAG applications with PostgreSQL, Python, vector indexes, and advanced retrieval architectures.
  • Explore GraphRAG with Azure Database for PostgreSQL.
  • Apply information retrieval and agentic frameworks to generative AI agents.
  • Integrate AI agents with Foundry Agent Service, MCP, and PostgreSQL.
  • Use the PostgreSQL extension and GitHub Copilot in Visual Studio Code to generate, refine, and troubleshoot SQL queries.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .
Private Class
Delivered for your team at your site or online.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Microsoft Certified Partner

Course Outline

  1. Get started with generative AI in Azure Database for PostgreSQL
    1. Understand generative AI language models
    2. Describe the Azure AI extension
    3. Explore the Azure OpenAI schema
    4. Review the Azure Cognitive schema
    5. Explore semantic operators
    6. Examine the Azure Machine Learning schema
    7. Module assessment
  2. Enable semantic search in Azure Database for PostgreSQL
    1. Understand semantic search
    2. Store vectors in Azure Database for PostgreSQL
    3. Create embeddings with the Azure AI extension
    4. Explore semantic search use cases
    5. Module assessment
  3. Integrate AI Services to enrich your applications with intelligent features in Azure Database for PostgreSQL
    1. Summarize data with Azure AI Services and Azure Database for PostgreSQL
    2. Perform sentiment analysis and opinion mining in Azure Database for PostgreSQL
    3. Extract insights using Azure Language and Azure Database for PostgreSQL
    4. Translate text with Azure Translator and Azure Database for PostgreSQL
    5. Use Azure Machine Learning for inference from Azure Database for PostgreSQL
    6. Module assessment
  4. Build RAG applications with Azure Database for PostgreSQL
    1. Understand the RAG pattern with Azure Database for PostgreSQL
    2. Explore information retrieval challenges involving scale and accuracy
    3. Enhance scale with vector indexes
    4. Build RAG applications with Azure Database for PostgreSQL and Python
    5. Improve accuracy with advanced RAG architectures
    6. Explore GraphRAG with Azure Database for PostgreSQL
    7. Module assessment
  5. Implement generative AI agents with Azure Database for PostgreSQL
    1. Understand AI agents with Azure Database for PostgreSQL
    2. Apply information retrieval for agents
    3. Evaluate agentic frameworks for integration with PostgreSQL
    4. Implement AI agents with Foundry Agent Service
    5. Integrate AI agents with MCP and PostgreSQL
    6. Module assessment
  6. Develop PostgreSQL solutions in Visual Studio Code with the PostgreSQL extension and GitHub Copilot
    1. Understand how the PostgreSQL extension supports SQL development
    2. Understand how GitHub Copilot integrates with the PostgreSQL extension
    3. Use GitHub Copilot to generate, refine, and troubleshoot SQL queries

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following would be useful for this PostgreSQL class:

Experience working with PostgreSQL databases and writing SQL queries is recommended. A general understanding of AI and machine learning concepts is also useful.

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant