If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > Good SQL books for (SQL-server, oracle, DB2, Postgress, MySQL)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-20-06, 22:38
livecdbiz livecdbiz is offline
Registered User
 
Join Date: Jan 2006
Posts: 2
Good SQL books for (SQL-server, oracle, DB2, Postgress, MySQL)

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
Reply With Quote
  #2 (permalink)  
Old 01-21-06, 04:43
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
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...
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 01-22-06, 03:57
livecdbiz livecdbiz is offline
Registered User
 
Join Date: Jan 2006
Posts: 2
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On