Re: Looking for good reference materials for SQL programming.

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