tags:

views:

1850

answers:

4

What is the best book for SQL, particularly MySQL?

+7  A: 

High Performance MySQL 2nd Ed. is the best MySQL specific book out there. Plenty of advanced information on database design and optimization, analysis and profiling, scaling and more.

For general SQL, have a look at Learning SQL by Oreilly, or just about any SQL tutorial on the web.

Eran Galperin
Yes, very much so, this is the best MySQL book that I've encountered by far.
hromanko
Yes, High perf. 2nd edition is good, but only if you are already very familiar with SQL and need tips to optimise your large databases.
MarkR
I marked your response as accepted answer, but I scanned through some of HP and it seemed way more advanced than what I am ready for, but I think learning SQL might be right for me.
John Isaacks
The link for the Learning SQL book points to the old edition. Here's the new link. http://oreilly.com/catalog/9780596520830/
zooropa
+2  A: 

For learning MySQL the database, a great book is MySQL Press's MySQL Tutorial.

A good book for learning Structured Query Language is A Guide to SQL. It's a textbook and working through the end-of-chapter material is important to learning with this book.

There are other good books on SQL and MySQL as mentioned above.

+2  A: 

MySQL Cookbook (2nd Edition) is very useful, for both MySQL and general SQL related problems.

Imran
+1  A: 

Paul DuBois, MySQL (The Definitive Guide). At Amazon

It's onto the 4th edition now, I have the 3rd and it's excellent.

Tom Dunham