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 designed for developers with experience in PostgreSQL databases and a general understanding 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's ideal for professionals looking to develop advanced AI solutions using tools such as semantic analysis, opinion mining, and text translation.

Objectives of the AI-3019 training

• Develop AI applications: Participants will learn to create AI-powered applications using the integration of Azure AI and Azure Machine Learning Services with Azure Database for PostgreSQL.
  
• Implement semantic search: The course teaches how to enable semantic search, using insertion vectors and the Azure AI extension to generate, store, and query data with semantic search.
  
• Summarizing data: Students will learn generative summarization techniques to condense complex content into concise summaries using Azure AI services.
  
• Sentiment Analysis and Opinion Mining: This course explores how to perform sentiment analysis and opinion mining to extract valuable insights from textual data.
  
• Information Extraction: Participants will learn to use Azure AI language tools for key phrase extraction, entity recognition, and redaction of personally identifiable information.
  
• Text translation: The course guides students in translating textual data using the Azure AI Translator service.
  
• Inference with Azure Machine Learning: Students will learn how to train and deploy machine learning models and call these models directly from Azure Database for PostgreSQL.

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
• Azure Machine Learning Schema Review
• Exercise: Exploring the Azure AI extension

Module 2 Enabling semantic search in Azure Database for PostgreSQL

• Description of the semantic search
• Vector storage in Azure Database for PostgreSQL
• Creating inserts with the Azure AI extension
• Exercise: Generating vector insets with Azure OpenAI
• Exploring semantic search use cases
• Exercise: Creating a search function for a recommendation system

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

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

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

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

Module 5 Information Extraction using Azure AI and Azure

• Database for PostgreSQL
• Key phrase extraction
• Recognition of entities
• 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 will learn how to build AI applications with Azure Database for PostgreSQL.

Applied Skills: Explore all credentials in one guide