AI-3019 – Build AI Apps with Azure Database for PostgreSQL

About the Course

This learning path explores how the Azure AI and Azure Machine Learning Services integrations provided by the Azure AI extension for Azure Database for PostgreSQL – Flexible Server can enable you to build AI-powered apps.

There are currently no scheduled sessions available for this course. However, feel free to contact us for more information or to inquire about upcoming sessions.

Questions about this? let our team answer them!

Course Outline

1. Get started with generative AI in Azure Database for PostgreSQL
• 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

2. Enable semantic search in Azure Database for PostgreSQL
• Understand semantic search
• Store vectors in Azure Database for PostgreSQL
• Create embeddings with the Azure AI extension
• Explore semantic search use cases

3. Integrate AI Services to enrich your applications with intelligent features in Azure Database for PostgreSQL
• 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
• Use Azure Machine Learning for inference from Azure Database for PostgreSQL

4. Build RAG applications with Azure Database for PostgreSQL
• 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
• Improve accuracy with advanced RAG architectures
• Explore GraphRAG with Azure Database for PostgreSQL

5. Implement generative AI agents with Azure Database for PostgreSQL
• 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
• Integrate AI agents with MCP and PostgreSQL

6. Develop PostgreSQL solutions in Visual Studio Code with the 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

Course Details

Pre-requisites

• Experience working with PostgreSQL databases.
• Experience writing SQL queries.
• A general understanding of AI and ML concepts.

Target Audience

As a candidate for this credential, you should have experience writing SQL queries and Python. You should also be familiar with general AI concepts and RAG frameworks.

Class Format

For online (live) format

There are currently no scheduled sessions available for this course. However, feel free to contact us for more information or to inquire about upcoming sessions.