Build AI Apps with Azure Database for PostgreSQL (AI-3019)

Welcome to the course "Build AI Apps with Azure Database for PostgreSQL," designed for companies looking to enhance their capabilities in integrating AI with databases. Whether you're part of a team or an individual seeking to upskill, this course will guide you in leveraging generative AI using Azure services to create more intelligent applications.

We begin the journey by helping you get started with generative AI in Azure Database for PostgreSQL. Here, you'll gain an understanding of generative AI language models and how the Azure AI extension can be utilized. You'll also explore different schemas, including Azure OpenAI, Azure Cognitive, and Azure Machine Learning, to broaden your knowledge of AI integration.

Next, the course enables you to implement semantic search in Azure Database for PostgreSQL. You'll learn about semantic search concepts and how to store vectors within the database. The lesson focuses on creating embeddings with the Azure AI extension and examines various use cases for semantic search, offering practical insights into its applications.

Moving forward, you'll learn how to summarize data effectively using Azure AI Services along with Azure Database for PostgreSQL. This lesson covers both extractive and abstractive summarization techniques, equipping you with the skills to condense information meaningfully and concisely.

The course also covers sentiment analysis and opinion mining with Azure Database for PostgreSQL. By exploring sentiment analysis, you'll be able to evaluate emotional tones, while understanding opinion mining will allow you to gather more nuanced insights from database content.

In another lesson, you will focus on extracting valuable insights using Azure AI Language alongside Azure Database for PostgreSQL. You'll practice extracting key phrases, recognize named entities, and identify personally identifiable information (PII) entities, enhancing your ability to analyze and interpret data effectively.

You'll also explore the Azure AI Translator service to translate text with Azure AI Translator and Azure Database for PostgreSQL. This part of the course will teach you how to manage and translate data, expanding your database’s usability across different languages.

Finally, the course guides you through using Azure Machine Learning for inferencing from Azure Database for PostgreSQL. You'll explore the Azure Machine Learning platform and learn to invoke its models, enabling you to draw inferences directly from your database operations.

By the course's end, you will have the tools to build sophisticated AI-driven applications using Azure Database for PostgreSQL. You'll be equipped with the ability to harness AI for advanced database operations, ensuring your team or organization can tackle future challenges with cutting-edge technology.

1. Get started with generative AI in Azure Database for PostgreSQL
   1. Understand generative AI language models
   2. Describe the Azure AI extension
   3. Explore the Azure OpenAI schema
   4. Review the Azure Cognitive schema
   5. Examine the Azure Machine Learning schema
2. Enable semantic search in Azure Database for PostgreSQL
   1. Understand semantic search
   2. Store vectors in Azure Database for PostgreSQL
   3. Create embeddings with the Azure AI extension
   4. Explore semantic search use cases
3. Summarize data with Azure AI Services and Azure Database for PostgreSQL
   1. Explain extractive summarization
   2. Explore abstractive summarization
4. Perform sentiment analysis and opinion mining with Azure Database for PostgreSQL
   1. Explore sentiment analysis
   2. Describe opinion mining
5. Extract insights using Azure AI Language and Azure Database for PostgreSQL
   1. Extract key phrases
   2. Recognize entities
   3. Recognize personally identifiable information (PII) entities
6. Translate text with Azure AI Translator and Azure Database for PostgreSQL
   1. Explore the Azure AI Translator Service
   2. Translate data in Azure Database for PostgreSQL
7. Use Azure Machine Learning for inferencing from Azure Database for PostgreSQL
   1. Explore Azure Machine Learning
   2. Invoke Azure Machine Learning models

Each student receives a comprehensive set of materials, including course notes and all class examples.

Experience in the following is required for this PostgreSQL class: