Microsoft Copilot & Azure AI
AI-3019 Build AI Apps with Azure Database for PostgreSQL
A one-day lab on AI inside your database.
1 dayIntermediate6 modulesAI-3019
About this course
A one-day lab on AI inside your database. You will use generative AI and semantic search in Azure Database for PostgreSQL, enrich data with Azure AI services, build RAG applications and agents, and write SQL faster with GitHub Copilot in Visual Studio Code.
Curriculum
6 modules
- 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
- Module assessment
- Understand semantic search
- Store vectors in Azure Database for PostgreSQL
- Create embeddings with the Azure AI extension
- Explore semantic search use cases
- Module assessment
- 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
- Module assessment
- 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
- Module assessment
- 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
- Module assessment
- 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
Who it's for
Developers and database professionals who work with PostgreSQL.
Before you start
- Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of AI and ML concepts.
Related courses
More in Microsoft Copilot & Azure AI →AdvancedAB-100T00
AB-100T00: Architecting agentic AI business solutions
Microsoft Copilot & Azure AI
View course →IntermediateAB-6007
AB-6007: Secure and Govern your AI agent workforce
Microsoft Copilot & Azure AI
View course →IntermediateAB-6008
AB-6008: Delegate work with Copilot Cowork
Microsoft Copilot & Azure AI
View course →IntermediateAB-620T00
AB-620T00: Design and build integrated AI agent solutions in Copilot Studio
Microsoft Copilot & Azure AI
View course →IntermediateAB-730T00
AB-730T00 Transform business workflows with generative AI
Microsoft Copilot & Azure AI
View course →IntermediateAB-731T00
AB-731T00 Drive AI transformation in your organization
Microsoft Copilot & Azure AI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.