SQL: Indexes & Query Performance Basics

Wishlist Share

About Course

Find out why some SQL queries take seconds and others take minutes. This course explains what indexes are, how they speed up searches, sorting and joins, what they cost, how to read a basic query plan with EXPLAIN, and simple habits for writing faster, kinder queries.

Tutwoo is an independent learning provider. This course is general skills training based on official documentation. It is not an accredited qualification. Software behaviour can change between versions, so check the official documentation for the version you use.

What Will You Learn?

  • Explain how an index works using the book-index analogy Create sensible single-column and multi-column indexes Recognise query patterns that stop indexes being used Use EXPLAIN to check how a database runs a query

Course Content

Course Lessons

  • What an index is
  • Choosing what to index
  • Writing index-friendly queries
  • Checking performance with EXPLAIN

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕