Suggest book for mysql

[cute.bandar]

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]

Try this : SQL Tutorial

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

 

[cute.bandar]

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]

Got this one : MySQL Tutorial

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

 

[digitalage]

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

 

[vickybat]

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

 

[Prime_Coder]

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.

 

[aroraanant]

Evan Bayross is really a very good book....You can learn from that

 

[d6bmg]

I will suggest you to read this book:

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

That book is based on oracle and OP is asking for a book on mysql.

@OP: Read from w3School. Best place to learn.

 

[buddyram]

Read from w3School. Best place to learn.

w3schools is the best place for Novice.