ColdFusion Training: Beginning ColdFusion 8

Course Number: CF-100
Duration: 3 days
view class outline

ColdFusion Training Overview

Learn to build data-driven Web applications using ColdFusion in this challenging and enjoyable ColdFusion training class! This course teaches attendees the core ColdFusion Markup Language (CFML) skills they need to successfully build database-driven Web sites with ColdFusion^®.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=coldfusion.

Alternative ColdFusion Training Course

This ColdFusion training class focuses more on teaching attendees CFML coding practices and less on using Dreamweaver to automatically generate the ColdFusion code. If you are looking for a training class that is oriented to using Dreamweaver's "drag and drop" features to automatically generate code, please see the description for Building ColdFusion Web Sites with Dreamweaver training.

ColdFusion Training Prerequisites

All Beginning ColdFusion training students must be fluent in HTML, including text layout, image placement, hyperlinks, tables, and forms. Prior SQL and programming experience is helpful but not required.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 20 minutes.

ColdFusion Training Materials

All students receive a copy of Macromedia Press' ColdFusion Web Application Construction Kit, as well as copies of the instructor's presentation.

Software Needed on Each PC

Windows XP, Vista, or 7; or Mac OSX
ColdFusion 8 or later - ColdFusion should be set up to run as a stand-alone server for purposes of the class
Adobe Dreamweaver 8, Dreamweaver CS3, Dreamweaver CS4, or later
Microsoft Access
Firefox 2.0 or later or Internet Explorer 6 or later
2GB RAM or higher

ColdFusion Training Objectives

To teach students the fundamentals of CFML and how to properly configure the ColdFusion Server
To show attendees the CFML skills they need to develop applications that process forms and select, insert, update, and delete records in databases
To give students the regular expression experience they need to validate user input
To teach attendees how to use the CFMAIL tag to generate confirmations and other messages

ColdFusion Training Outline

Introduction to ColdFusion

Static pages vs. Dynamic pages
Server-side Web Technologies
Database Alphabet Soup: ODBC/JDBC, DSNs and SQL
Course Objectives and Prerequisites
Introduction to Course Project

ColdFusion Basics

Using CFML
Code Editors - Dreamweaver vs. HomeSite+

Dreamweaver 8 Interface

Arguments for use of Dreamweaver
HomeSite+ / ColdFusion Studio Interface
Arguments for use of HomeSite+ / ColdFusion Studio
Tag Editing Dialog Boxes
Embedded Tag Help
Using ColdFusion Comments

Creating Variables

<cfset> and <cfoutput>
Variable Scope/Prefixes

Built-in ColdFusion Functions

Insert Expression (HomeSite+ / ColdFusion Studio specific)
CF Function Reference (Dreamweaver specific)
Built-in Functions
Date / Time Functions

Using <cfinclude> to reuse code

Create Header and Footer with <cfinclude>

Database Basics

Introduction to SQL
Select Statement
Update Statement
Insert Statement
Delete Statement
Data Source Name (DSN) / Remote Development Server (RDS)
The DSN Used in This Class: MovieList

Course Project Database

Querying the database with <cfquery>

<cfdump> for Quick Output
Customizing Display with <cfoutput>
Using <cfoutput>

Building Dynamic Tables

Shortcut: <cftable>
Shortcut: Dynamic Table Tool (in Dreamweaver)

Passing Variables between Pages to create a "Drill-down" interface

"Two-page method"
Pass Variables via Links
List of Actors with links
Receive Variables through the URL
Using a WHERE clause in a SQL Statement

Conditional Statements

<cfif>, <cfelseif> and <cfelse>
Comparison Operators
Operator
Description
Conditional Statements
Using the isDefined() function

HTML Form Review

Pass Variable through a Form

Self-Submitting Forms

Using the <cfparam> tag to set a default value
Fusebox: Perhaps the Ultimate Self-submitting Form

Dynamically Populating Select Lists

HTML Review: <select> tags
Dynamic Select List
Introducing the <cfform> Tag
Shortcut: <cfselect>

CFForm

Masks
Automatic Form Validation

Introduction to JavaScript and Ajax

Ajax Controls
Using <cfgrid> to page through records

Creating a Search Interface

Using the LIKE clause
Using % and _ in a LIKE Statement
Building Dynamic SQL Statements

Inserting Records

SQL Insert Statement
Insert Record Step 1 - the Form
Insert Record Step 2 - the Insert
Shortcut: <cfinsert>
Redirect Users with <cflocation>
Important note about <cflocation>!

Automated Form Validation

Client-side vs. Server-side validation: When does the validation code run?
Exercise 12: Automatic Client-side (or Server-side) Form Validation

Updating records

SQL UPDATE Statement Review
Update Record Page 1 - select the record to edit
Passing the Primary Key
Page 2 - View Current Data in a Form
Page 3 - Perform the Update to the Database
Shortcut: <cfupdate>

Deleting Records

Note on Deleting records
Review of the SQL Delete Statement
"Deleting" without deleting
No <cfdelete>

Reusing code with <cfinclude> and <cflocation>

Custom Tags

custom tags
Where to store Custom Tags
Custom Tag with Parameters
CALLER and ATTRIBUTE scopes
Using <cfmodule>
A Note about CFX tags

User Defined Functions (UDFs)

Creating UDFs with the <cffunction> tag

Using ColdFusion Components (CFCs)

Creating Components
Calling or Invoking Components
Passing Arguments to Components
The Component Code
The main CFML page
View a Component directly in the browser

Session Variables

Creating Password Protected Pages
Password-protect.cfm (the included page)
demo-password-form.cfm
Application.cfm
Locking Session and Application variables with <cflock>

setting cookies

Note: When Using Cookies and ColdFusion 5.0

Using ColdFusion to Send Email

<cfmail> Tag Syntax
Sending an email

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.