Explore digital courses

PostgreSQL is a client-server system, which allows many clients to connect to a central server. In this module you learn how PostgreSQL manages connections from clients, and looking at some common PostgreSQL client tools.

Units in this learning path:

• Introduction
• Understand Connection Handling
• Understand Postgresql Client Tools
• Exercise Explore Client Tools
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 28 minutes

Learn about concurrency in MySQL, including how to limit the number of connections, and when to use thread pools.

Units in this learning path:

• Introduction
• Describe Thread Concurrency
• Understand When to Use Thread Pools
• Describe Isolation Levels
• Understand Lock
• Exercise Understand Lock
• Knowledge Check
• Summary

Products: Azure Database Mysql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 38 minutes

Azure Database for PostgreSQL is a multi-user relational database solution. The ability to support many concurrent users enables PostgreSQL databases to scale out and enable applications that support many users and locations at the same time. The increase in users brings a risk of conflicts. For this reason, it's important to understand the concurrency systems that are in place in Azure Database for PostgreSQL to manage concurrency and conflicts. In this module, we look at both isolation levels and locking in Azure Database for PostgreSQL.

Units in this learning path:

• Introduction
• Understand Multi Version Concurrency Control Snapshots
• Understand Isolation Levels
• Understand Lock
• Exercise Understand Locking
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 33 minutes

Data is key to most business operations and services and an understanding of data is essential in many roles. This learning path covers data concepts, data analytics, and data roles, services, and products.

Modules in this learning path:

• Get Started Data Concepts
• Get Started Data Analytics
• Understand Data Roles Services Products

Products: Office Excel, SQL Server

Roles: Business Owner, Business User, K 12 Educator, Student

Level: Beginner

Subjects: Databases

Duration: 94 minutes

Data is so widespread that many services and roles are needed to manage the data of an organization. This module covers types of data products, Azure data services, and the roles of data professionals.

Units in this learning path:

• Introduction
• Describe Data Product Categories
• Azure Data Services
• Data Professionals
• Knowledge Check
• Summary

Products: Office Excel, SQL Server

Roles: Business Owner, Business User, K 12 Educator, Student

Level: Beginner

Subjects: Databases

Duration: 21 minutes

Learn how Microsoft Purview Unified Catalog helps organizations overcome fragmented data estates by centralizing assets, adding business context, and applying consistent governance so teams can trust and use data with confidence.

Units in this learning path:

• Introduction
• Fragmented Data Challenge
• Address Fragmentation Challenge
• Elements Unified Catalog
• Roles Personas Unified Catalog
• Responsible AI Unified Catalog
• From Classic Unified Catalog
• Unified Catalog Importance
• Knowledge Check
• Summary

Products: Microsoft Purview

Roles: Data Engineer, Data Analyst

Level: Intermediate

Subjects: Data Management, Compliance

Duration: 34 minutes

This module helps users understand the hybrid data platform capabilities of SQL Server 2025.

Units in this learning path:

• Introduction
• Business Continuity with Azure SQL Managed Instance
• Azure Arc Enabled
• Near Real Time Analytics Synapse Link for SQL
• Azure Active Directory Azure Ad Authentication
• Knowledge Check
• Summary

Products: SQL Server

Roles: Database Administrator, Data Engineer, Administrator

Level: Beginner

Subjects: Databases

Duration: 58 minutes

Understand retention in Microsoft Purview

Units in this learning path:

• Introduction
• Retention Overview
• Retention Labels Retention Policies
• Decide Apply Retention
• Knowledge Check
• Summary

Products: M365, Microsoft Purview

Roles: Administrator, Auditor

Level: Intermediate

Subjects: Data Management

Duration: 24 minutes

Learn about MySQL’s pluggable storage engine model, and learn about common storage engines, and those supported by Azure Database for MySQL.

Units in this learning path:

• Introduction
• Describe Common Storage Engines
• Specify Storage Engine
• Understand Supported Storage Engines
• Explain Tablespaces
• Optimize Write Ahead Log
• Exercise Compare Options
• Knowledge Check
• Summary

Products: Azure Database Mysql, Azure Storage

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 38 minutes

Azure Database for PostgreSQL is an ACID compliant database service. Write-ahead logging ensures changes are both atomic and durable (the A and D in ACID). Changes are first written to the log before they're committed to the database. In this module, you learn how Azure Database for PostgreSQL implements write-ahead logging, and how the log can be used for replication and logical decoding.

Units in this learning path:

• Introduction
• Understand Write Ahead Logging
• Understand Replication Logical Decode
• Exercise List Table Changes Logical Decode
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 46 minutes

Explore Data Cloud—from setup and administration to segmenting and acting on your data insights. This trail will get you ready to become a certified Data Cloud Consultant. You will gain skills in data science and visualization, digital marketing, query languages, business strategy, automation, and more.

Learn about creating an Azure Data Lake Storage account and uploading data to Data Lake Storage Gen 2 through the Azure Storage Explorer.

Units in this learning path:

• Introduction
• Create Azure Data Lake
• Upload Data Using Explorer
• Summary

Products: Azure

Roles: Data Engineer

Level: Beginner

Subjects: Data Storage

Duration: 35 minutes