>> I'm kind of curious. How many of you have taken a formalized course on database design in either college or other technical training?
I actually had a database class as an undergrad and then another one as a grad student (at the business school!!). My undergrad book essentially sucked, but luckily I had an awesome professor that eventually went to work for Oracle.
I've also decided that Jeremy's next book is going to be on database design. Probably once he gets his first full night of sleep. :)
mcg
| [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 06/19/2006 09:46 AM
|
|
Sure it isn't an all encompassing book. I think it works well as a place to start for programmers who have probably never taken database design in college or elswhere, which is probably the majority of CF programmers. It will help them to avoid some of the common mistakes that new programmers tend to make, like making a database that is more akin to a spreadsheet.
I'm kind of curious. How many of you have taken a formalized course on database design in either college or other technical training?
Shawn Gorrell
Web Development Applications Architect
Federal Reserve Bank - Atlanta
Office (404) 498-8449
| "Jeremy Allen"
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/19/2006 09:34 AM
|
|
I don't particularly care for that book as the author goes on tangents that didn't seem to belong in a database design book. The author also seems to go to great pains to avoid discussing normalization and the normal forms by their proper names (though the content is buried in there). This was in the 97 version, perhaps it was updated.I am not trying to be picky or anything it is just that I happen to have read that particular title and it could have been a lot better with a maybe one chapter on some more advanced topics referenced by their proper names. That said that book combined with SQL for Smarties (Celko) do make a pretty good pair.
Jeremy
On 6/19/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:
A good book for learning about normalization (in plain English) is Database Design for Mere Mortals.
Shawn Gorrell
Web Development Applications Architect
Federal Reserve Bank - Atlanta
Office (404) 498-8449
| "Jeremy Allen"
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 06/18/2006 12:49 AM
|
|
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.
Come to the ACFUG meetings as often as you can and get to know people. Look at all of the open source code out there in CF. There is not a ton of open source CF code but there is enough. Get to know the community, you won't find a much better development community than the CF community. When I started with ColdFusion years ago these lists were the best resources out there for learning things and tackling tough and relatively esoteric problems and they still are today. Chances are whatever problem you are having has been solved many times over and you need but ask. You may ask a question that 100 other people have asked and those of us that have seen the question may groan at it and start thinking, "Jeez" RTFM, however, you will find your question is still answered even if it is a link to ColdFusion documentation pointing out that oh so "obvious" function or tag that solves your problem (that is my way of saying "there aren't usually stupid questions only stupid answers").
And if I didn't impress this upon you well enough in my first post: start writing code! It doesn't have to be perfect. Once you start writing code you can start breaking things and we will have more concrete advice to give you ;-)
Good night all.. sleep awaits.
Jeremy
-------------------------------------------------------------
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
