Re: Looking for good reference materials for SQL programming.

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