Skip site navigation (1) Skip section navigation (2)

Re: Looking for good reference materials for SQL programming.

From: "Peter J(dot) Schoenster" <peter(at)schoenster(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Looking for good reference materials for SQL programming.
Date: 2001-05-10 17:23:42
Message-ID: 3AFA7A3E.32387.8CBED5E@localhost (view raw or flat)
Thread:
Lists: pgsql-novice
On 9 May 2001, at 23:20, pete(at)example(dot)compulink(dot)co(dot)uk wrote:

> "Eric Naujock " <naujocke(at)abacusii(dot)com> writes:
> 
> > I have been playing with postgresql for a while and have a copy of
> > the book Postgresql on order. 
> > 
> > Are there any good reference materials available to teach how to do
> > effective SQL and relational database design. I would prefer
> > something more platform neutral but covers the theroy and concepts
> > of good database design. Does anyone here have any suggestions for
> > such materials?

Someone else wrote:
> There is a /very/ good book, whose exact name escapes me at the
> moment, but you should be able to find it on Amazon if you perform a
> search for 'SQL' and 'Practical'.

That is probably Practical SQL :) ... worth a read but unless I missed 
something I didn't see where it helped with design (does help with SQL 
though).

I would recommned Greenspun.  Any of his books plus whatever his 
websites are now will help:

http://www.arsdigita.com/asj/

http://www.arsdigita.com/asj/data-warehousing

> Data Warehousing for Cavemen, a guide to how large organizations use
> database management software 


> Philip and Alex's Guide to Web Publishing

http://www.arsdigita.com/books/panda/index.html

Peter
All idioms must be learned.
Good idioms only need to be learned once. 
--Alan Cooper

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2001-05-10 22:35:44
Subject: Re: PostgreSQL 7.1 (current release) - frequent errno:55 (buffer space error)
Previous:From: ghaverlaDate: 2001-05-10 16:21:15
Subject: psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group