[ACFUG Discuss] DB Design Book Reccomendations?

2007-01-12 Thread Robert Reil
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
-





Re: [ACFUG Discuss] DB Design Book Reccomendations?

2007-01-12 Thread Shawn . Gorrell
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?

2007-01-12 Thread Howard Fore

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?

2007-01-12 Thread Dean H. Saxe
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
-





Re: [ACFUG Discuss] DB Design Book Reccomendations?

2007-01-12 Thread Precia

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.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
-





-
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 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?

2007-01-12 Thread Teddy Payne

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.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
> -
>
>
>
>
>
> -
> 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 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
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com/>
-





--

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?

2007-01-12 Thread Robert Reil
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 Sales&Service
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?

2007-01-12 Thread Charlie Arehart
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
-





Re: [ACFUG Discuss] DB Design Book Reccomendations?

2007-01-12 Thread Dean H. Saxe
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


Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Here in America everything is bought and sold, you can get anything  
for little bits of gold.
We'll rape the earth and ruin the air, cut down every tree from here  
to there.

-- Donna The Buffalo "America"


On Jan 12, 2007, at 10:16 AM, Robert Reil wrote:


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 Sales&Service
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
-







-
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?

2007-01-12 Thread Shawn . Gorrell
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

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?

2007-01-12 Thread Teddy Payne

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
-







--

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?

2007-01-12 Thread Teddy Payne

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.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
> -
>
>
>
>
>
>
> -
> 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
> -
>
>
>
>


--

Adobe Certified ColdFusion MX 7 Developer
Atlanta CFUG (ACFUG): http://www.acfug.org





--

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?

2007-01-12 Thread Charlie Arehart
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?

2007-01-12 Thread Robert Reil
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 Sales&Service
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/>  
- 




-- 

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?

2007-01-12 Thread Robert Reil
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 Sales&Service
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?

2007-01-12 Thread Robert Reil
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 Sales&Service
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/> 
-








-- 
 
Adobe Certified ColdFusion MX 7 Developer
Atlanta CFUG (ACFUG): http://www.acfug.org <http://www.acfug.org/>  




-- 

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?

2007-01-12 Thread Teddy Payne

Robert,
You cannot avoid command line over time.  Most GUI tools for MySQL are just
tools that execute command line actions.

You will find in time that command line will be faster than UI as UI will
still ahve to render and you will click 10 times for something you could
have typed in less time.

As for Safari Books, read their website.

Teddy


On 1/12/07, Robert Reil <[EMAIL PROTECTED]> wrote:


 What is this a bunch of PDF's?



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


 --
*From:* Teddy Payne [mailto:[EMAIL PROTECTED]
*Sent:* Friday, January 12, 2007 10:34 AM
*To:* Carbs Sales&Service
*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]> 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.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
> > -
> >
> >
> >
> >
> >
> >
> > -
> > 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
> > ---

Re: [ACFUG Discuss] DB Design Book Reccomendations?

2007-01-12 Thread Douglas Knudsen

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
> -
>
>
>
>


--

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?

2007-01-12 Thread Howard Fore

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
-





Re: [ACFUG Discuss] DB Design Book Reccomendations?

2007-01-12 Thread Teddy Payne

Celko has a google group.  His hierarchy entity structure is a godsend for
reporting structures.

The SQL to create one of these lists is definitely not for the faint of
heart.

Teddy


On 1/12/07, Howard Fore <[EMAIL PROTECTED]> wrote:


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
-







--

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
-