Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a reward of 150 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

MySQL Query Optimization and Performance Tuning

MySQL Query Optimization and Performance Tuning

1425
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Intermediate
Login to earn 150Edvicer reward coin150 coins = INR 150

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a reward of 150 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

Why should you choose this course?

Description

This course focuses on Query Optimization and Performance Tuning of MySQL.

Syllabus

Introduction
Introduction
Prerequisite
Overheard
Understanding Data Needs
Demo: Setup
Demo: Best Practices for Data Access
Demo: Why SELECT Star (*) is Bad Idea
Summary in Sixty Seconds
Introduction
Execution Path of a Query
Client Protocols
Query Cache
Parser
Preprocessor
Query Optimizer
Query Optimizer Responsibilities
Query Optimizer Limitations
Query Execution Engine and Storage
Returning Result to Client
Additional Notes on Query Optimizer
Maximizing Query Optimizer Performance
Understanding Query States
Demo: Show Full Processlist
Understanding Explain Command
Demo: Explain Command
Demo: Explain Extended Command
Summary in Sixty Seconds
Introduction
Demo: Index Used for SELECT clause
Demo: One Complex Query vs Multiple Simple Queries
Demo: One Complex Query vs Multiple Simple Queries - Part 2
Demo: One Complex Query vs Multiple Simple Queries with Index
Demo: Table Order in Join Clause - INNER JOIN
Demo: Table Order in Join Clause - OUTER JOIN
Demo: Most Optimal Choice - Subquery vs Exists vs Joins
Demo: Most Optimal Choice - Subquery vs Exists vs Joins - Part 2
Demo: Tuning Aggregate Function
Demo: Optimizing Group By Clause
Demo: Optimizing Paging with LIMIT Clause
Demo: Impact on Performance of UNION and UNION ALL
Demo: Index and Not Equal to Operator
Summary in Sixty Seconds
Best Practices

What others say about this course

Write your review of MySQL Query Optimization and Performance Tuning

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer