Tutorial that teaches simple to complex mysql queries

Question

I've used sql server previously, and want to master mysql.

Is there a tutorial that goes into more of the advanced type queries? It would be great if it was starting from simple and then made its way to teaching advanced queries and query optimizations etc.

If there is a book then please mention that.

thanks!

Answer 1

Here's a list of common queries, this might help:
http://www.artfulsoftware.com/infotree/queries.php?&bw=1272

Answer 2

Have a look at O'Reilly's SQL Cookbook. I own a copy of this and has been pretty handy.