Explore digital courses

This credential earner has the advanced skills to design, configure, secure, and troubleshoot wired and wireless networks. The individual has the technical knowledge and practical skills to select network services, technologies, internet protocols, typologies, tools, best practices, and troubleshooting techniques to manage and maintain a network. The earner has practiced essential workplace skills.

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 data warehouse query performance in Azure Synapse Analytics

Units in this learning path:

• Introduction
• Understand Performance Issues Related to Tables
• Exercise Understand Performance Issues Related to Tables
• Understand Table Distribution Design
• Use Indexes to Improve
• Understand Query Plans
• Exercise Use Table Distribution Indexes to Improve Performance
• Create Statistics to Improve
• Improve with Materialized Views
• Use Read Committed Snapshot for Data Consistency
• Optimize Common Queries with Result Set Caching
• Exercise See How Statistics Affects Query Plan
• Knowledge Check
• Summary

Products: Azure Synapse Analytics

Roles: Data Engineer

Level: Intermediate

Subjects: Data Storage

Duration: 97 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

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