Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Unanswered: 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

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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 on the Tiger 800 or the Norton

  3. #3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •