It depends on what you want to know.
I used _Fundamentals of Database Systems_ (Elmasri and Navathe) when I took
a DB course. It was pretty good, though my impression is that there might
be a "classic" which is better.
The problem with the more MySQL-specific books is that you might not learn
the more abstract aspects of database design. E.g. some MySQL literature
seems to imply that keys and indexes are the same thing, which is not true.
Also, a book like the one above will strongly emphasize what an "ideal" RDMS
will adhere to, most importantly data integrity, especially referential
integrity. Earlier editions of MySQL (including the one I'm using) don't
actually enforce foreign key references. And judging from some things I see
posted in this list, your DB design will be well-served by learning the
fundamentals.
I haven't read Celko's books, but my guess is that they're advanced, not
foundational, and that you'd be better served by first looking at a
foundational book.
-S
----- Original Message -----
From: "Fawad Siddiqui" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 8:05 PM
Subject: Books advice
Hi,
I would like to learn about RDBMS, namely mysql of course, but know really
nothing in this area, so have to learn about; RDBMS, SQL and mysql from
scratch.
In this regard, if anyone knows of any books they think would start me off
on the right foot, I would be very grateful.
I have done some searching on Amazon, with the following results.
1. Beginning Databases with MySQL
by Richard Stones, Neil Matthew
2. MySQL Cookbook
by Paul DuBois
3. Managing and Using MySQL
by George Reese, et al
4. Inside Relational Databases
by Mark Whitehorn, Bill Marklyn
5. Database Design
by Ryan K. Stephens, Ronald R. Plew
6. The Practical SQL Handbook: Using SQL Variants
by Judith S. Bowman, et al
Many thanks in advance for all your help.
Fawad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
