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 Interface.
Tag Updaters / Extensions
Tag Editing Dialog Boxes
Embedded Tag Help
Using ColdFusion Comments
Creating Variables
<cfset> and <cfoutput>
Variable Scope/Prefixes.
Built-in ColdFusion Functions
CF Function Reference (Dreamweaver specific)
Online Reference (http://livedocs.adobe.com)
Tip: (http://cfquickdocs.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 <foutput>
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
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
Exercise 8: Create a Dynamic Select List
Challenge
Possible Solution to Exercise 8
Part 6: Quick Introduction to RSS and Ajax with
Reading an RSS Feed
Demo: Consuming an RSS Feed
Demo: Creating an RSS Feed
Introducing the Tag
Building a Mask with <cfform>
Automatically Build a Dynamic Select List with <cfselect>
Demo: Creating an Auto Suggest Text Field with <cfform>
Part 7: Search Interface
Creating a Search Interfacei
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 8: 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>
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 9: 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:
Exercise 12: Edit a Record
Challenge
Note on Deleting records
Review of the SQL Delete Statement
“Deleting” without deleting
No <cfdelete>!
Part 10: 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 13
User Defined Functions (UDFs) and ColdFusion Components (cfcs)
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
Exercise 14: UDFs
Challenge
Possible Solution to Exercise 14
Part 11: 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 12: Tracking User Information with Cookies (optional)
