473,320 Members | 1,947 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 questions
Jul 20 '05 #1
4 3247
michael 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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Jul 20 '05 #2

"Daniel Morgan" <da******@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
Jul 20 '05 #3
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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Jul 20 '05 #4
The Guru's Guide to Transact-SQL by Ken Henderson

http://www.amazon.com/exec/obidos/tg...36720?v=glance
Jul 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
by: Raque | last post by:
Hello. I'm looking for a good C++ reference book. I learned C++ a year ago. It is very broad and I need something to refer to. Particularly about syntax (using -> versus ".", etc.), using...
6
by: Danny Lu | last post by:
Hi, can anyone tell me where I can get a good perl book? TIA Dan
13
by: John Salerno | last post by:
Here are a few I'm considering: Design Patterns Explained : A New Perspective on Object-Oriented Design (2nd Edition) (Software Patterns Series) by Alan Shalloway Design Patterns C# by...
6
by: Christoph | last post by:
I was browsing both the Amazon and Barnes & Noble websites looking for some good books but there appears to be *so* many and it's hard to tell which are going to be good or not. I'm looking for...
6
by: Jamiil | last post by:
I am not a programmer by any means, but a dedicated aficionado. I have good understanding of Java and C/C++, and now I would like to learn javascript->ajax, but I don't know where to start. My HTML...
5
by: Matthew Wells | last post by:
I'm looking for a good book on ASP.net. I'm looking for a book that builds a project throughout the book - not disjointed examples for every chapter. I have a book on ASP standard called "Web...
7
by: TAVOSOFT | last post by:
Hi friends, I am begginer , I wanna to learn VB2005 ,Which are good book for to learn VB2005 of level -begginer-intermediate. Thanks you friends.
13
by: arnuld | last post by:
i see C FAQs are very important part of learning C. whole C FAQs are available as a book (1st edition) in my area at a little cost. is it a good idea to purchase C FAQs book, published in 1996 ?...
22
by: Jon Skeet [C# MVP] | last post by:
I'm looking to write a C# book fairly soon, and the publisher I've approached wants me to do a bit of market research to find out what people like and don't like in this kind of book. I've read...
76
by: lorlarz | last post by:
Crockford's JavaScript, The Good Parts (a book review). This shall perhaps be the world's shortest book review (for one of the world's shortests books). I like Douglas Crockford (because I am a...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.