Simple to advanced SQL queries examples to practice MySQL query performance optimization [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_JAVA技巧

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 4 years ago.

Improve this question

Looking for websites/books SQL queries from simple to advance (queries optimization and performanance etc.. ) questions and examples to exam for MySQL Job.

Thanks

---

For simple material coverage the online MySQL docs or the MySQL 5 Certification Study Guide book are pretty good. Can practice on a sample database like Employee (4 million records in total) from MySQL.

For advanced subjects (performance optimization) I suggest High Performance MySQL book. Chapter 4 of this book deals with Query Performance Optimization, with examples using Sakila database from MySQL as well.