Bit of a misnomer: what you need has nothing to do with ColdFusion - you
need advanced database training. Maybe that'll help your search.
I know you want it to "relate back to ColdFusion". However, change your
mindset a bit - your database is separate tier, not "part" of
ColdFusion. As such, look for dedicated database training. About the
only thing that will vary by language is calling stored procedures - and
that's 15 minutes and a reference on your own. Besides, there's far
more "database" than "using databases with ColdFusion" training out
there.
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 5:04 PM
To: CF-Talk
Subject: SOT: Training Recommendations
Hi All -
I'm hoping someone can recommend some ColdFusion training that focuses
on a variety of topics at the database level, especially including:
* Database Design Techniques
* Implementing Stored Procedures
* Designing and Using Triggers
* Joins
I started using ColdFusion on a very casual, teach-myself-as-I-go basis
back when CF3 was the latest and greatest. I am very confident with my
ColdFusion specific skills, but continue to find that my SQL skills (or
lack of) are holding me back. I get especially confused with joins, and
moment I prefer to use the old ANSI 88?? style joins. However, when I
need to do any complex nested joins, I find myself relying on Access's
query builder because I absolutely can't figure out how to write them by
hand. I also have very little knowledge about stored procedures,
triggers, indexes, etc. I've been able to gather that stored procedures
and triggers can make a world of difference performance-wise, and I feel
as-if I'm providing a a great disservice to my customers by not knowing
how to properly evaluate when I should be using implementing
stored-procedures, triggers or whatever.
Overall, I want to improve my database design and SQL skills, but I want
the information I learn to be delivered in a way so that it's always
relating back to ColdFusion.
Any suggestions?
Jay Sudowski
---------------------
Handy Networks LLC
TEL: 877-70-HANDY
FAX: 888-300-2FAX
URL: www.handynetworks.com
---------------------
Providing reseller and dedicated Windows 2000 web hosting solutions.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
