Suggest book for mysql

cute.bandar · 26-01-2012, 05:44 PM

I made a classified site so I already know the basics. SELECT , UPDATE , CREATE , DELETE (CRUD) , using foreign key etc. I just need to learn a little bit more ,but not in perfect detail. For example : I know how to use UNION ALL,but end up making highly inefficient sql queries. I can use foreign key method , but never used constraints etc.

SO I am looking for book/tutorial that is isn't for beginners and isn't too deep/advanced either. Something dense , yet compact. Don't have too much time to spend on a 500 page behemoth.
Can someone recommend me something ?

Thanks

**krishnandu.sarkar** · 26-01-2012, 06:05 PM

Try this : SQL Tutorial

I don't think you need to invest in a book.

cute.bandar · 26-01-2012, 06:29 PM

Thanks. that looks good and should cover learning SQL language.
But is there something similar for mysql? something that would cover things like constraints, indexes etc.

**krishnandu.sarkar** · 26-01-2012, 06:39 PM

Got this one : MySQL Tutorial

Looks good to me..!! Can't say more as I got it using a simple google search

digitalage · 26-01-2012, 06:48 PM

+1 for suggestion by "krishnandu.sarkar" (W3 School) it includes most of the part and gives a definite approach

vickybat · 26-01-2012, 10:33 PM

I suggest "head first SQL" by lynn beighley. Wonderful approach imo.

Prime_Coder · 28-01-2012, 12:01 AM

I will suggest you to read this book:

SQL, PL/SQL the Programming Language of Oracle by Evan Bayross

I am unable to tell the exact page-count at this moment, but I'm sure it is less than 500 pages, contains basic SQL , interactive SQL and many other things in different organized sections. A must read while working with databases.