Обсуждение: SQL textbook

Hello,

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.

Thank you

Jan Mura

Jan Mura wrote:
> Hello,
>
> 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.

Try "An Introduction to Database Systems" by C.J. Date - that'll give
you a good background. Anything will do for SQL.

> I mean something on the net of course.

I don't know that there is anything on the net that covers background
information well.

--
   Richard Huxton
   Archonet Ltd

>
>----- Original Message -----
>From: Michael Schmidt
>To: Jan Mura ; pgsql-general@postgresql.org
>Sent: Thursday, February 08, 2007 12:54 PM
>Subject: Re: [GENERAL] SQL textbook
>
>Many books are available for download.  Joe Celko is a well respected
>author and just about anything with his name on it is good.  Here are some
>specific suggestions.

Do you have any URLs for the books that are available for download?

Cheers

Ted

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

On Thu, 8 Feb 2007, Ted Byers wrote:

> Do you have any URLs for the books that are available for download?

   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