good sql tutorial

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.

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...

------- 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 industry regulators!

I've also seen finance folks get very good with SQL quite quickly, so only the OP can really say if the pain potential is low enough to justify the time savings.

Regards, Dave

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