Get started with generative AI in Azure Database for PostgreSQL

This module explores how to effectively use Azure Database for PostgreSQL - Flexible Server and the Azure AI extension to develop powerful Generative AI applications.

• Understand generative AI language models
• Describe the Azure AI extension
• Explore the Azure OpenAI schema
• Review the Azure Cognitive schema
• Explore semantic operators
• Examine the Azure Machine Learning schema
• Exercise-Explore the Azure AI extension

Enable semantic search in Azure Database for PostgreSQL

This module explores semantic search, embedding vectors, vector similarity, and using Azure Database for PostgreSQL - Flexible Server with PostgreSQL Vector and Azure AI extensions to generate, store, and query rows with semantic search.

• Understand semantic search
• Store vectors in Azure Database for PostgreSQL
• Create embeddings with the Azure AI extension
• Exercise - Generate vector embeddings with Azure OpenAI
• Explore semantic search use cases
• Exercise - Create a search function for a recommendation system

Integrate AI Services to enrich your applications with intelligent features in Azure Database for PostgreSQL

This module explores how to integrate Azure AI Services with Azure Database for PostgreSQL to add intelligent capabilities to your applications. You'll learn to use the azure_ai extension to call Azure AI Language services for text summarization, sentiment analysis, opinion mining, key phrase extraction, named entity recognition, and PII detection. You'll also explore text translation with Azure Translator and how to perform inference using Azure Machine Learning endpoints directly from your database.

• Summarize data with Azure AI Services and Azure Database for PostgreSQL
• Perform sentiment analysis and opinion mining in Azure Database for PostgreSQL
• Extract insights using Azure Language and Azure Database for PostgreSQL
• Translate text with Azure Translator and Azure Database for PostgreSQL
• Exercise - Use Azure AI services with Azure Database for PostgreSQL
• Use Azure Machine Learning for inference from Azure Database for PostgreSQL
• Exercise - Perform inference with Azure Machine Learning and Azure Database for PostgreSQL

Build RAG applications with Azure Database for PostgreSQL

Learn how to implement Retrieval Augmented Generation (RAG) on Azure Database for PostgreSQL, integrate Azure AI for embeddings, and build scalable, accurate AI-powered applications.

• Understand RAG pattern with Azure Database for PostgreSQL
• Explore information retrieval challenges - scale and accuracy
• Enhance scale with vector indexes
• Build RAG Applications with Azure Database for PostgreSQL and Python
• Exercise: Build RAG applications with Azure Database for PostgreSQL and Python
• Improve accuracy with advanced RAG architectures
• Explore GraphRAG with Azure Database for PostgreSQL
• Exercise: Implement GraphRAG with Azure Database for PostgreSQL

Implement generative AI agents with Azure Database for PostgreSQL

This module explores how to implement generative AI agents using Azure Database for PostgreSQL. You'll learn about agent architectures, information retrieval techniques, and how to integrate AI agents with Azure services like Azure AI Foundry Agent Service and Model Context Protocol (MCP). The module includes hands-on exercises to build and test an AI agent solution.

• Understand AI agents with Azure Database for PostgreSQL
• Apply information retrieval for agents
• Evaluate agentic frameworks for integration with PostgreSQL
• Implement AI agents with Foundry Agent Service
• Exercise - Build an AI agent with Foundry Agent Service and Azure Database for PostgreSQL
• Integrate AI agents with MCP and PostgreSQL

Develop PostgreSQL solutions in Visual Studio Code with the PostgreSQL extension and GitHub Copilot

Learn how to streamline PostgreSQL development using the Visual Studio Code PostgreSQL extension and GitHub Copilot.

• Understand how the PostgreSQL extension supports SQL development
• Understand how GitHub Copilot integrates with the PostgreSQL extension
• Use GitHub Copilot to generate, refine, and troubleshoot SQL queries
• Exercise - Enhance PostgreSQL development with GitHub Copilot