Overview
This learning path 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.
Skills Covered
- Get started with generative AI in Azure Database for PostgreSQL
- Enable semantic search in Azure Database for PostgreSQL
- Summarize 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
Who Should Attend
- Developer
Course Curriculum
Prerequisites
Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of AI and ML concepts.
Download Course Syllabus
Course Modules
This module explores how to effectively use Azure Database for PostgreSQL – Flexible Server and the Azure AI extension to develop powerful Generative AI applications.
Learning objectives
- Examine the concepts of generative AI and large language models and explore how they can be used to build rich AI applications.
- Evaluate the capabilities of azure_ai extension for PostgreSQL.
- Install and explore the azure_ai extension in an Azure Database for PostgreSQL – Flexible Server database.
Prerequisites
Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of Generative AI concepts.
This module explores semantic search, embedding vectors, vector similarity, and using Azure Database for PostgreSQL – Flexible Server with PostgreSQL Vector and Azure AI extensions to generate, store, and query rows with semantic search.
Learning objectives
- Examine the concepts of semantic search & embedding vectors.
- Understand the difference between lexical search & semantic search.
- Evaluate the capabilities provided by the
azure_aiextension for PostgreSQL. - Install and explore the
vectorandazure_aiextensions in an Azure Database for PostgreSQL – Flexible Server database.
Prerequisites
Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and standard lexical search.
This module will examine how Azure AI Services and the Azure AI extension for Azure Database for PostgreSQL – Flexible Server enable Generative AI summarization techniques for condensing complex content into concise summaries.
Learning objectives
- Evaluate the summarization techniques available through Azure AI Services and the azure_ai extension.
- Examine the differences between extractive, abstractive, and query-focused summarization.
- Apply Generative AI summarization techniques to data in a PostgreSQL database to gain practical experience using Azure AI Services and the azure_ai extension for summarization.
Prerequisites
Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of Generative AI concepts.
This module will explore how Azure AI Services and the Azure AI extension for Azure Database for PostgreSQL – Flexible Server enable sentiment analysis and opinion mining to extract valuable insights from textual data.
Learning objectives
- Explore the fundamentals of sentiment analysis and how it can be leveraged to gain insights into user sentiments and emotions.
- 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.
Prerequisites
Before starting this module, you should have experience working with PostgreSQL databases, writing SQL queries, and a general understanding of Generative AI concepts.
This module covers Azure AI Language tools including key phrase extraction, entity recognition, personally identifiable information recognition and redaction, and using Azure Database for PostgreSQL – Flexible Server with Azure AI to access these services.
Learning objectives
- Examine the concepts of key phrase extraction, entity recognition, and PII (personally identifiable information recognition) recognition.
- Understand the capabilities provided by the azure_ai extension for PostgreSQL to access Azure AI Language.
- Install the azure_ai extension in an Azure Database for PostgreSQL – Flexible Server database, and use it to extract key phrases, recognize entities in text, and redact PII.
Prerequisites
Before starting this module, you should have experience working with PostgreSQL databases and writing SQL queries.
This module guides you through translating textual data in Azure Database for PostgreSQL – Flexible Server using the Azure AI Translator service. You’ll load data into PostgreSQL and translate it into multiple languages.
Learning objectives
- 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.
Prerequisites
- Before starting this module, you should have experience working with the PL/pgSQL language.
This module guides you through training and deploying an Azure Machine Learning model using automated machine learning. Then, you’ll call the model directly from Azure Database for PostgreSQL – Flexible Server.
Learning objectives
- 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.
Prerequisites
Before starting this module, you should have experience working with the PL/pgSQL language. Some knowledge of machine learning topics and Azure Machine Learning would be beneficial but not mandatory.
Request More Information
Training Options
- VILT: Virtual Instructor-Led Training
- ILT: Instructor-Led Training
RM1,200.00Enroll Now
RM1,200.00Enroll Now
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Addressing the AI Skills Gap in Malaysia
The Artificial Intelligence (AI) surge across global industries has created immense potential for innovation and economic growth. For Malaysia, AI is pivotal in its ambition to become a digital-first economy. However, despite this goal, the country faces a significant AI skills gap—a shortfall in the number of skilled professionals equipped to meet the rising demands for AI expertise across various industries. This blog examines the causes, impact, and initiatives underway to bridge this gap, ensuring Malaysia remains competitive in the digital age.
AI Mastery Program: Learn AI with Microsoft in 2024
Artificial Intelligence (AI) has been one of the hottest topics in the tech industry for the past decade. With its rapid advancements and potential to impact our daily lives, learning AI has become a highly sought-after skill.
We are thrilled to announce the launch of our Microsoft AI Mastery Program in 2024, made possible through our partnership with Microsoft, a renowned leader in AI technology. This program is tailored for individuals and tech professionals passionate about acquiring and mastering the fundamental and advanced principles of AI.
Top AI Skills Malaysia Needs Today: Advance Your IT Career in 2024
In the quest for AI-driven innovation, Malaysia seeks sharp minds with the right IT skills. Data science, machine learning—these are the tools in high demand. This article examines the AI skills Malaysia needs, the industries driving this change, and how to develop these skills to enhance your career trajectory.
In-demand Cloud Technology Skills – Insights from Malaysia’s Job Market
As Malaysia accelerates its digital transformation journey, cloud technology has emerged as a critical component of the nation’s economic growth. The adoption of cloud services is driving innovation across various sectors, from finance to manufacturing, and creating a robust demand for skilled cloud professionals.
This article dives into the most in-demand cloud technology skills in Malaysia, backed by market data and insights from industry reports, and highlights the key roles that are shaping the future of cloud technology.
Master Your Cloud Career: Essential Azure Certifications for 2024
Targeting the most valuable Azure certifications for 2024? In the evolving landscape of cloud computing, Azure certifications stand out by offering professionals the leverage to thrive. This article presents a focused rundown of crucial Azure certifications, shining a light on their career-boosting effects and elucidating steps to get certified. No fluff – just actionable insights to empower your journey in the cloud.
The Future of Cloud Careers in Malaysia 2024
As Malaysia advances its digital economy, the demand for cloud professionals is growing rapidly. Cloud technology has become an essential part of the modern IT landscape, and businesses across various sectors are increasingly relying on cloud infrastructure to drive digital transformation.
This article explores the current state of cloud careers in Malaysia, key roles and career pathways, and emerging cloud trends that are shaping the future of cloud technology.
Top Microsoft Applied Skills Courses to Boost Your Career
Microsoft Applied Skills are scenario-based practical credentials that confirm your ability to tackle real-world challenges using Microsoft technologies.
In this article, we will dive into what these skills are, how they differ from traditional certifications, and the benefits they bring to your career. Expect insights on top courses, the assessment process, and tips for success.
Maximize Your Productivity with Microsoft Copilot: A Complete Guide
Microsoft Copilot is an AI assistant within Microsoft 365 apps like Word, Excel, and Teams. It automates tasks and offers smart insights to boost productivity. This guide shows what Microsoft Copilot is, how it works, and ways it can simplify your tasks.
