Thread: good sql tutorial
Anyone have a recommendation for a good sql tutorial? Looking for a book, but online would be useful as well. This is for a financial user who will need to have an understanding of sql in order to generate reports with a report writer like openrpt. Thanks for any suggestions. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: > Anyone have a recommendation for a good sql tutorial? Looking for a > book, but online would be useful as well. > > This is for a financial user who will need to have an understanding of > sql in order to generate reports with a report writer like openrpt. > > Thanks for any suggestions. http://www.google.com/search?q=sql+tutorial
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/04/07 10:28, Geoffrey wrote: > Anyone have a recommendation for a good sql tutorial? Looking for a > book, but online would be useful as well. > > This is for a financial user who will need to have an understanding of > sql in order to generate reports with a report writer like openrpt. > > Thanks for any suggestions. My suggestion: tell him that the SQL interface is "broken". - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHBQxVS9HxQb37XmcRAnygAKCqEMdordaHeBkThF/fZNKFJaWiSQCfaviU Wv49BY8zYL6W7cQDy7jYRGE= =FnQq -----END PGP SIGNATURE-----
Rodrigo De León wrote: > On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: >> Anyone have a recommendation for a good sql tutorial? Looking for a >> book, but online would be useful as well. >> >> This is for a financial user who will need to have an understanding of >> sql in order to generate reports with a report writer like openrpt. >> >> Thanks for any suggestions. > > http://www.google.com/search?q=sql+tutorial I know how to use google, I'm looking for recommendations. What an ass. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Ron Johnson wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 10/04/07 10:28, Geoffrey wrote: >> Anyone have a recommendation for a good sql tutorial? Looking for a >> book, but online would be useful as well. >> >> This is for a financial user who will need to have an understanding of >> sql in order to generate reports with a report writer like openrpt. >> >> Thanks for any suggestions. > > My suggestion: tell him that the SQL interface is "broken". Then we have to write the reports for him, which is what we are trying to get away from. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: > Anyone have a recommendation for a good sql tutorial? Looking for a > book, but online would be useful as well. I'd recommend The Art of SQL and Joel Celko's books. None are online that I know of, but they're affordable and quite informative.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/04/07 11:06, Geoffrey wrote: > Ron Johnson wrote: >> >> On 10/04/07 10:28, Geoffrey wrote: >>> Anyone have a recommendation for a good sql tutorial? Looking for a >>> book, but online would be useful as well. >>> >>> This is for a financial user who will need to have an understanding of >>> sql in order to generate reports with a report writer like openrpt. >>> >>> Thanks for any suggestions. >> >> My suggestion: tell him that the SQL interface is "broken". > > Then we have to write the reports for him, which is what we are trying > to get away from. You'll see his SQL, squeal like a girl and then forbid him from ever touching the database again. I'm just saving you the intermediary steps. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHBRM4S9HxQb37XmcRAi25AKDf3C73/L5wWEQCokbU2f3kMgtJ4ACgoe5b /Z13ghfxSDePc7fu3i8ck30= =UX2f -----END PGP SIGNATURE-----
On 10/4/07, Ron Johnson <ron.l.johnson@cox.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 10/04/07 11:06, Geoffrey wrote: > > Ron Johnson wrote: > >> > >> On 10/04/07 10:28, Geoffrey wrote: > >>> Anyone have a recommendation for a good sql tutorial? Looking for a > >>> book, but online would be useful as well. > >>> > >>> This is for a financial user who will need to have an understanding of > >>> sql in order to generate reports with a report writer like openrpt. > >>> > >>> Thanks for any suggestions. > >> > >> My suggestion: tell him that the SQL interface is "broken". > > > > Then we have to write the reports for him, which is what we are trying > > to get away from. > > You'll see his SQL, squeal like a girl and then forbid him from ever > touching the database again. I'm just saving you the intermediary > steps. Well, do what I do. set up a slony replicant for the marketeers to work on. That way no matter how badly they beat it up, the people who work on the real db server aren't likely to notice. That and teach a short tutorial class on SQL And set theory. You'd be surprised how much non-db people can soak up from that and a good set of examples.
> ------- Original Message ------- > From: Ron Johnson <ron.l.johnson@cox.net> > To: pgsql-general@postgresql.org > Sent: 04/10/07, 17:22:16 > Subject: Re: [GENERAL] good sql tutorial > > You'll see his SQL, squeal like a girl and then forbid him from ever > touching the database again. I'm just saving you the intermediary > steps. LOL - been there, done that. Also seen what then happens when an incorrectly designed report gets sent to the board and industryregulators! I've also seen finance folks get very good with SQL quite quickly, so only the OP can really say if the pain potential islow enough to justify the time savings. Regards, Dave
On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: > I know how to use google, I'm looking for recommendations. What an ass. If you found my reply to be lacking, you can say so without being rude...
Ron Johnson wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 10/04/07 11:06, Geoffrey wrote: >> Ron Johnson wrote: >>> On 10/04/07 10:28, Geoffrey wrote: >>>> Anyone have a recommendation for a good sql tutorial? Looking for a >>>> book, but online would be useful as well. >>>> >>>> This is for a financial user who will need to have an understanding of >>>> sql in order to generate reports with a report writer like openrpt. >>>> >>>> Thanks for any suggestions. >>> My suggestion: tell him that the SQL interface is "broken". >> Then we have to write the reports for him, which is what we are trying >> to get away from. > > You'll see his SQL, squeal like a girl and then forbid him from ever > touching the database again. I'm just saving you the intermediary > steps. I hear you, but then again, it's not my decision.. :) -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Rodrigo De León wrote: > On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: >> I know how to use google, I'm looking for recommendations. What an ass. > > If you found my reply to be lacking, you can say so without being rude... Stating the obvious google search to me is just as rude. I was looking for recommendations based on others' experiences. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Scott Marlowe wrote: > On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: >> Anyone have a recommendation for a good sql tutorial? Looking for a >> book, but online would be useful as well. > > I'd recommend The Art of SQL and Joel Celko's books. None are online > that I know of, but they're affordable and quite informative. Thanks Scott, I'll check it out. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Scott Marlowe wrote: > On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: >> Anyone have a recommendation for a good sql tutorial? Looking for a >> book, but online would be useful as well. > > I'd recommend The Art of SQL and Joel Celko's books. None are online > that I know of, but they're affordable and quite informative. I have found this to be an excellent book: O'Reilly Learning SQL http://www.amazon.com/Learning-SQL-Alan Beaulieu/dp/0596007272/ref=pd_bbs_1/103-3121914-1316662?ie=UTF8&s=books&qid= 1191519417&sr=8-1
On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: > Stating the obvious google search to me is just as rude. I was looking > for recommendations based on others' experiences. That was not my intention, so I'm sorry if you felt that way. Peace.
Ken.Colson@sage.com wrote: > Scott Marlowe wrote: >> On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: >>> Anyone have a recommendation for a good sql tutorial? Looking for a >>> book, but online would be useful as well. >> I'd recommend The Art of SQL and Joel Celko's books. None are online >> that I know of, but they're affordable and quite informative. > > I have found this to be an excellent book: > > O'Reilly Learning SQL > > http://www.amazon.com/Learning-SQL-Alan > Beaulieu/dp/0596007272/ref=pd_bbs_1/103-3121914-1316662?ie=UTF8&s=books&qid= > 1191519417&sr=8-1 Thanks Ken, I'll check it out as well. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
Rodrigo De León wrote: > On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: >> Stating the obvious google search to me is just as rude. I was looking >> for recommendations based on others' experiences. > > That was not my intention, so I'm sorry if you felt that way. My apologies then. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
On Oct 4, 2007, at 12:23 , Geoffrey wrote: > Rodrigo De León wrote: >> On 10/4/07, Geoffrey <lists@serioustechnology.com> wrote: >>> I know how to use google, I'm looking for recommendations. What >>> an ass. >> If you found my reply to be lacking, you can say so without being >> rude... > > Stating the obvious google search to me is just as rude. I was > looking for recommendations based on others' experiences. That still does not justify being rude in your response. Michael Glaesemann grzm seespotcode net
I think it's out of print, unfortunately, but by far the best quick intro I've ever seen is: "The Essence of SQL: A Guide to Learning Most of SQL in the Least Amount of Time" by David Rozenshtein. -- Scott Ribe scott_ribe@killerbytes.com http://www.killerbytes.com/ (303) 722-0567 voice
Scott Ribe wrote: > I think it's out of print, unfortunately, but by far the best quick intro > I've ever seen is: "The Essence of SQL: A Guide to Learning Most of SQL in > the Least Amount of Time" by David Rozenshtein. Must be a pretty good book. Amazon has one used copy for $119. abebooks.com shows one used %96, three used at $549.05. :) Thanks the pointer though. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin