Optimize query performance in SQL Server
- Offered byMicrosoft
Optimize query performance in SQL Server at Microsoft Overview
Optimize query performance in SQL Server
at Microsoft
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 SQL Server at Microsoft Highlights
Optimize query performance in SQL Server
at Microsoft
- Evaluate possible changes to indexes
- Explore normalization for relational databases
- Know the impact of changes to queries and indexes
Optimize query performance in SQL Server at Microsoft Course details
Optimize query performance in SQL Server
at Microsoft
Skills you will learn
What are the course deliverables?
- Describe SQL Server query plans
- Evaluate performance improvements
- Explore performance-based design
More about this course
- Analyze individual query performance and determine where improvements can be made
- Explore performance-related Dynamic Management Objects
- Read and understand various forms of execution plans
- Explore relevant Dynamic Management Objects
Optimize query performance in SQL Server at Microsoft Curriculum
Optimize query performance in SQL Server
at Microsoft
MODULE: 1
Describe types of query plans
Explain estimated and actual query plans
Identify problematic query plans
Exercise: Identify issues with a database design
MODULE: 2
Describe dynamic management views and functions
Describe wait statistics
Tune indexes
Maintain indexes
Exercise: Isolate problem areas in poorly performing queries in a SQL Database
MODULE: 3
Describe normalization
Choose appropriate data types
Design indexes
Describe data compression
Optimize query performance in SQL Server at Microsoft Entry Requirements
Optimize query performance in SQL Server
at Microsoft
Eligibility criteria
- Prerequisites: Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
- Basic understanding of relational database concepts , structure and usage of SQL Server indexes
Conditional Offer
- Not mentioned
Other courses offered by Microsoft
View Other 1171 Courses
Optimize query performance in SQL Server
at Microsoft
Student Forum
Anything you would want to ask experts?