Explore digital courses

A Learning Plan pulls together training content for a particular role or solution, and organizes those assets from foundational to advanced. Use Learning Plans as a starting point to discover training that matters to you. This Learning Plan is…

The Official Practice Question Set: AWS Certified Data Engineer - Associate (DEA-C01) consists of 20 questions. This question set aligns with the DEA-C01 version of the exam and exam guide. If you are looking for an assessment that is the same…

Use Power BI to understand where your money is being spent in Azure so you can help your organization to optimize its costs.

Units in this learning path:

• Introduction
• Analyze Costs Power Bi
• Hybrid Benefits Power Bi
• Reservations Power Bi
• Data Connector Power Bi
• Knowledge Check
• Summary

Products: Azure, Azure Cost Management

Roles: Administrator, Developer

Level: Beginner

Subjects: Finance Accounting, Data Analytics

Duration: 27 minutes

Performance optimization, also known as performance tuning, involves making changes to the current state of the semantic model so that it runs more efficiently. Essentially, when your semantic model is optimized, it performs better.

Units in this learning path:

• 1 Introduction
• 1a Optimization Techniques
• 2 Performance
• 3 Variables
• 4 Reduce Cardinality
• 5 Directquery Models
• 6 Aggregations
• 7 Check
• 8 Summary

Products: Power Bi, Power Platform

Roles: Data Analyst

Level: Intermediate

Subjects: Data Modeling

Duration: 69 minutes

Optimize Azure SQL Database performance by choosing the right service tier and managing concurrency with isolation levels. Analyze queries with execution plans and DMVs. Use Query Store for plan management and resolve blocking and deadlocks.

Units in this learning path:

• Introduction
• Recommend Database Configurations
• Preserve Data Integrity Isolation Levels
• Evaluate Query Performance
• Monitor Tune Queries Query Store
• Identify Resolve Blocking Deadlocks
• Exercise Optimize Query Performance
• Knowledge Check
• Summary

Products: Azure, Azure SQL Database, SQL Server

Roles: Database Administrator, Developer, Data Engineer

Level: Intermediate

Subjects: Databases, Cloud Computing

Duration: 104 minutes

Optimize query and operation performance in Azure Cosmos DB for NoSQL

Modules in this learning path:

• Choose Indexes Azure Cosmos Db SQL API
• Measure Index Azure Cosmos Db SQL API
• Implement Integrated Cache

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 114 minutes

Learn how to optimize query performance and reduce costs for Azure Cosmos DB for NoSQL workloads by configuring indexes and selecting consistency levels.

Units in this learning path:

• Introduction
• Understand Indexes Cosmos Db
• Configure Range Composite Indexes
• Tune Vector Indexes Embeddings
• Reduce Ru Costs Strategic Indexing
• Choose Consistency Levels Performance
• Exercise Optimize Query Performance
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases, Artificial Intelligence

Duration: 96 minutes

Optimize query performance in Azure SQL

Modules in this learning path:

• Explore Query Performance Optimization
• Explore Performance Based Design
• Evaluate Performance Improvements

Products: Azure SQL Database, SQL Server

Roles: Data Analyst, Data Engineer, Database Administrator, Developer

Level: Intermediate

Subjects: Databases

Duration: 236 minutes

Optimize query performance in Azure DocumentDB by building effective indexing strategies. Create single-field, compound, multi-key, and specialized indexes. To maintain performance at scale, analyze query execution with the explain() command and monitor index health.

Units in this learning path:

• Introduction
• Understand How Indexes Work
• Create Single Field Compound Indexes
• Work Multi Key Specialized Index
• Analyze Query Performance Explain
• Monitor Optimize Indexes
• Exercise Build Indexing Strategy
• Knowledge Check
• Summary

Products: Azure Documentdb

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 83 minutes

Diagnose and fix semantic model and report performance issues. Use Performance analyzer to identify bottlenecks, optimize DAX calculations, reduce cardinality, and implement aggregations to improve query speed.

Units in this learning path:

• Introduction
• Performance Analyzer
• Optimize Dax
• Reduce Cardinality
• Implement Aggregations
• Troubleshoot
• Exercise
• Knowledge Check
• Summary

Products: Fabric, Power Bi

Roles: Data Analyst

Level: Advanced

Subjects: Data Analytics, Data Modeling

Duration: 78 minutes

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