Thread: Newsgroups/sites for SQL questions?
After having gotten my DB up and running and doing what it should I am now getting to the point where I understand my data and have some somewhat complicated queries I would like to run against it. Unfortunately I'm having trouble with coming up with the SQL queries that retrieve the data I want. Can anyone recommend some newsgroups or sites where questions on constructing SQL queries are welcomed? Since these would be purely SQL questions and not really related to postgres I they don't really belong on the PG mailing list. Thanks! Jean-Christian Imbeault
On Tuesday 01 April 2003 04:01, Jean-Christian Imbeault wrote: > After having gotten my DB up and running and doing what it should I am > now getting to the point where I understand my data and have some > somewhat complicated queries I would like to run against it. > > Unfortunately I'm having trouble with coming up with the SQL queries > that retrieve the data I want. > > Can anyone recommend some newsgroups or sites where questions on > constructing SQL queries are welcomed? How about the the pgsql-sql list? For newsgroups have a look at comp.databases and comp.databases.theory . Ian Barwick barwick@gmx.net
On Tue, 1 Apr 2003, Jean-Christian Imbeault wrote: > After having gotten my DB up and running and doing what it should I am > now getting to the point where I understand my data and have some > somewhat complicated queries I would like to run against it. > > Unfortunately I'm having trouble with coming up with the SQL queries > that retrieve the data I want. > > Can anyone recommend some newsgroups or sites where questions on > constructing SQL queries are welcomed? > > Since these would be purely SQL questions and not really related to > postgres I they don't really belong on the PG mailing list. There are also some on the web on places like dev shed and phpbuilder. PHPBuilder is a place where a lot of beginners go, especially MySQL beginners using PHP. devshed is a little more advanced, but there's still some good novice areas too. My other recommendation would be to pick up a good SQL / Database theory book. If you're getting a feel for SQL then try J Celcko's "SQL for Smarties" and his other SQL books are pretty good too, and entertaining as well. And, if you just wanna read the archive of USENET past and such, you can use groups.google.com, look for comp.databases.postgresql
make sure to buy the SECOND edition of Joe's books, some major errors from the first version are fixed in the second, plus some more information. scott.marlowe wrote: > On Tue, 1 Apr 2003, Jean-Christian Imbeault wrote: > > >>After having gotten my DB up and running and doing what it should I am >>now getting to the point where I understand my data and have some >>somewhat complicated queries I would like to run against it. >> >>Unfortunately I'm having trouble with coming up with the SQL queries >>that retrieve the data I want. >> >>Can anyone recommend some newsgroups or sites where questions on >>constructing SQL queries are welcomed? >> >>Since these would be purely SQL questions and not really related to >>postgres I they don't really belong on the PG mailing list. > > > There are also some on the web on places like dev shed and phpbuilder. > > PHPBuilder is a place where a lot of beginners go, especially MySQL > beginners using PHP. devshed is a little more advanced, but there's still > some good novice areas too. > > My other recommendation would be to pick up a good SQL / Database theory > book. If you're getting a feel for SQL then try J Celcko's "SQL for > Smarties" and his other SQL books are pretty good too, and entertaining as > well. > > And, if you just wanna read the archive of USENET past and such, you can > use groups.google.com, look for comp.databases.postgresql > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >