Data, Analytics & AI Category Banner Image

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

  • Length 1 day
  • Price  NZD 995 exc GST
Course overview
View dates &
book now
Register interest

Why study this course

This one-day 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 one-day course prepares you for an Applied Skills credential.
For more than 30 years, Microsoft's industry-recognised certifications have provided proof of world-class technical proficiency for in-demand job roles. In today’s ever-changing business environment, there are also times when you need verified project-specific skills. Microsoft Applied Skills is a new verifiable credential that validates that you have the targeted skills needed to implement critical projects aligned to business goals and objectives. Applied Skills gives you a new opportunity to put your skills centre-stage, empowering you to showcase what you can do and what you can bring to key projects in your organisation.

Request Course Information


What you’ll learn

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 summarisation.

  • Apply Generative AI summarisation techniques to data in a PostgreSQL database to gain practical experience using Azure AI Services and the azure_ai extension for summarisation.

  • 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, recognise 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.


Microsoft Solutions Partner - Cloud - Training Services Logo

Microsoft Azure at Lumify Work

Lumify Work has been delivering effective training across all Microsoft products for over 30 years. We are proud to be both Australia's and New Zealand’s first Microsoft Gold Learning Solutions Partner and the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers (MCTs) in ANZ. All Lumify Work Microsoft Azure courses follow Microsoft Official Curriculum (MOC) and are led by MCTs.


Who is the course for?

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


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


Prerequisites

You should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of AI and ML concepts.


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.


Request Course Information

Awaiting course schedule

If you would like to receive a notification when this course becomes available, enter your details below.

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.