Optimize query performance in Azure SQL
- Offered byMicrosoft
Optimize query performance in Azure SQL at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Optimize query performance in Azure SQL at Microsoft Course details
- Explore query performance optimization
- Explore performance-based design
- Evaluate performance improvements
- Analyze individual query performance and determine where improvements can be made
- Explore performance-related Dynamic Management Objects
- Investigate how indexes and database design affect queries
- This learning path helps prepare you for Exam DP-300: Administering Microsoft Azure SQL Solutions
- Explore normalization for relational databases. Investigate the impact of proper datatype usage
Optimize query performance in Azure SQL at Microsoft Curriculum
Explore query performance optimization
Introduction
Understand query plans
Explain estimated and actual query plans
Describe dynamic management views and functions
Explore Query Store
Identify problematic query plans
Describe blocking and locking
Exercise: Identify and resolve blocking issues
Knowledge check
Summary
Explore performance-based design
Introduction
Describe normalization
Choose appropriate data types
Design indexes
Exercise: Identify database design issues
Knowledge check
Summary
Evaluate performance improvements
Introduction
Describe wait statistics
Tune and maintain indexes
Understand query hints
Exercise: Isolate problem areas in poorly performing queries
Knowledge check
Summary
Optimize query performance in Azure SQL at Microsoft Entry Requirements
- Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-basedAbility to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.Basic understanding of structure and usage of SQL Server indexesBasic understanding of relational database concepts
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?