Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Book Recommendation

Re: SQL Book Recommendation

From: DA Morgan <>
Date: Fri, 06 Jul 2007 13:47:55 -0700
Message-ID: <>

batso wrote:

> On Jul 6, 11:28 am, Mark D Powell <> wrote:

>> On Jul 5, 5:46 pm, hpuxrac <> wrote:
>>> On Jul 5, 3:30 pm, J <> wrote:
>>>> Hi Everyone,
>>>> I've done some searching on the forum/group here and I'm having a hard
>>>> time trying to find a book that suits my needs. I'm looking for a
>>>> book that I can use/reference to find how to use all of the various
>>>> SQL commands in Oracle. I've had prior experience in Transact-SQL in
>>>> my last job writing against a MS SQL Server. The book that I found
>>>> and love is "The Guru's Guide to Transact-SQL" by Ken Henderson. This
>>>> book, IMHO, is the best, definite guide on how to query a database.
>>>> Link here:
>>>> I'm trying to find this same book for Oracle, but I'm not sure if one
>>>> exists. What I'm not looking for is a book that teaches you the
>>>> administrative side of an Oracle server/db, database tuning, etc. I'm
>>>> looking for a book that teaches all of the SQL commands (select,
>>>> insert, pivot tables, subquerying, etc), how they work, and what the
>>>> syntax is.
>>>> Is there anything out there that has this?
>>>> Thanks
>>>> Jeff
>>> My recommendation to you is to start with Tom Kyte's new book "Expert
>>> Oracle Database Architecture".
>>> I think you will be selling yourself short and not using oracle as it
>>> is designed to be used if you only concentrate on syntax and don't
>>> begin at square one.
>>> Learn the architecture and how to develop and design scalable systems
>>> first. Take a look at syntax for sql and plsql once you have read
>>> Tom's book cover to cover a couple of times.
>>> There are several followup books but that is the place to start.
>>> All of the syntax is covered pretty well in the free oracle
>>> documentation from
>>> An alternative but not as highly recommended ( from me anyhow ) is to
>>> start with the oracle concepts manual.
>>> Get familiar with Tom's site
>>> questions and answers in it.
>>> There's a fairly steep learning curve with oracle if you want to do
>>> things well. Don't underestimate how much learning needs to be done.- Hide quoted text -
>>> - Show quoted text -
>> Since the OP is concerned about writing SQL I suspect the OP is more
>> of a developer than a DBA and as such I would suggest starting with
>> the Oracle Application Developers Guide - Fundamentals instead of
>> Concepts. This manual covers many of the topics found in Concepts and
>> DBA Administration but with more emphasis on using rather than
>> managing the objects.
>> Tom's Book is very good but I think Tom expects you to be familiar
>> with Oracle and PL/SQL since it is not a primer on SQL or PL/SQL so I
>> would suggest reviewing the first few chapters of the SQL manual which
>> cover the Oracle provided functions like to_date, to_char, upper(_),
>> etc... and then reading the PL/SQL manual before reading a book.
>> HTH --Mark D Powell --- Hide quoted text -
>> - Show quoted text -
> This is my first post on here.  I like a corny looking little book
> called sql cookbook by pete cassidy.  it's full of usable examples.
> the index is lousy.  and it's a bit old and out of date.  it stops at
> inline queries.  but still helpful for writing basic ad hoc sql,
> creating sql from sql, and many others.  it's not cheap either.  i've
> seen it listed for about $50 more than original list price on amazon
> and ebay.

You can find current examples in abundance and for free by going to Morgan's Library at All ways free and always available as a service of an Oracle user group.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Jul 06 2007 - 15:47:55 CDT

Original text of this message