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

This course 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.

This course is for PostgreSQL developers interested in learning more about creating AI driven applications for Azure Database for PostgreSQL.

Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of AI and ML concepts

After completing this course, 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
• Install and explore the Azure Ai extension in an Azure Database for PostgreSQL - Flexible Server database
• Examine the concepts of semantic search & embedding vectors
• Install and explore the vector and Azure Ai extensions in an Azure Database for PostgreSQL - Flexible Server database
• 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.
• Describe opinion mining techniques to identify sentiments related to specific attributes.
• Apply sentiment analysis to user reviews in a PostgreSQL database using the Azure Ai extension.
• Examine the concepts of key phrase extraction, entity recognition, and PII (personally identifiable information recognition) recognition.
• Install the Azure Ai extension in an Azure Database for PostgreSQL - Flexible Server database, and use it to extract key phrases, recognize entities in text, and redact PII.
• Learn how to translate documents using the Azure AI Translator.
• Learn how the Azure AI extension enables seamless interaction between Azure Database for PostgreSQL - Flexible Server and Azure AI Translator.
• Understand one way to translate documents automatically as part of record insertion.
• Learn how to train and deploy an Azure Machine Learning model using automated machine learning.
• Learn how to invoke deployed Azure Machine Learning models from Azure Database for PostgreSQL - Flexible Server.
• Learn how to generate predictions for each row in an Azure Database for PostgreSQL - Flexible Server table.

Course Subjects

• Get started with generative AI in Azure Database for PostgreSQL
• Enable semantic search in Azure Database for PostgreSQL
• Summarise data with Azure AI Services and Azure database for PostgreSQL
• Perform sentiment analysis and opinion mining with Azure Database for PostgreSQL
• Extract insights using Azure AI Language and Azure Database for PostgreSQL
• Translate Text with Azure AI Translator and Azure Database for PostgreSQL
• Use Azure Machine Learning for inferencing from Azure Database for PostgreSQL