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 Training Objectives

• Develop AI Applications: Participants will learn how to build AI-powered applications using the integration of Azure AI and Azure Machine Learning Services with Azure Database for PostgreSQL.
  
• Implement Semantic Search: This course teaches you how to enable semantic search, using embedding 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: The course explores how to perform sentiment analysis and opinion mining to extract valuable insights from textual data.
  
• Information Extraction: Participants will learn how 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 how to directly call these models 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
• 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