AI-3019MSMicrosoftMS-AI-30191.0<p>Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of AI and ML concepts.</p><h4>Get started with generative AI in Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Understand generative AI language models</li><li>Describe the Azure AI extension</li><li>Explore the Azure OpenAI schema</li><li>Review the Azure Cognitive schema</li><li>Explore semantic operators</li><li>Examine the Azure Machine Learning schema</li><li>Exercise-Explore the Azure AI extension</li><li>Module assessment</li><li>Summary</li></ul> <h4>Enable semantic search in Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Understand semantic search</li><li>Store vectors in Azure Database for PostgreSQL</li><li>Create embeddings with the Azure AI extension</li><li>Exercise - Generate vector embeddings with Azure OpenAI</li><li>Explore semantic search use cases</li><li>Exercise - Create a search function for a recommendation system</li><li>Module assessment</li><li>Summary</li></ul> <h4>Integrate AI Services to enrich your applications with intelligent features in Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Summarize data with Azure AI Services and Azure Database for PostgreSQL</li><li>Perform sentiment analysis and opinion mining in Azure Database for PostgreSQL</li><li>Extract insights using Azure Language and Azure Database for PostgreSQL</li><li>Translate text with Azure Translator and Azure Database for PostgreSQL</li><li>Exercise - Use Azure AI services with Azure Database for PostgreSQL</li><li>Use Azure Machine Learning for inference from Azure Database for PostgreSQL</li><li>Exercise - Perform inference with Azure Machine Learning and Azure Database for PostgreSQL</li><li>Module assessment</li><li>Summary</li></ul> <h4>Build RAG applications with Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Understand RAG pattern with Azure Database for PostgreSQL</li><li>Explore information retrieval challenges - scale and accuracy</li><li>Enhance scale with vector indexes</li><li>Build RAG Applications with Azure Database for PostgreSQL and Python</li><li>Exercise: Build RAG applications with Azure Database for PostgreSQL and Python</li><li>Improve accuracy with advanced RAG architectures</li><li>Explore GraphRAG with Azure Database for PostgreSQL</li><li>Exercise: Implement GraphRAG with Azure Database for PostgreSQL</li><li>Module assessment</li><li>Summary</li></ul> <h4>Implement generative AI agents with Azure Database for PostgreSQL</h4><ul> <li>Introduction</li><li>Understand AI agents with Azure Database for PostgreSQL</li><li>Apply information retrieval for agents</li><li>Evaluate agentic frameworks for integration with PostgreSQL</li><li>Implement AI agents with Foundry Agent Service</li><li>Exercise - Build an AI agent with Foundry Agent Service and Azure Database for PostgreSQL</li><li>Integrate AI agents with MCP and PostgreSQL</li><li>Module assessment</li><li>Summary</li></ul> <h4>Develop PostgreSQL solutions in Visual Studio Code with the PostgreSQL extension and GitHub Copilot</h4><ul> <li>Introduction</li><li>Understand how the PostgreSQL extension supports SQL development</li><li>Understand how GitHub Copilot integrates with the PostgreSQL extension</li><li>Use GitHub Copilot to generate, refine, and troubleshoot SQL queries</li><li>Exercise - Enhance PostgreSQL development with GitHub Copilot</li><li>Knowledge check</li><li>Summary</li></ul>Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of AI and ML concepts.Get started with generative AI in Azure Database for PostgreSQL - Introduction - 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 - Module assessment - Summary Enable semantic search in Azure Database for PostgreSQL - Introduction - 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 - Module assessment - Summary Integrate AI Services to enrich your applications with intelligent features in Azure Database for PostgreSQL - Introduction - 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 - Module assessment - Summary Build RAG applications with Azure Database for PostgreSQL - Introduction - 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 - Module assessment - Summary Implement generative AI agents with Azure Database for PostgreSQL - Introduction - 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 - Module assessment - Summary Develop PostgreSQL solutions in Visual Studio Code with the PostgreSQL extension and GitHub Copilot - Introduction - 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 - Knowledge check - Summary1 jour690.00675.00675.00690.00690.00490.001200.00940.00690.00690.00990.00