I'm looking for the best SQL book or free tutorial on the web.
I know I can Google the tutorial, but picking your brains is easier and it always produces better results.
All suggestions are welcome; free is always better.
I'm looking for the best SQL book or free tutorial on the web.
I know I can Google the tutorial, but picking your brains is easier and it always produces better results.
All suggestions are welcome; free is always better.
If you are using IBM DB2 (since you didn't say which db) I'd recommend the DB2 cookbook
Maybe not really good as learning material - but very good as a reference.
If your new you can't go wrong with w3schools to get your feet wet.
They have great introductory tutorials for most web technologies too
SQL Cookbook by O'Reilly, really good at explaining common concepts in different RDMBSes.
I think best book for sql learning is Introduction to SQL (Oracle sql course). You will learn sql from this book in one day, if you want. There is no excess information there. Book has examples and very good explanations for particular topic. Also there is exercises after each lesson.
There is also very good books for PLSQl: Introduction to Oracle PLSQL
Best books I found were all by Itzik Ben-Gan
http://www.sql.co.il/books/insidetsql2005/
If you read the querying book followed by the programming book you will definitely notice a difference.
The chapters on how sql server interprets and processes you query are fantastic. You find yourself writing queries differently than you normally would once you understand these.
Highly recommend.
See this thread:
http://stackoverflow.com/questions/31982/looking-for-a-good-book-to-learn-sql
And these tags:
http://stackoverflow.com/questions/tagged/books+sql
I reiterate my usual first recommendation of:
My favorite it the little book The Essence of SQL. It's small because it sticks to what's most important. Easy to read, but goes into some depth.
Don't have vote up rights yet so another vote for "The Essence of SQL" mentioned nearby.