Introduction to ColdFusion is a 3-day course that provides Web developers with the skills necessary to creating dynamic, data-driven websites using ColdFusion.

Topics
· Setting up the ColdFusion development environment
· Using ColdFusion Studio
· Publishing dynamic data using ColdFusion tags
· Reusing common code
· Building forms with ColdFusion
· Building search interfaces
· Building data drill-down interfaces
· Accepting user information for updating and inserting data in databases
· Incorporating JavaScript to perform client side validation
· Securing web pages

Objectives
Upon completion of this course, you should be able to:
· Develop database-driven Web applications
· Successfully Utilize ColdFusion Markup Language (CFML).
· Define OBDC drivers to interact with database tables
· Build queries that publish, insert, and update data dynamically
· Use JavaScript to perform client-side validation
· Use local, cookies, and other variables within applications
· Set up and manage the ColdFusion development environment

Prerequisites
To gain the most from this class you should already:
· Posess a basic understanding of Web terminology.
· Have basic experience with HTML syntax.
· Have familiarity with the SQL command set.

Course Outline
Chapter 1 - Overview of ColdFusion
ColdFusion Application Server Components
ColdFusion Server
The ColdFusion Administrator
ColdFusion Studio
ColdFusion Templates
Data Sources
How ColdFusion Works
How is ColdFusion Different?
How A Static Page Works
How A ColdFusion Dynamic Page Works
CFML vs. HTML
Using HTML
Using JavaScript/VBScript
Chapter 2 - Setup and Configuration
Installation
Installing a Web Server
Installing ColdFusion Server
Installing ColdFusion Studio
Setting Up a Development Machine
The ColdFusion Administrator
Testing your ColdFusion Installation
Chapter 3 - Using ColdFusion Studio
The Integrated Development Environment The Menu
The Toolbar
The QuickBar
The Resource Window
The HomeSite Editor
Development Tools
Templates and Wizards
The Style Editor
Tag Editors
The Tag Chooser
The Expression Builder
The SQL Builder
Other Development Tools
Chapter 4 - ColdFusion Markup Language (CFML)
Using Variables
Data Types
Variable Groups
Scope and Lifetime
Scope Resolution
Creating A ColdFusion Variable
Naming Rules
Setting A Variable
ColdFusion Output
Using Pound Symbols
Working with Variables
Passing a Variable on the URL
URL Encoding
Passing a Variable from One Template to Another
Working with Template Parameters
Setting a Default Value for a Variable
Using the CFPARAM Tag
Functions in ColdFusion
Calling Functions
Functions for Testing Variables
Testing for Data Types
Date/Time Objects
Date Functions
Date Parts
Date Formatting Codes
Working with Date/Time Objects
Chapter 5 - Flow Control
Conditions
Conditional Values in CFML
Conditional Operators in CFML
Compound Conditions
Branching
Processing Output with CFIF
Using the CFIF Tag
Processing Output with CFELSE
Using the CFELSE Tag
Processing Output with CFELSEIF
Using the CFELSEIF Tag
Conditional Processing with CFSWITCH
Using the CFSWITCH Tag
Looping
The CFLOOP Tag
Conditional Loops
Using Conditional Loops
Index Loops
Using Index Loops
List Loops
Using a List Loop
The CFBREAK Tag
Using the CFBREAK Tag
Halting Execution with CFABORT
Redirection
Using the CFLOCATION Tag
Chapter 6 - The Application Framework
ColdFusion Applications
ColdFusion Page Types
State Management
Relationships Between State Levels
How is the State Managed?
Establishing the Application Framework
Using APPLICATION.CFM
The CFAPPLICATION Tag
Application Management
Client Management
Client Variable Storage
Session Management
Using State Management
Server Variables
Creating an Server Variable
The Built-in Server Variables
Chapter 7 - Using Databases
ODBC
Data Source Names (DSN)
SQL
Creating a Datasource Name (DSN)
The ODBC Data Source Administrator
Creating a DSN in the ODBC Data Source Administrator
Verifying your DSN
The ColdFusion Administrator's ODBC Manager
Structured Query Language (SQL)
SQL Database Terminology
The CFQUERY Tag
Query Variables
Query Information Variables
The SELECT Statement
Using CFOUTPUT With Queries
Generating Output for Queries
CFLOOP and Queries
Using CFLOOP With Queries
Joining Tables
Joining Tables with CFQuery
Grouping Output
The GROUP Option
ORDER BY and GROUP Agreement
Grouping Records with CFOUTPUT
The INSERT Statement
Inserting Records with CFQUERY The UPDATE Statement
Updating Records with CFQUERY
The DELETE Statement
Deleting Records with CFQUERY
SQL Aggregate Functions
Using Aggregate Functions
The GROUP BY Statement
Grouping Aggregate Functions
Managing Transactions
Executing Multiple Queries
The CFTRANSACTION Tag
Using the CFTRANSACTION Tag
Chapter 8 - Using Forms
FORM
INPUT
GET vs. POST
ColdFusion and Forms
FORM Scope
Putting a Form Together
Creating an Add Record Form
Action Templates
Creating an Action Template
A Better Input Form
Creating an Edit Record Form
Creating a Record Picker
Creating an Add/Edit Template.
Creating a Delete Template
Chapter 9 - Data Validation
Server-side Validation
Validation Suffixes
Using Server-side Validation in Forms
Drawbacks of Server-side Validation
Client-side Validation
The CFFORM Tag
Custom Control Tags
The CFINPUT Tag
Client-Side Validation with CFINPUT
Chapter 10 - Reusability
The CFINCLUDE Tag
Using the CFINCLUDE Tag
Custom Tags
Calling a Custom Tag
Where Are Custom Tags Stored?
Building a Custom Tag
Examining the Existing Code
Coding the Custom Tag
Extending the Custom Tag
Custom Tag Modes
Creating Another Custom Tag
More About Tags
Where to Go From Here
Advanced ColdFusion Training
Appendix A - Debugging
Enabling Debug Output
Using the Integrated Debugger
Setting a Breakpoint
Starting a Debug Session
Stepping Through Code
Watching Variables
Appendix B - Security
User Table
Application.cfm
Login Form
Action Template
Custom Tag
Testing the Login
Logging Out
Appendix C - ColdFusion Studio Keyboard Shortcuts
Menu Command Shortcuts
Editing Command Shortcuts · Introducing the course