Re: [ACFUG Discuss] DB Design Book Reccomendations?
Database Design For Mere Mortals Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 Robert Reil [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/12/2007 09:45 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
Amen! On 1/12/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Database Design For Mere Mortals -- Howard Fore, [EMAIL PROTECTED] Gliddy glub gloopy / Nibby nabby noopy / La la la lo lo / Sabba sibby sabba / Nooby abba nabba / Le le lo lo / Tooby ooby walla / Nooby abba naba / Early morning singing song - Good Morning Starshine - 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 http://www.fusionlink.com -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
Absolutely! On 1/12/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Database Design For Mere Mortals Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 *Robert Reil [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 01/12/2007 09:45 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com http://motorcyclecarbs.com/, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 http://www.fusionlink.com/ - - 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 http://www.fusionlink.com -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
MySQL Crash Course (Sams Teach Yourself in 10 Minutes) by Ben Forta On 1/12/07, Precia [EMAIL PROTECTED] wrote: Absolutely! On 1/12/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Database Design For Mere Mortals Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 *Robert Reil [EMAIL PROTECTED]* Sent by: [EMAIL PROTECTED] 01/12/2007 09:45 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com http://motorcyclecarbs.com/, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 http://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 http://www.fusionlink.com/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] DB Design Book Reccomendations?
Shawn, and others: Thanks, your unanimous agreement cinches it as the next book after finishing the WACK 3 months from now. I remember Shawn sharing that this was the book in the past but I forgot the name. I am now ready to buy. Dean: Thanks for the additional words. I will also get SQL for Smarties by Joe Celko also. I know I will need to build scripts etc in due time and such. This seems that it will be a good primer for that. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -Original Message- From: Dean H. Saxe [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 9:57 AM To: Carbs SalesService Subject: Re: [ACFUG Discuss] DB Design Book Reccomendations? Ditto. Eventually reach guru status by reading SQL for Smarties by Joe Celko. Its not about design but about how to use the DB and SQL. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Great spirits have often encountered violent opposition from weak minds. --Einstein On Jan 12, 2007, at 9:48 AM, [EMAIL PROTECTED] wrote: Database Design For Mere Mortals Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 Robert Reil [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/12/2007 09:45 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] DB Design Book Reccomendations?
My copy is on loan somewhere or I'd offer it. I've got more programming books than God and would be totally willing to put them in a loaner program. Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 Charlie Arehart [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/12/2007 10:22 AM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] DB Design Book Reccomendations? Robert, I'll echo Shawn and the other's sentiments on the Mere Mortals book. As for the ACFUG library, there is no real one. I will say I've been meaning to create a virtual one (where people post the books they have and members can borrow from each other by way of bringing desired or returned books to the meeting, with email notifications to track it all and using the Amazon web service to ease data entry), and I have renewed interest in that for other reasons, so look for that soon. That said, does anyone have a copy of that book to lend to Robert at the next meeting (or the Flex meeting on Wed, if you both would be going)? /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 12, 2007 9:46 AM To: discussion@acfug.org Subject: [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
I recommend Safari Books Online. For $19/mon you can check out 10 books out at a time. For $40/mon, you get unlimited access. www.safaribooksonline.com The books are virtual and you read them online. I have several friends using it and it saves them a lot of money when they jsut want to read certain chapters of certain books. Teddy On 1/12/07, Charlie Arehart [EMAIL PROTECTED] wrote: Robert, I'll echo Shawn and the other's sentiments on the Mere Mortals book. As for the ACFUG library, there is no real one. I will say I've been meaning to create a virtual one (where people post the books they have and members can borrow from each other by way of bringing desired or returned books to the meeting, with email notifications to track it all and using the Amazon web service to ease data entry), and I have renewed interest in that for other reasons, so look for that soon. That said, does anyone have a copy of that book to lend to Robert at the next meeting (or the Flex meeting on Wed, if you both would be going)? /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 12, 2007 9:46 AM To: discussion@acfug.org Subject: [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - 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 http://www.fusionlink.com -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
By the way, the ..Mere Mortals book is in their library. Teddy On 1/12/07, Teddy Payne [EMAIL PROTECTED] wrote: I recommend Safari Books Online. For $19/mon you can check out 10 books out at a time. For $40/mon, you get unlimited access. www.safaribooksonline.com The books are virtual and you read them online. I have several friends using it and it saves them a lot of money when they jsut want to read certain chapters of certain books. Teddy On 1/12/07, Charlie Arehart [EMAIL PROTECTED] wrote: Robert, I'll echo Shawn and the other's sentiments on the Mere Mortals book. As for the ACFUG library, there is no real one. I will say I've been meaning to create a virtual one (where people post the books they have and members can borrow from each other by way of bringing desired or returned books to the meeting, with email notifications to track it all and using the Amazon web service to ease data entry), and I have renewed interest in that for other reasons, so look for that soon. That said, does anyone have a copy of that book to lend to Robert at the next meeting (or the Flex meeting on Wed, if you both would be going)? /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 12, 2007 9:46 AM To: discussion@acfug.org Subject: [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com http://motorcyclecarbs.com/, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform 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 http://www.fusionlink.com - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] DB Design Book Reccomendations?
Yes, the primer to get is Ben's Teach Yourself SQL in 10 minutes. Can't say enough good words about it (indeed, no more than my review I did back in 2000 which is still the spotlight review at Amazon), and it's a very slim book at just about $10. It's now in its 3rd edition, but even the first would be fine (you can get all of them used, though I wouldn't give mine up. It's worth rereading every once in a while until you know you know everything in it.) /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Friday, January 12, 2007 10:27 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] DB Design Book Reccomendations? No, its not a primer at all. Get comfortable with SQL. Then get guru status by reading and understanding Celko's book. Its not for the faint of heart. -dhs - 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] DB Design Book Reccomendations?
Wouldnt that be more command line though? I hate command line. I feel Navicat and for that matter MySQL Admin's GUI is consice enough to not have to learn the MySQL command line. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com http://www.motorcyclecarbs.com/ _ From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 10:18 AM To: Carbs SalesService Subject: Re: [ACFUG Discuss] DB Design Book Reccomendations? MySQL Crash Course (Sams Teach Yourself in 10 Minutes) by Ben Forta On 1/12/07, Precia [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Absolutely! On 1/12/07, [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Database Design For Mere Mortals Shawn Gorrell Web Development Applications Architect Federal Reserve Bank - Atlanta Office (404) 498-8449 Robert Reil [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 01/12/2007 09:45 AM Please respond to discussion@acfug.org mailto:discussion@acfug.org To discussion@acfug.org mailto:discussion@acfug.org cc Subject [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com http://motorcyclecarbs.com/ , Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com http://www.motorcyclecarbs.com/ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com http://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com -
RE: [ACFUG Discuss] DB Design Book Reccomendations?
I was thinking of having that for pocket refference anyhow. Heck for $10 it's a no brainer. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -Original Message- From: Charlie Arehart [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 10:41 AM To: Carbs SalesService Subject: RE: [ACFUG Discuss] DB Design Book Reccomendations? Yes, the primer to get is Ben's Teach Yourself SQL in 10 minutes. Can't say enough good words about it (indeed, no more than my review I did back in 2000 which is still the spotlight review at Amazon), and it's a very slim book at just about $10. It's now in its 3rd edition, but even the first would be fine (you can get all of them used, though I wouldn't give mine up. It's worth rereading every once in a while until you know you know everything in it.) /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe Sent: Friday, January 12, 2007 10:27 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] DB Design Book Reccomendations? No, its not a primer at all. Get comfortable with SQL. Then get guru status by reading and understanding Celko's book. Its not for the faint of heart. -dhs - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com -
RE: [ACFUG Discuss] DB Design Book Reccomendations?
What is this a bunch of PDF's? Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com http://www.motorcyclecarbs.com/ _ From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 10:34 AM To: Carbs SalesService Subject: Re: [ACFUG Discuss] DB Design Book Reccomendations? By the way, the ..Mere Mortals book is in their library. Teddy On 1/12/07, Teddy Payne [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I recommend Safari Books Online. For $19/mon you can check out 10 books out at a time. For $40/mon, you get unlimited access. www.safaribooksonline.com http://www.safaribooksonline.com/ The books are virtual and you read them online. I have several friends using it and it saves them a lot of money when they jsut want to read certain chapters of certain books. Teddy On 1/12/07, Charlie Arehart [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Robert, I'll echo Shawn and the other's sentiments on the Mere Mortals book. As for the ACFUG library, there is no real one. I will say I've been meaning to create a virtual one (where people post the books they have and members can borrow from each other by way of bringing desired or returned books to the meeting, with email notifications to track it all and using the Amazon web service to ease data entry), and I have renewed interest in that for other reasons, so look for that soon. That said, does anyone have a copy of that book to lend to Robert at the next meeting (or the Flex meeting on Wed, if you both would be going)? /Charlie http://www.carehart.org/blog/ http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Robert Reil Sent: Friday, January 12, 2007 9:46 AM To: discussion@acfug.org mailto:discussion@acfug.org Subject: [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com http://motorcyclecarbs.com/ , Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com http://www.motorcyclecarbs.com/ - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com http://www.fusionlink.com/ - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org/?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com http://www.fusionlink.com/ - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org http://www.acfug.org/ -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org http://www.acfug.org - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink http://www.fusionlink.com -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
I get access to safari books via netG from my employeer. It really RawkS! Robert, safarionline books are in html format, they don't want you to go and print them yourself, eh? DK On 1/12/07, Teddy Payne [EMAIL PROTECTED] wrote: I recommend Safari Books Online. For $19/mon you can check out 10 books out at a time. For $40/mon, you get unlimited access. www.safaribooksonline.com The books are virtual and you read them online. I have several friends using it and it saves them a lot of money when they jsut want to read certain chapters of certain books. Teddy On 1/12/07, Charlie Arehart [EMAIL PROTECTED] wrote: Robert, I'll echo Shawn and the other's sentiments on the Mere Mortals book. As for the ACFUG library, there is no real one. I will say I've been meaning to create a virtual one (where people post the books they have and members can borrow from each other by way of bringing desired or returned books to the meeting, with email notifications to track it all and using the Amazon web service to ease data entry), and I have renewed interest in that for other reasons, so look for that soon. That said, does anyone have a copy of that book to lend to Robert at the next meeting (or the Flex meeting on Wed, if you both would be going)? /Charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Friday, January 12, 2007 9:46 AM To: discussion@acfug.org Subject: [ACFUG Discuss] DB Design Book Reccomendations? Starting to get into CF I now am aware that I need to understand things about DB design. Can anyone recommend a good book on how to design a DB? I am learning things about autoincrementing, indexing, datatypes, foreign keys, scripts, etc. I am running MySQL but realize that a MySQL book will give me command line notes. I edit MySQL using Navicat (A WONDERFUL PROGRAM!! THANKS JOHN MASON!!). But I realize my weaness is not in how to make DB changes, but what changes to make in setting up a DB in order to have CF do what I want it to do in designing our Corporate Intranet. Maybe the ACFUG library has something in it I can borrow? Charlie? Thanks in advance. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com - 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 http://www.fusionlink.com - - 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 http://www.fusionlink.com - -- cf_payne / Adobe Certified ColdFusion MX 7 Developer Atlanta CFUG (ACFUG): http://www.acfug.org - 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 http://www.fusionlink.com - -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? - 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 http://www.fusionlink.com -
Re: [ACFUG Discuss] DB Design Book Reccomendations?
So true. Celko's books (and columns available online, do some Googling) are great, but they're not for beginners. On 1/12/07, Dean H. Saxe [EMAIL PROTECTED] wrote: No, its not a primer at all. Get comfortable with SQL. Then get guru status by reading and understanding Celko's book. Its not for the faint of heart. -- Howard Fore, [EMAIL PROTECTED] Gliddy glub gloopy / Nibby nabby noopy / La la la lo lo / Sabba sibby sabba / Nooby abba nabba / Le le lo lo / Tooby ooby walla / Nooby abba naba / Early morning singing song - Good Morning Starshine - 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 http://www.fusionlink.com -