Re: SQL books

[Dick Applebaum]

I like Mastering SQL by Martin Gruber -- not on Safari, tho :(

Dick

On Sep 9, 2004, at 6:58 AM, George Abraham wrote:

> Hi all,
>  While we are on the rant about technical book authors, anybody have
>  any suggestions for books on SQL? Preferably not beginner stuff, but
>  more intermediate. Most of my queries are so half-assed because I
>  cannot understand or do not know that some things can be better done.
>
>  TIA,
>  George
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL books

[Massimo Foti]

> I found a book on Database Design For Mere Mortals on Safari which
> kind of helps too. Same author as the one of the book that Massimo
> suggested (well, at least one of the authors).

That's a great book on database design.
The one I suggested is more focused on SQL as a language

> As far as going RDBMS specific, right now most of my work is on SQL
> Server, but I have to say sometimes the Books Online make me want to
> tear what little hair I have off my head. They remind me of the
> livedocs on CFML on Macromedia's site. So invaluable, yet so
> frustrating!

Professional SQL Server 2000 Programming
by Robert Vieira
Paperback - 1440 pages (December 2000)
Wrox
ISBN: 0764543792

The Guru's Guide to Transact-SQL
by Ken Henderson
Paperback - 576 pages (February 2000)
Addison-Wesley
ISBN: 0201615762

The Guru's Guide to SQL Server Stored Procedures, XML, and HTML
by Ken Henderson, Ron Soukup
Paperback - 774 pages (December 2001)
Addison Wesley
ISBN: 0201700468

The first one covers SQL as a whole, the other two are mostly about T-SQL
and are available on Safari as well


Massimo Foti
http://www.massimocorner.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL books

[George Abraham]

I found a book on Database Design For Mere Mortals on Safari which
kind of helps too. Same author as the one of the book that Massimo
suggested (well, at least one of the authors).

As far as going RDBMS specific, right now most of my work is on SQL
Server, but I have to say sometimes the Books Online make me want to
tear what little hair I have off my head. They remind me of the
livedocs on CFML on Macromedia's site. So invaluable, yet so
frustrating!

George
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL books

[Donna French]

Same here on my SQL queries - and I learn better from example rather
than page after page of explanation.

- Original Message -
From: Tangorre, Michael <[EMAIL PROTECTED]>
Date: Thu, 9 Sep 2004 10:09:09 -0400
Subject: RE: SQL books
To: CF-Talk <[EMAIL PROTECTED]>

I like the T-SQL book from O'Reilly... And then I like to read all the
Books OnLine for SQL server and the MSDN website!

Michael T. Tangorre  

> From: George Abraham [mailto:[EMAIL PROTECTED] 

> While we are on the rant about technical book authors, 
> anybody have any suggestions for books on SQL? Preferably not 
> beginner stuff, but more intermediate. Most of my queries are 
> so half-assed because I cannot understand or do not know that 
> some things can be better done.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL books

[Damien McKenna]

"Teach Yourself SQL in 10 Minutes, Third Edition" by Ben Forte.  Costs 
about $10-15.  Well worth it.  After that get something specific to 
your database.
-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL books

[Tangorre, Michael]

I like the T-SQL book from O'Reilly... And then I like to read all the
Books OnLine for SQL server and the MSDN website!

Michael T. Tangorre  

> From: George Abraham [mailto:[EMAIL PROTECTED] 
> While we are on the rant about technical book authors, 
> anybody have any suggestions for books on SQL? Preferably not 
> beginner stuff, but more intermediate. Most of my queries are 
> so half-assed because I cannot understand or do not know that 
> some things can be better done.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: SQL books

[Massimo Foti]

> While we are on the rant about technical book authors, anybody have
> any suggestions for books on SQL? Preferably not beginner stuff, but
> more intermediate. Most of my queries are so half-assed because I
> cannot understand or do not know that some things can be better done.

This one is very good:

SQL Queries for Mere Mortals
by Michael J. Hernandez, John L. Viescas
Paperback - 528 pages (August 2000) 
Addison-Wesley
ISBN: 0201433362

But you should also check something specific about the RDMS you use


Massimo Foti
http://www.massimocorner.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: SQL books

[Arden Weiss]

Yoh Will...

I and maybe even others would be very interested in "YOUR" conclusions 
about which books are the better of the bunch you got feedback on -- after 
you do your research of course <:-))

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   W Luke [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, March 16, 2001 6:49 PM
To: CF-Talk
Subject:    Re: SQL books

Thanks for all the tips guys 'n gals - all very helpful.

Will
- Original Message -
From: ""W Luke"" <[EMAIL PROTECTED]>
Newsgroups: dotcom.lists.cftalk
Sent: Friday, March 16, 2001 8:47 PM
Subject: OT: SQL books


> Hi,
>
> I need to buy a good SQL book for reference and help on joins and
> complicated queries - if only to stop me clogging the list up with "Query
> help" subjects...
>
> Anyone got any favourites?
>
> Will
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL books

[W Luke]

Thanks for all the tips guys 'n gals - all very helpful.

Will
- Original Message -
From: ""W Luke"" <[EMAIL PROTECTED]>
Newsgroups: dotcom.lists.cftalk
Sent: Friday, March 16, 2001 8:47 PM
Subject: OT: SQL books


> Hi,
>
> I need to buy a good SQL book for reference and help on joins and
> complicated queries - if only to stop me clogging the list up with "Query
> help" subjects...
>
> Anyone got any favourites?
>
> Will
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL books

[Gary Groomer]

The best book that I have found that covers complex queries is "SQL Queries
for Mere Mortals" by Hernandez & Viescas.  It is very clearly put together
and comes with sample databases for MS Access, MS SQL Server and Oracle.

Gary Groomer

- Original Message -
From: "W Luke" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 12:26 PM
Subject: OT: SQL books


> Hi,
>
> I need to buy a good SQL book for reference and help on joins and
> complicated queries - if only to stop me clogging the list up with "Query
> help" subjects...
>
> Anyone got any favourites?
>
> Will
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL books

[Phoeun Pha]

id ont have the book with me now so i dont remember the title.  but it's
called SQL programming i think, it's a red book with yellow text in the
front, and a picture of the guy in front (gray), in his forties or late
thirties.  good book that covers T-SQL, and lots of join stuff

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 2:27 PM
To: CF-Talk
Subject: OT: SQL books


Hi,

I need to buy a good SQL book for reference and help on joins and
complicated queries - if only to stop me clogging the list up with "Query
help" subjects...

Anyone got any favourites?

Will
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL books

[Braver, Ben:]

"Teach Yourself SQL in 10 Minutes" by Ben Forta (yes, the same Ben Forta as
the essential CF books!), SAMS books, 2000, ISBN 0-672-31664-1, $12.99 US,
or

"SQL Programmer's Reference" by Kishore Bhamidipati (of Oracle Support,
Osborne, 1998, ISBN 0-07-882460-5, $16.99 US.

Ben

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 12:27 PM
To: CF-Talk
Subject: OT: SQL books


Hi,

I need to buy a good SQL book for reference and help on joins and
complicated queries - if only to stop me clogging the list up with "Query
help" subjects...

Anyone got any favourites?

Will
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL books

[Benjamin S. Rogers]

For a Beginner or Someone Looking to Brush up on their Fundamentals:

Sams Teach Yourself Sql in 10 Minutes
By Ben Forta
ISBN: 0672316641

For intermediate to advanced users:

The Practical Sql Handbook : Using Structured Query Language
By Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
ISBN: 0201447878

For Advanced Microsoft SQL Server and Sybase Users

Transact-SQL Programing
by Kevin E. Kline, Lee Gould, Andrew Zanevsky
ISBN: 1565924010

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057


-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 3:27 PM
To: CF-Talk
Subject: OT: SQL books


Hi,

I need to buy a good SQL book for reference and help on joins and
complicated queries - if only to stop me clogging the list up with "Query
help" subjects...

Anyone got any favourites?

Will
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL books

[Greg Jordan]

The Practical Sql Handbook : Using Structured Query Language

ISBN:0201447878



-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 2:27 PM
To: CF-Talk
Subject: OT: SQL books


Hi,

I need to buy a good SQL book for reference and help on joins and
complicated queries - if only to stop me clogging the list up with "Query
help" subjects...

Anyone got any favourites?

Will
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL books

[John Wilker]

SQL Clearly explained is pretty good, concise explanations of stuff. Helped
me with joins a month ago :-) It's by Jan Harrington

I got it as a recommendation from this list :-)

J.



John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 12:27 PM
To: CF-Talk
Subject: OT: SQL books


Hi,

I need to buy a good SQL book for reference and help on joins and
complicated queries - if only to stop me clogging the list up with "Query
help" subjects...

Anyone got any favourites?

Will
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Books

[Benjamin S. Rogers]

What makes a SQL book good is subjective: it depends on what you want to do
with SQL, which vendor's SQL implementation you are using, and what skill
level you are at.

Despite the fact that SQL is a "standard," you'll want to get yourself a
book that discusses your vendor specific flavor of SQL (e.g. Microsoft,
Oracle, Sybase, mySQL). We use Microsoft SQL Server almost exclusively so my
choices are biased in that direction.

Unfortunately, I haven't read any decent database administration books
(vendor specific or otherwise), but I do have a few recommendations on the
programming side:

Beginners:
The Practical SQL Handbook : Using Structured Query Language
I believe this one is written by a bunch of ex-Sybase employees, but it is
pretty universal.

Advanced:
Transact-SQL Programming by O'Reilly
Covers Sybase and Microsoft SQL Server

Both are excellent books.

Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Books

[Marcus]

> does the Ben Forta book sql in 10 minutes come with evaluation 
> software for
> a single user machine and does it work on a win 98 environment
> 
> I would only be using it to develop the sql database and then use the cf
> hosting service to host the sql server etc
> 
> your comments please

No... Ben's SQL in 10 minutes comes with no software.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: SQL Books

[AustralianAccommodation.com Pty. Ltd.]

does the Ben Forta book sql in 10 minutes come with evaluation software for
a single user machine and does it work on a win 98 environment

I would only be using it to develop the sql database and then use the cf
hosting service to host the sql server etc

your comments please

I have taught myself cf using the Ben Forta book The Cold Fusion Web
Application Construction Kit as I had never programmed b4 other than self
taught html I think the cf book is fantastic allowing me to develop my
website to its current standard
Christmas 99 I did not even know what cf was

take a look at the results of my efforts if you are interested

www.australianaccommodation.com

Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

- Original Message -
From: Kelly Matthews <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 26, 2000 7:07 AM
Subject: RE: SQL Books


> Yes Its my favorite too!
>
> > -Original Message-
> > From: Gregory Gooden (Annex) [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 25, 2000 5:02 PM
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: SQL Books
> >
> >
> > SQL IN 10 MINUTES, by BEN FORTA
> >
> > A VERY good book. :)
> >
> > Gregory
> >
> >
> > ---
> > annex.com, Inc. - http://www.annex.com/
> > ---
> > - If you EcoBuild it, they will come. -
> > - http://www.ecobuilder.com/ -
> > ---
> >
> >
> > > -Original Message-
> > > From: Robert Everland [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, July 25, 2000 2:02 PM
> > > To: '[EMAIL PROTECTED]'
> > > Subject: SQL Books
> > >
> > >
> > > Ok I am putting in some requests for books and when I
> > > do a search on
> > > SQL books, just a billion come up. I would like to get the
> > > ones that deal
> > > more with programming, since getting the software to work is
> > > usually the
> > > easy part. Anyone recommend any?
> > >
> > > Robert Everland III
> > > Web Developer
> > > Dixon Ticonderoga
>
> --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Books

[Kelly Matthews]

Yes Its my favorite too!

> -Original Message-
> From: Gregory Gooden (Annex) [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 25, 2000 5:02 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: SQL Books
> 
> 
> SQL IN 10 MINUTES, by BEN FORTA
> 
> A VERY good book. :)
> 
> Gregory
> 
> 
> --- 
> annex.com, Inc. - http://www.annex.com/ 
> --- 
> - If you EcoBuild it, they will come. - 
> - http://www.ecobuilder.com/ - 
> --- 
> 
> 
> > -Original Message-
> > From: Robert Everland [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 25, 2000 2:02 PM
> > To: '[EMAIL PROTECTED]'
> > Subject: SQL Books
> > 
> > 
> > Ok I am putting in some requests for books and when I 
> > do a search on
> > SQL books, just a billion come up. I would like to get the 
> > ones that deal
> > more with programming, since getting the software to work is 
> > usually the
> > easy part. Anyone recommend any?
> > 
> > Robert Everland III
> > Web Developer
> > Dixon Ticonderoga
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: SQL Books

[Nrhorwitz]

Ben Forta's SQL in 10 Minutes has to be the best. 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Books

[Gregory Gooden (Annex)]

SQL IN 10 MINUTES, by BEN FORTA

A VERY good book. :)

Gregory


--- 
annex.com, Inc. - http://www.annex.com/ 
--- 
- If you EcoBuild it, they will come. - 
- http://www.ecobuilder.com/ - 
--- 


> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 25, 2000 2:02 PM
> To: '[EMAIL PROTECTED]'
> Subject: SQL Books
> 
> 
>   Ok I am putting in some requests for books and when I 
> do a search on
> SQL books, just a billion come up. I would like to get the 
> ones that deal
> more with programming, since getting the software to work is 
> usually the
> easy part. Anyone recommend any?
> 
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.