Explore query performance optimization
|
Read and understand various forms of execution plans. Compare estimated vs actual plans. Learn how and why plans are generated. Understand the purpose and benefits of the Query Store.
Generate and save execution plans, Compare the different types of execution plans, Understand how and why query plans are generated, Explain the purpose and benefits of the Query Store, Investigate the available reports and data in the Query Store
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 structure and usage of SQL Server indexes.
Basic understanding of relational database concepts.
User Reviews
Be the first to review “Explore query performance optimization”
Related Products
SQL 2014 Developer: Partitions, Queries and XML
This Free Online Course Includes: 4-5 Hours of Learning CPD Accreditation Final Assessment
Introduction to Database Concepts
This Free Online Course Includes: 1.5-3 Hours of Learning CPD Accreditation Final Assessment
Diploma in Management Information Systems – An Introduction
This Free Online Course Includes: 10-15 Hours of Learning CPD Accreditation Final Assessment
Cloud Computing – Database Technologies and Services
This Free Online Course Includes: 1.5-3 Hours of Learning CPD Accreditation Final Assessment
Diploma in SQL 2014 Developer : T-SQL and .NET Code
This Free Online Course Includes: 6-10 Hours of Learning CPD Accreditation Final Assessment
Diploma in Application Development Using PHP and MySQL
This Free Online Course Includes: 6-10 Hours of Learning CPD Accreditation Final Assessment
There are no reviews yet.