This course is provided by Wintrac. Wintrac
provides one stop shopping for all your IT training needs. Wintrac’s course catalog
of over two thousand courses includes courses on ColdFusion training
ColdFusion Training Course Duration
3 Days
ColdFusion Training Course Outline
Part 1: 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
Part 2: ColdFusion Basics
Using CFML
Code Editors – Dreamweaver vs. HomeSite+
Dreamweaver CS3 Interface
Arguments for use of Dreamweaver
HomeSite+ / ColdFusion Studio Interface
Arguments for use of HomeSite+ / ColdFusion Studio
Tag Editing Dialog Boxes
Embedded Tag Help
<hr> help window in HomeSite+
<hr>help window in Dreamweaver
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)
Online Reference (http://livedocs.adobe.com)
Demo: Built-in Functions
Demo: Date / Time Functions
Using <cfinclude> to reuse code
Demo: Create Header and Footer with <cfinclude>
Exercise 1: Build Dynamic Page Footer using Variables and Date Functions
Challenge
Possible Solution to Exercise 1
Part 3: Dynamic Data: Querying the Database
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
Exercise 2: Query the database
Challenge
Possible Solution to Exercise 2
Customizing Display with <cfoutput>
Demo: Using <cfoutput>
Building Dynamic Tables
Shortcut: <cftable>
Shortcut: Dynamic Table Tool (in Dreamweaver)
Exercise 3: Display Resulting Records manually with <cfoutput>
Challenge
Possible Solution to Exercise 3
Part 4: Creating a Drill-down Interface
Passing Variables between Pages
“Two-page method”
Demo: Pass Variables via Links
Demo: List of Actors with links
Receive Variables through the URL
Using a WHERE clause in a SQL Statement
Protecting Against SQL Injection Attacks with <cfqueryparam>
Exercise 4: Drill-down for More Detail
Challenge
Possible Solution to Exercise 4
Part 5: Conditional Statements and Forms
Conditional Statements
<cfif>, <cfelseif> and <cfelse>
Comparison Operators
Operator
Description
Demo: Conditional Statements
Demo: Conditional Statements Using URL Variables
Using the isDefined() function
Exercise 5: Conditional Statements – Data Validation
Challenge
Possible Solution to Exercise 5
HTML Form Review
Demo: Pass Variable through a Form
Exercise 6: Process Form Submission
Challenge
Possible Solution to Exercise 6
Self-Submitting Forms
Using the <cfparam> tag to set a default value
Quick Examination of a ColdFusion Framework (Methodology): Fusebox
Exercise 7: Self-submitting Form
Challenge
Possible Solution to Exercise 7
Dynamically Populating Select Lists
HTML Review: <select> tags
Demo: Dynamic Select List 9
Introducing the Tag .
Shortcut: <cfselect>
Exercise 8: Create a Dynamic Select List
Challenge
Possible Solution to Exercise 8.
Part 6: Search Interface
Creating a Search Interface
Demo: Using the LIKE clause
Using % and _ in a LIKE Statement
Demo: Building Dynamic SQL Statements
Exercise 9: Create a Search Interface
Note
Challenge
Possible Solution to Exercise 9
Part 7: Insert Records into the Database
SQL Insert Statement
Demo: Insert Record Part 1 – the Form
Insert Record Part 2 – the Insert
Shortcut: <cfinsert>
Redirect Users with <cflocation>
Important note about <cflocation>!
Exercise 10: Insert a New Actor in the Database
Challenge
Possible Solution to Exercise 10
Automated Form Validation
Client-side vs. Server-side validation: When does the validation code run?
Exercise 11: Automatic Client-side (or Server-side) Form Validation
Challenge
Possible Solution to Exercise 11
Part 8: Edit (Update) Database Records
SQL UPDATE Statement Review
Demo: 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>
Exercise 12: Edit a Record
Challenge
Possible Solution to Exercise 12
Note on Deleting records
Review of the SQL Delete Statement
“Deleting” without deleting
No <cfdelete>!
Part 9: Reusing Code
Reusing code with <cfinclude> and <cflocation>
Custom Tags
Demo: custom tags
Where to store Custom Tags
Demo: Custom Tag with Parameters
CALLER and ATTRIBUTE scopes
Using <cfmodule>
A Note about CFX tags
Exercise 13: Calling a Custom Tag to Display a List of Years.
Challenge
Possible Solution to Exercise 14
User Defined Functions (UDFs)
Creating UDFs with the 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
Exercise 14: UDFs
Challenge
Possible Solution to Exercise 14
Part 10: Using Session Variables for Password Protection
Session Variables
Creating Password Protected Pages
The Included Page: demo-password-protect.cfm
The Log in Page: demo-password-form.cfm
Application.cfc
Note regarding Application.cfm
Locking Session and Application variables with <cflock>
Exercise 15: Password Protecting Pages (optional)
Challenge
Possible Solution to Exercise 15
Part 11: Tracking User Information with Cookies (optional)
Demo: setting cookies
Note: When Using Cookies and ColdFusion 5.0
Exercise 16: Remember Users by using Cookies
Challenge
Possible Solution to Exercise 16
Part 12: Sending email with <cfmail> (optional)
Using ColdFusion to Send Email
<cfmail> Tag Syntax
Demo: Sending an email
Exercise 17: Sending Automated Emails
Possible Solution to Exercise 17
Appendix A: Resources
Appendix B: Set-up Notes
Appendix C: Create a Dreamweaver “Site”
Location of our course files
Site Creation – Basic
The Advanced Tab – Additional Categories
Site Files Panel
“Create a Site” vs. “FTP or RDS Server Connection”
Appendix D: Selecting Among ColdFusion Code Reuse Methods
Please contact your training representative for more details on having this course delivered onsite or online
