Re: SQL textbook

On Thu, 8 Feb 2007, Michael Schmidt wrote:

> There are a lot of resources available.  Each database program has a
> different dialect of SQL, and I find the PostgreSQL on-line manual has an
> excellent introduction of SQL and even some theoretical issues.  I would
> start there (its free and directly applicable to using PostgreSQL).

>>  I would like to ask for a hint for a good SQL textbook. I don't want just
>>  a reference manual but real textbook with a theoretical background so I
>>  could to design my databases following the general rules as normal forms
>>  and so on. I mean something on the net of course.

   I think Jan is confusing two separate concepts: database design
(particularly how to normalize the tables) and the SQL language used to work
with whatever design one's created.

   For the language itself, I concur that anything written by Joe Celko is
worth reading. I believe he wrote a monthly column for Database Advisor in
the 1980s that was always worth reading.

   For database design, I suggest a visit to a library, technical bookstore,
or a Google search to find something written to answer the questions Jan
has. Seems like every author has a different definition of 'database
design,' and some confuse design tools with design concepts. Only Jan can
decide what references are pertinent to his needs. Again, Google is your
friend.

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863