Good book for sql

Question

I always considered database as a storage . but never thought it can be used for querying across tables etc.

Which is a good book for sql for a developer. not just the syntax. How to write a query in different ways How internally queries are executed.etc

especially related to microsoft sql server

Answer 1

My favorite SQL book is a few years old, but it covers much of the internals in addition to the semantics - Bob Beauchemin's A Developer's Guide to SQL Server 2005: http://www.amazon.com/Developers-Guide-SQL-Server-2005/dp/0321382188

Answer 2

This question is duplicate, many times over, on StackOverflow.
For example:

• relational-database-theory-and-sql-book-recommendations
• help-me-find-this-sql-book-that-was-awesome-for-me-in-school
• best-book-for-a-new-database-developer
• what-is-the-best-sql-book-or-web-tutorial

Furthermore, there are many SQL Book questions related to specific SQL implementations: Microsoft SQL Server, mySQL, etc.

Answer 3

You could try wrox books. They are helpful and easy to understand. For beginners:

http://www.amazon.co.uk/Beginning-Microsoft-Server-Programming-Programmer/dp/0470257016/ref=pd_bxgy_b_text_b http://www.amazon.co.uk/gp/product/0470257032/ref=pd_lpo_k2_dp_sr_2?pf_rd_p=103612307&pf_rd_s=lpo-top-stripe&pf_rd_t=201&pf_rd_i=0470176377&pf_rd_m=A3P5ROKL5A1OLE&pf_rd_r=0MCQAJWWEARM9Y80E3NK

For advanced:

http://www.amazon.co.uk/Professional-Microsoft-Server-Administration-Programmer/dp/0470247967/ref=pd_bxgy_b_text_c

Answer 4

SQL in a Nutshell: A Desktop Quick Reference