It's probably correct to day that Date, along with Codd, is the other father of relational database theory. The book will be solid, and probably pretty abstruse in places. These two books I've found really helpful:
The Practical SQL Handbook, by Bowman, Emerson and Darnovsky is very good and comprehensive. Addison-Wesley, ISBN 0-201-44787-8 SQL for Smarties, by Joe Celko, Morgan Kaufamn, ISBN 1-55860-323-9 And I'd bet there is the ubiquitous "SQL for" . "Dummies" || "Idiots" || "Mortals" which sometimes present foundation material just differently enough that the light dawns and you are on your way. I'm surprised that the O'Reilly book falls down here, but they are sometimes very terse and require close attention. (Are their editors on piece rate, paid by the words they remove?) There are also a number of tutorials. If you search for "SQL tutorial normalization" you will get v. useful hits, but look for ones which use more than one table and go on to more complex queries. Cheers - Miles At 09:16 AM 1/16/2002 -0500, Leotta, Natalie (NCI/IMS) wrote: >I'm a recent student but I sold back my DB text in hopes I'd never have to >know the stuff again (I guess that $20 wasn't worth it). The current book >my old prof is using is: > >Introduction to Database Systems, 7th Edition by C.J. Date. > >but since I don't know if that's the one I used I don't know if it's any >good. I do know that the class covered the normalizations and things like >that. It might be a good place to start, but it seems like college >textbooks are always at least twice the cost of normal books. > >I haven't tried the PHP O'Reilly book, so thanks for the warning! > >-Natalie > > > -----Original Message----- > > From: DL Neil [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, January 15, 2002 5:34 PM > > To: Leotta, Natalie (NCI/IMS); 'Andy'; [EMAIL PROTECTED] > > Subject: Re: [PHP-DB] How can recommend a book for SQL and DB design > > > > Andy (and Natalie), > > > > In fact the O'Reilly book on PHP is the exception that might well prove > > the rule - normally I think them v.good > > > > The reference work on MySQL is by Paul DuBois (who often stops by here - > > "hi Paul") and published by New Riders. > > > > Unfortunately none of my favorite texts (of the moment) go into the > > background of db theory, eg normalisation. > > Perhaps one of the (recent) students on the list can help with that one... > > > > Regards, > > =dn > > > > > > ----- Original Message ----- > > From: "Leotta, Natalie (NCI/IMS)" <[EMAIL PROTECTED]> > > To: "'Andy'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: 15 January 2002 22:14 > > Subject: RE: [PHP-DB] How can recommend a book for SQL and DB design > > > > > > > Any O'Reilly book is always a good choice. O'Reilly is the publisher - > > they > > > do the "Nutshell" books and a bunch of others. They are also the books > > with > > > animals on them, if that helps :-) > > > > > > -Natalie > > > > > > > -----Original Message----- > > > > From: Andy [SMTP:[EMAIL PROTECTED]] > > > > Sent: Tuesday, January 15, 2002 5:11 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: [PHP-DB] How can recommend a book for SQL and DB design > > > > > > > > Hi, > > > > > > > > I am searching for a good book on how to design a db for web apps. > > > > Normalisation rools, performance....just describing how to do it on a > > > > proffesional way. > > > > > > > > The second one, I am searching for is a book about SQL for MySQL. Any > > good > > > > books on the market? > > > > > > > > Thanx for the recommendation > > > > > > > > Andy > > > > > > > > > > > > > > > > -- > > > > PHP Database Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > To contact the list administrators, e-mail: > > [EMAIL PROTECTED] > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
