Build AI Apps with Azure Database for PostgreSQL

After completing this learning path, students will be able to:

• Examine the concepts of generative AI and large language models and explore how they can be used to build rich AI applications.
• Evaluate the capabilities of azure_ai extension for PostgreSQL.
• Install and explore the azure_ai extension in an Azure Database for PostgreSQL - Flexible Server database.
• Evaluate the capabilities provided by the azure_ai extension for PostgreSQL.
• Install and explore the vector and azure_ai extensions in an Azure Database for PostgreSQL - Flexible Server database.
• Evaluate the summarization techniques available through Azure AI Services and the azure_ai extension.
• Examine the differences between extractive, abstractive, and query-focused summarization.
• Apply Generative AI summarization techniques to data in a PostgreSQL database to gain practical experience using Azure AI Services and the azure_ai extension for summarization.

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

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

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
• Exercise - Generate vector embeddings with Azure OpenAI
• Explore semantic search use cases
• Exercise - Create a search function for a recommendation system

Summarize data with Azure AI Services and Azure database for PostgreSQL

• Explain extractive summarization
• Explore abstractive summarization
• Exercise - Perform extractive and abstractive summarization
• Knowledge check

Perform sentiment analysis and opinion mining with Azure Database for PostgreSQL

• Introduction
• Explore sentiment analysis
• Describe opinion mining
• Exercise-Analyze sentiment

Extract insights using Azure AI Language and Azure Database for PostgreSQL

• Introduction
• Extract key phrases
• Recognize entities
• Recognize personally identifiable information (PII) entities
• Exercise-Extract insights using the Azure AI Language service

Translate Text with Azure AI Translator and Azure Database for PostgreSQL

• Explore the Azure AI Translator Service
• Translate data in Azure Database for PostgreSQL
• Exercise-Translate text

Use Azure Machine Learning for inferencing from Azure Database for PostgreSQL

• Introduction
• Explore Azure Machine Learning
• Invoke Azure Machine Learning models
• Exercise-Perform inference using Azure Machine Learning