Suggest book for mysql

10 posts · originally from https://geek.digit.in/community/threads/suggest-book-for-mysql.151832/

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

Try this : SQL Tutorial

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

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.

Got this one : MySQL Tutorial

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

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

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

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.

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

Prime_Coder said:
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.

d6bmg said:
Read from w3School. Best place to learn.

w3schools is the best place for Novice.