What's the best SQL book for an intermediate level database programmer?

[jklimek]

In May of this year I graduated from Penn State with a BS in IST
(Information Sciences and Technology). Right after graduation I got a
database programming job with a company that uses Delphi 6 and MS SQL
Server 2000.

I've been working with this company for six months now but I'm still
not very good with SQL. I can do basic SQL queries and table joins (as
well as use datetime functions and cursors), but I'd say I'm only at an
intermediate level (at best).

So... I'm looking to learn more about SQL. I'm guessing a good SQL
reference book would help, but I'd really prefer a good book that
actually teaches you and guides you along. The only problem is that I
don't want a basic/beginner level SQL book since I already know all of
the basics.

Can anybody recommend anything for me?

Thanks!

[JD311]

Hey,

You can try "MSSQL Server 2000 Unleashed".
I find it as a good reference book.

However I strongly recommend that you check its contents before buying it
as choice of books vary from person to person.

Thanks,
Jay.
jk*****@gmail.com wrote in message news:<11*********************@f14g2000cwb.googlegr oups.com>...

In May of this year I graduated from Penn State with a BS in IST
(Information Sciences and Technology). Right after graduation I got a
database programming job with a company that uses Delphi 6 and MS SQL
Server 2000.

I've been working with this company for six months now but I'm still
not very good with SQL. I can do basic SQL queries and table joins (as
well as use datetime functions and cursors), but I'd say I'm only at an
intermediate level (at best).

So... I'm looking to learn more about SQL. I'm guessing a good SQL
reference book would help, but I'd really prefer a good book that
actually teaches you and guides you along. The only problem is that I
don't want a basic/beginner level SQL book since I already know all of
the basics.

Can anybody recommend anything for me?

Thanks!

[--CELKO--]

>> I've been working with this company for six months now but I'm
still not very good with SQL. <<

It takes about a year to get the basic ideas into your head. Remember
how weird recursion was when you first saw it? Then it all fell into
place one day. Same thing with thinking in sets and predicates.

I'd also get a copy of my SQL FOR SMARTIES. This is not merely
self-promotion; the book really is the main reference for advanced
SQL. Look around your shop because the odds are pretty good that
someone has a first or second edition on their bookcase.