Hi Jay,
I took a class called Implementing a Database on MS SQL 7.0 with
Productivity Point Intl (www.propoint.com). It covered everything you're
looking for, and you get to keep the lesson binder. It does not related
back to ColdFusion, but I think it's important to learn the ins and outs of
SQL and Enterprise Manager apart from ColdFusion as well, since it's usually
most efficient to do as much of the database work as possible via views and
stored procedures rather than in the ColdFusion code.
Marianne Daye
Programmer/Analyst
Information Delivery Systems (IDS)
http://ids.rti.org
(919) 541-8031
-----Original Message-----
From: Jay Sudowski - Handy Networks LLC [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 6: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
