Explore digital courses

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

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