Re: SQL Book Recommendation

On Jul 5, 9:30 pm, J <jdfer..._at_gmail.com> 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:http://www.amazon.com/Gurus-Guide-Transact-SQL-Ken-Henderson/dp/02016...
>
> 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?
>

I think Steven Feuerstein's book is pretty good when it comes to teaching PL/SQL. ("Oracle PL/SQL programming")

I started (and frankly can't really remember in which order) with this one, the Oracle concepts manual and Tom Kyte's book "Expert Oracle Database Architecture".

As for syntax ... as often as I get lost in them - the Oracle manuals do a pretty good job of explaining the syntax for SQL. For PL/SQL see book above.

br,
Martin Received on Fri Jul 06 2007 - 16:16:37 CDT