Topic: SQL for Dummies (Read 1564 times)

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.

Lono · « **Reply #1 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.

Scott Allen Abfalter · « **Reply #2 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

Scott Allen Abfalter · « **Reply #3 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....

NJAntman · « **Reply #4 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.

Lono · « **Reply #5 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.

Scott Allen Abfalter · « **Reply #6 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

Scott Allen Abfalter · « **Reply #7 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....

NJAntman · « **Reply #8 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.

Lono · « **Reply #9 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.

Scott Allen Abfalter · « **Reply #10 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

Scott Allen Abfalter · « **Reply #11 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....

News: