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

AI-3019 Course: 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 applications.

Intermediate - Developer - Azure Database for PostgreSQL - Azure AI Services

Course aimed at

This course is aimed at developers with experience in PostgreSQL databases and general knowledge of artificial intelligence and machine learning. The focus is on building AI applications by integrating Azure AI and Azure Machine Learning with Azure Database for PostgreSQL. It is ideal for professionals looking to develop advanced AI solutions using tools for semantic analysis, opinion mining, text translation, and more.

AI-3019 Course Content

Module 1 Introduction to generative artificial intelligence in Azure Database for PostgreSQL

• Description of generative AI language models
• Azure AI Extension Description
• Exploring the Azure OpenAI Schema
• Azure Cognitive Schema Review
• Examining the Azure Machine Learning Schema
• Exercise: Exploring the Azure AI Extension

Module 2: Enabling Semantic Search in Azure Database for PostgreSQL

• Description of semantic search
• Storing vectors in Azure Database for PostgreSQL
• Creating embeds with the Azure AI extension
• Exercise: Generating vector embeddings with Azure OpenAI
• Exploring semantic search use cases
• Exercise: Creating a search function for a recommendation system

Module 3 Data Summarization with Azure AI Services and Azure Database for PostgreSQL

• Explanation of the summary by extraction
• Exploring the abstract summary
• Exercise: Making summaries by extraction and abstracts

Module 4: Performing Sentiment Analysis and Sentiment Mining with Azure Database for PostgreSQL

• Exploring Sentiment Analysis
• Description of opinion mining
• Exercise: Sentiment Analysis

Module 5 Information Extraction Using Azure AI Language and Azure

• Database for PostgreSQL
• Keyphrase Extraction
• Entity recognition
• Recognition of personally identifiable information (PII) entities
• Exercise: Extracting information using the Azure AI Language service

Module 6 Text Translation with Azure AI Translator and Azure Database for PostgreSQL

• Exploring the Azure AI Translator Service
• Data translation in Azure Database for PostgreSQL
• Exercise: Text Translation

Module 7: Using Azure Machine Learning for Inference from Azure Database for PostgreSQL

• Exploring Azure Machine Learning
• Invoking Azure Machine Learning models
• Exercise: Performing Inference Using Azure Machine Learning

Prerequisites

Experience working with PostgreSQL databases, writing SQL queries, and a general understanding of artificial intelligence and machine learning concepts are recommended.

Language

• Course: English / Spanish
  

Microsoft Applied Skills

This course is part of the Microsoft Applied Skills Credentials.

Earn this Microsoft Applied Skills credential. In this course, you'll learn how to build AI applications with Azure Database for PostgreSQL.

Applied Skills: Explore all credentials in one guide