RE: [ACFUG Discuss] Learning Cold Fusion

[Charlie Arehart]

Yeah, sorry, Jeremy. I should have acknowledged (as I did see) that you particularly pointed out in your earlier note that the Celko book had a chapter on normalization that you recommended. No question, that's valuable knowledge that many do lack, and you're right: Ben's TYS10M doesn't approach it in any depth. Good catch.

 

There are various books out there on the topic of DB design. Unfortunately, there are also various arguments about them among reviewers. Perhaps they disagree with the background from which the authors speak, or they can't sympathize with the intended background the author had in mind for the audience. Anyway, if anyone ever has to build any database or even add a new table, or if they must work with a database that is "normalized", it's imperative that they spend at least a few hours trying to understand that topic. Jeremey's mention of the wikipedia is another good starting point.

 

/charlie

 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Allen
Sent: Sunday, June 18, 2006 12:50 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Learning Cold Fusion

SQL In 10 Minutes seems like a fine book for learning the basics of SQL Syntax. What I don't see is a good grounding in Normalization and database design. The Learn SQL in 10 minutes book focuses on SQL Syntax and SQL Queries.  That is good... you DO need to know all of that and I suppose a structured approach to learning the syntax and basics is required. I also willingly admit that the Celko book is pretty out there in terms of skill level for a lot of the topics covered. You will save yourself a LOT of pain by understanding proper database design and normalization early on. Its not a difficult thing to get a handle on. If your average developer just knew 1NF, 2NF and 3NF better database designs on the whole would be a lot better. You can probably find enough on the normal forms just by searching the Internet.  Once again Wikipedia is a good start http://en.wikipedia.org/wiki/Database_normalization. I only bring it up because it is quite often overlooked and it is a critical piece in my mind. Enough on that. 

 <snip> 
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------