Explore digital courses

Azure Database for PostgreSQL uses vacuum and autovacuum to remove rows that have been marked as soft-deleted after an update or deletion.

Units in this learning path:

• Introduction
• Explain Purpose Vacuum Autovacuum
• Configure Autovacuum Server Parameters
• Exercise Configure Autovacuum Server Parameters
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator

Level: Intermediate

Subjects: Databases

Duration: 24 minutes

Tune pgvector configuration, select vector indexes, design efficient data layouts, and scale Azure Database for PostgreSQL for high-performance AI workloads.

Units in this learning path:

• Introduction
• Tune Postgresql Pgvector
• Choose Configure Vector Indexes
• Optimize Data Layout
• Scale High Volume Workloads
• Connection Optimization
• Exercise Optimize Vector Search
• Knowledge Check
• Summary

Products: Azure Database Postgresql

Roles: Developer

Level: Intermediate

Subjects: Databases, Artificial Intelligence

Duration: 111 minutes

Orchestrate data movement and transformation in Azure Data Factory

Units in this learning path:

• Introduction
• Understand Control Flow
• Working Pipelines
• Debug Pipelines
• Adding Parameters Components
• Executing Packages
• Knowledge Check
• Summary

Products: Azure Data Factory

Roles: Data Engineer, Data Scientist

Level: Intermediate

Subjects: Data Analytics

Duration: 38 minutes

Learn to control the size and order of query results in PostgreSQL with the LIMIT, OFFSET, and ORDER BY clauses. Master pagination, sorting, and optimizing performance with these essential SQL tools.

Units in this learning path:

• Introduction
• Sample Database Overview
• Order by
• Limit Offset
• Summary

Products: Azure Database Postgresql

Roles: Database Administrator, Developer

Level: Beginner

Subjects: Databases

Duration: 12 minutes

Advanced analytics helps you gain deeper insights into your data, identify trends, and make data-driven decisions. Power BI provides a variety of tools and features to help you analyze your data effectively.

Units in this learning path:

• 1 Introduction
• 2 Statistical Summary
• 3 Visuals
• 4 Group Data
• 5 Clustering Techniques
• 6 Time Series Analysis
• 7 Analyze Feature
• What If Parameters
• Use Specialized Visuals
• Lab
• 11 Check
• 12 Summary

Products: Power Bi

Roles: Data Analyst

Level: Intermediate

Subjects: Data Analytics, Data Visualization

Duration: 67 minutes

Perform code-free transformation at scale with Azure Data Factory

Units in this learning path:

• Introduction
• Explain Transformation Methods
• Describe Transformation Types
• Use Mapping Data Flow
• Debug Mapping Data Flow
• Use Wrangling Data
• Use Compute Transformations
• Integrate Ssis Packages Within
• Knowledge Check
• Summary

Products: Azure Data Factory

Roles: Data Engineer, Data Scientist

Level: Beginner

Subjects: Data Analytics

Duration: 58 minutes

Perform operations on multiple items in single logical units of work.

Units in this learning path:

• Introduction
• Create Transactional Batch Sdk
• Reviewing Batch Operation Results Sdk
• Exercise Batch Multiple Point Operations Together Sdk
• Implement Optimistic Concurrency Control
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 37 minutes

With some Power Apps canvas apps, a form isn't the solution. This module focuses on how to perform custom updates when your data isn't in a form.

Units in this learning path:

• 1 More Than Forms
• 2 Patch Function
• 3 Deleting Records
• 4a Exercise Patch
• 4 Knowledge Check
• 5 Summary

Products: Power Platform, Power Apps

Roles: Functional Consultant, Maker

Level: Intermediate

Subjects: Data Management

Duration: 38 minutes

Deploying an Amazon DocumentDB cluster to support your workloads is just the beginning. Performance tuning your database is essential for every workload to help ensure that you achieve and maintain the efficiency required to support your…

Plan and implement Azure Cosmos DB for NoSQL

Modules in this learning path:

• Plan Resource Requirements
• Configure Azure Cosmos Db SQL API
• Moving Data Into Out of Azure Cosmos Db SQL API

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 111 minutes

Plan and implement data platform resources

Modules in this learning path:

• Deploy Iaas Solutions with Azure SQL
• Deploy Paas Solutions with Azure SQL
• Migrate SQL Workloads Azure SQL Databases
• Migrate SQL Workloads Azure Managed Instances

Products: Azure, Azure SQL Database, SQL Server

Roles: Data Engineer, Database Administrator

Level: Intermediate

Subjects: Data Engineering, Data Management

Duration: 322 minutes

Learn how to manage your Microsoft Power Platform environment

Units in this learning path:

• 1 Introduction
• 2 Prerequisites
• 3 Risk Assessment
• 4 Policy Communication
• 5 Plan Environment
• 6 Policies
• 7 Exercise
• 8 Check
• 9 Summary

Products: Power Automate, Power Platform, Power Apps

Roles: Administrator, Functional Consultant

Level: Intermediate

Subjects: Data Management

Duration: 58 minutes