Dynaverse.net

Off Topic => Ten Forward => Topic started by: NJAntman on April 28, 2004, 03:29:22 pm

Title: SQL for Dummies
Post by: NJAntman on April 28, 2004, 03:29:22 pm
Can anyone suggest a good read on using SQL (other than "SQL for Dummies")? I'm at the point where I can alter previously made querries and cut, paste, or replace but recent changes and increase in our workload makes this a bit tedious. Thanks in advance for any leads.  
Title: Re: SQL for Dummies
Post by: Lono on April 28, 2004, 03:36:57 pm

Well... I tend to like the Teach Yourself series.

(i.e. Teach Yourself SQL in 21 Days, Teach Yourself Transact SQL in 21 Days, etc...)

However I prefer the 21 Day books to the 24 Hours books because they tend to have a little more meet to them.

These books are good, imho, because like the Dummies or Idiots books they present the knowledge in a very accesible way, but unlike those types of books they give a significantly deeper look at the subject.

Also since I'm highly ADD I find the way they break the teaching it discrete days much easier to digest then a few of the drier, more technical books on SQL.

You can usually find a pretty good discount on the Teach Yourself books if you look online - just be careful you are buying the latest edition possible on the subject.

 
Title: Re: SQL for Dummies
Post by: Scott Allen Abfalter on April 28, 2004, 03:41:51 pm

Here are PDF links of the books I use at work.  These are written for Informix IDS, but they a lot will be applicable to other vendors.  These are all I've ever needed.   IBM has them unrestricted on their web site, so I suppose it's OK to use them.

Tutorial
http://publib.boulder.ibm.com/epubs/pdf/ct1ssna.pdf

Syntax
http://publib.boulder.ibm.com/epubs/pdf/ct1sqna.pdf

Reference
http://publib.boulder.ibm.com/epubs/pdf/ct1spna.pdf
 
Title: Re: SQL for Dummies
Post by: Scott Allen Abfalter on April 28, 2004, 03:52:05 pm

Teach Youself C++ in 21 Days was a great book, very helpful.

Generally, the best tech books out there are the O'Reiley books, though.
http://www.oreilly.com/

Here is their nutshell book (they make great concise references)
http://www.oreilly.com/catalog/sqlnut/

Here is a pocket reference:
http://www.oreilly.com/catalog/sqlpr/

They have others specific to different vendors....




 
Title: SQL for Dummies
Post by: NJAntman on April 28, 2004, 03:29:22 pm
Can anyone suggest a good read on using SQL (other than "SQL for Dummies")? I'm at the point where I can alter previously made querries and cut, paste, or replace but recent changes and increase in our workload makes this a bit tedious. Thanks in advance for any leads.  
Title: Re: SQL for Dummies
Post by: Lono on April 28, 2004, 03:36:57 pm

Well... I tend to like the Teach Yourself series.

(i.e. Teach Yourself SQL in 21 Days, Teach Yourself Transact SQL in 21 Days, etc...)

However I prefer the 21 Day books to the 24 Hours books because they tend to have a little more meet to them.

These books are good, imho, because like the Dummies or Idiots books they present the knowledge in a very accesible way, but unlike those types of books they give a significantly deeper look at the subject.

Also since I'm highly ADD I find the way they break the teaching it discrete days much easier to digest then a few of the drier, more technical books on SQL.

You can usually find a pretty good discount on the Teach Yourself books if you look online - just be careful you are buying the latest edition possible on the subject.

 
Title: Re: SQL for Dummies
Post by: Scott Allen Abfalter on April 28, 2004, 03:41:51 pm

Here are PDF links of the books I use at work.  These are written for Informix IDS, but they a lot will be applicable to other vendors.  These are all I've ever needed.   IBM has them unrestricted on their web site, so I suppose it's OK to use them.

Tutorial
http://publib.boulder.ibm.com/epubs/pdf/ct1ssna.pdf

Syntax
http://publib.boulder.ibm.com/epubs/pdf/ct1sqna.pdf

Reference
http://publib.boulder.ibm.com/epubs/pdf/ct1spna.pdf
 
Title: Re: SQL for Dummies
Post by: Scott Allen Abfalter on April 28, 2004, 03:52:05 pm

Teach Youself C++ in 21 Days was a great book, very helpful.

Generally, the best tech books out there are the O'Reiley books, though.
http://www.oreilly.com/

Here is their nutshell book (they make great concise references)
http://www.oreilly.com/catalog/sqlnut/

Here is a pocket reference:
http://www.oreilly.com/catalog/sqlpr/

They have others specific to different vendors....




 
Title: SQL for Dummies
Post by: NJAntman on April 28, 2004, 03:29:22 pm
Can anyone suggest a good read on using SQL (other than "SQL for Dummies")? I'm at the point where I can alter previously made querries and cut, paste, or replace but recent changes and increase in our workload makes this a bit tedious. Thanks in advance for any leads.  
Title: Re: SQL for Dummies
Post by: Lono on April 28, 2004, 03:36:57 pm

Well... I tend to like the Teach Yourself series.

(i.e. Teach Yourself SQL in 21 Days, Teach Yourself Transact SQL in 21 Days, etc...)

However I prefer the 21 Day books to the 24 Hours books because they tend to have a little more meet to them.

These books are good, imho, because like the Dummies or Idiots books they present the knowledge in a very accesible way, but unlike those types of books they give a significantly deeper look at the subject.

Also since I'm highly ADD I find the way they break the teaching it discrete days much easier to digest then a few of the drier, more technical books on SQL.

You can usually find a pretty good discount on the Teach Yourself books if you look online - just be careful you are buying the latest edition possible on the subject.

 
Title: Re: SQL for Dummies
Post by: Scott Allen Abfalter on April 28, 2004, 03:41:51 pm

Here are PDF links of the books I use at work.  These are written for Informix IDS, but they a lot will be applicable to other vendors.  These are all I've ever needed.   IBM has them unrestricted on their web site, so I suppose it's OK to use them.

Tutorial
http://publib.boulder.ibm.com/epubs/pdf/ct1ssna.pdf

Syntax
http://publib.boulder.ibm.com/epubs/pdf/ct1sqna.pdf

Reference
http://publib.boulder.ibm.com/epubs/pdf/ct1spna.pdf
 
Title: Re: SQL for Dummies
Post by: Scott Allen Abfalter on April 28, 2004, 03:52:05 pm

Teach Youself C++ in 21 Days was a great book, very helpful.

Generally, the best tech books out there are the O'Reiley books, though.
http://www.oreilly.com/

Here is their nutshell book (they make great concise references)
http://www.oreilly.com/catalog/sqlnut/

Here is a pocket reference:
http://www.oreilly.com/catalog/sqlpr/

They have others specific to different vendors....