PostgreSQL Exercises

Module Lab
Explore PostgreSQL architecture Explore Azure Database for PostgreSQL
Understand client-server communication in PostgreSQL Explore PostgreSQL with client tools
Understand PostgreSQL query processing Execute the EXPLAIN statement
Secure Azure Database for PostgreSQL Configure permissions in Azure Database for PostgreSQL
Procedures and functions in PostgreSQL Create a stored procedure in Azure Database for PostgreSQL
Understand write-ahead logging List table changes with logical decoding
Configure and manage Azure Database for PostgreSQL Configure system parameters and explore metadata with system catalogs and views
Understand concurrency in PostgreSQL Understand locking
Tune queries in Azure Database for PostgreSQL Assess query performance using Query Store
Migrate to Azure Database for PostgreSQL Flexible Server Offline PostgreSQL Database Migration
Migrate to Azure Database for PostgreSQL Flexible Server Online PostgreSQL Database Migration
Explore Generative AI with Azure Database for PostgreSQL Explore the Azure AI Extension
Enable Semantic Search with Azure Database for PostgreSQL Generate vector embeddings with Azure OpenAI
Enable Semantic Search with Azure Database for PostgreSQL Create a search function for a recommendation system
Integrate AI Services to enrich your applications with intelligent features in Azure Database for PostgreSQL Use Azure AI services with Azure Database for PostgreSQL
Build RAG applications with Azure Database for PostgreSQL Build RAG Applications with Azure Database for PostgreSQL and Python
Summarize data using Azure AI Services and Azure Database for PostgreSQL Perform Extractive and Abstractive Summarization
Integrate AI Services to enrich your applications with intelligent features in Azure Database for PostgreSQL Perform Inference using Azure Machine Learning
Perform Sentiment Analysis and Opinion Mining using Azure Database for PostgreSQL Analyze Sentiment
Build RAG applications with Azure Database for PostgreSQL Implement GraphRAG with Azure Database for PostgreSQL
Implement generative AI agents with Azure Database for PostgreSQL Build and test an AI agent with Foundry Agent Service and PostgreSQL
Extract insights using the Azure AI Language service with Azure Database for PostgreSQL Extract insights using the Azure AI Language
Develop PostgreSQL solutions in Visual Studio Code with the PostgreSQL extension and GitHub Copilot Explore the Visual Studio Code PostgreSQL Extension and GitHub Copilot
Translate Text using the Azure AI Translator and Azure Database for PostgreSQL Translate Text with Azure AI Translator
Use Azure Machine Learning Inferencing with Azure Database for PostgreSQL Perform Inference using Azure Machine Learning