Re: Looking for good reference materials for SQL programming. - Mailing list pgsql-novice

From Peter J. Schoenster
Subject Re: Looking for good reference materials for SQL programming.
Date
Msg-id 3AFA7A3E.32387.8CBED5E@localhost
Whole thread Raw
In response to Re: Looking for good reference materials for SQL programming.  (pete@example.compulink.co.uk)
Responses Re: Looking for good reference materials for SQL programming.  (pete@example.compulink.co.uk)
List pgsql-novice
On 9 May 2001, at 23:20, pete@example.compulink.co.uk wrote:

> "Eric Naujock " <naujocke@abacusii.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

pgsql-novice by date:

Previous
From: Pete Jewell
Date:
Subject: Re: Looking for good reference materials for SQL programming.
Next
From: Tatsuo Ishii
Date:
Subject: Re: [GENERAL] Charset and encoding