SQL books

G'day /prog/. At work I'm using a lot of SQL, and I'm learning as I go (lol English), but I'd like to actually learn the language well and have a good understanding of what's going on behind it.

So I wonder if there are any SQL classics. Something like K&R, but for SQL. Can you recommend me anything?

I'd be interested in replies to this.  I learned mostly everything through co-workers -- guys who'd had an IT/IS-based education and had 5-10 years doing just database stuff (in my case, mostly db2 and SQL server related).  Had access to hundreds of load/resume/purge jobs that I could look through and learn from. 

I think you can find plenty of books that adequately cover SQL and dbms-specific implementations, but I would like to know of a book that covers all the clever little things that can be done with SQL, especially in query optimization (and not just throwing some indexes on a table).

http://www.amazon.com/Manga-Guide-Databases-Mana-Takahashi/dp/1593271905/?ie=UTF8&s=books

Read the fourth edition of SICP, where they replaced Scheme with SQL to be more relevant to today's programmer's needs.

>>4
I can't wait to see the metacircular evaluator written in SQL

>>4
Did you not mean C#?

SQL can't evaluate itself...

>>7
I can't EVALUATE MY OWN ANUS

>>8
Shame, I have tail call optimization.

My language has no tail call optimization.
How does it avoid stack overflow?
Terrible!

Are you GAY?
Are you a NIGGER?
Are you a GAY NIGGER?

If you answered "Yes" to all of the above questions, then GNAA (GAY NIGGER ASSOCIATION OF AMERICA) might be exactly what you've been looking for!