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 metedata 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
Summarize data using Azure AI Services and Azure Database for PostgreSQL Perform Extractive and Abstractive Summarization
Perform Sentiment Analysis and Opinion Mining using Azure Database for PostgreSQL Analyze Sentiment
Extract insights using the Azure AI Language service with Azure Database for PostgreSQL Extract insights using the Azure AI Language
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