Hello All,

Anyone could suggest good books for writing SQL?
(and also optimise the performance of SQL statements).

I am planning to buy 2 or 3 SQL related books. I know the basic SQL (e.g. writing join, left join, nested join). I have been using SQL for 3 months. I am working as a data analyst/ data mining consultant. So I am NOT looking the DBA parts or the programming parts. Just writing adhoc SQL queries to extract data for data mining purpose. The queries have to be optimised and fine tuned.

Any advise would be very much appreciated.

Thanks

if you are trying to cover the bases then SQL in a nutshell from O'Reilly is quite usefull. although it has dated very quicky as new verions have come out.

The version I have covers SQL Server, MySQL, Oracle & PostgreSQL.

As to to fine tuning tuning your weaponf fo choice should have suitable tools such as explain etc...

Thanks, I bought this just now from amazon. Yes, one of them is SQL in a nutshell. Hopefully they are good choices.

-------------------------------------------------------
1 of: SQL Tuning [Paperback]
By: Dan Tow
$26.37


1 of: Data Modeling Essentials, Third Edition (Morgan Kaufmann Series in Data Management Systems) (The Morgan Kaufmann Series in Data Management Systems) [Paperback]
By: Graeme Simsion, Graham Witt
$35.93


1 of: SQL Performance Tuning [Paperback]
By: Peter Gulutzan, Trudy Pelzer
$28.49
-

1 of: SQL Pocket Guide [Paperback]
By: Jonathan Gennick
$9.95


1 of: SQL In A Nutshell, 2nd Edition [Paperback]
By: Kevin Kline, et al
$29.67