good SQL book?

hello, for a new job i might have to learn SQL. i've never
worked with databases or SQL, so i'll need to learn. can
anybody advice me on what would be a good book to learn
from? i'm quite an experienced programmer, so it doesn't
have to be a dummies guide, and preferably not a bulky book
like the "SQL bible" or something.

oh, one of my 'favourite' computer books of all times is
"thinking in Java" by bruce eckel, to give you an idea.

mike

--
not sure if there's a better group to ask these questionsmichael nieuwenhuizen wrote:

> hello, for a new job i might have to learn SQL. i've never
> worked with databases or SQL, so i'll need to learn. can
> anybody advice me on what would be a good book to learn
> from? i'm quite an experienced programmer, so it doesn't
> have to be a dummies guide, and preferably not a bulky book
> like the "SQL bible" or something.
> oh, one of my 'favourite' computer books of all times is
> "thinking in Java" by bruce eckel, to give you an idea.
> mike
> --
> not sure if there's a better group to ask these questions

Probably the best of breed is Joe Celko's "SQL For Smarties" but I
wouldn't call it a beginner's book by any stretch of the imagination.
Put it on your list for book number 2 or 3.

Also, remember that TransactSQL is no more generic than is Oracle's
PL/SQL or any other vendor's implementation. So make sure the SQL book
you get is one that is oriented toward the RDBMS on which you will be
working.
--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)|||"Daniel Morgan" <damorgan@.x.washington.edu> wrote
> Probably the best of breed is Joe Celko's "SQL For Smarties" but I
> wouldn't call it a beginner's book by any stretch of the imagination.

i actually browsed through that one and it looked pretty impressive ...
and then i saw it wasn;t for the beginner ...

> Put it on your list for book number 2 or 3.

will do. thanks.

> Also, remember that TransactSQL is no more generic than is Oracle's
> PL/SQL or any other vendor's implementation.

i really don't have a clue about SQL. aren't all the SQL's based on
one version?

> So make sure the SQL book you get is one that is oriented toward the
> RDBMS on which you will be working.

it would probably be Oracle.

mike

--
and i have no experience with that either|||michael nieuwenhuizen wrote:

> i really don't have a clue about SQL. aren't all the SQL's based on
> one version?

SQL is an ANSI standard language. But the ANSI standard is not one thing
... it is at least three. And within that standard every vendor has lots
of room to implement that standard by any means they wish. Then they all
add proprietary language extensions to differentiate their product from
the others (more cynical minds would say to lock in their customers).

>>So make sure the SQL book you get is one that is oriented toward the
>>RDBMS on which you will be working.
>
> it would probably be Oracle.
> mike

Then I'd suggest reposting your question in an Oracle usenet group (such
as comp.databases.oracle.server) so that we don't offend our hosts by
being off-topic. But you can find all of the Oracle SQL you could
possibly hope to find at http://tahiti.oracle.com.

--
Daniel Morgan
http://www.outreach.washington.edu/...oad/oad_crs.asp
http://www.outreach.washington.edu/...aoa/aoa_crs.asp
damorgan@.x.washington.edu
(replace 'x' with a 'u' to reply)|||The Guru's Guide to Transact-SQL by Ken Henderson

http://www.amazon.com/exec/obidos/t...536720?v=glance