1.0 Introduction
1.1 Internet Basics
1.2 Client vs. Server Side Scripting
1.3 CFML vs. VBScript and JavaScript
1.4 Application Servers Overview
1.5 Installing ColdFusion MX 7
1.6 Setting Up Dreamweaver 8

2.0 Variables and Expressions
2.1 Overview of Variables and Expressions
2.2 Setting Variables
2.3 Displaying Variables
2.4 Commenting Your Code
2.5 Using Predefined Functions
2.6 Manipulating Strings
2.7 Review

3.0 Conditional Processing
3.1 Overview of Conditional Processing
3.2 The <cfif> Tag
3.3 The <cfswitch> Tag
3.4 Nesting Statements
3.5 Boolean Expression
3.6 Review

4.0 Using Loops
4.1 Overview of Looping
4.2 The Index Loop
4.3 The Conditional Loop
4.4 The Query Loop
4.5 The List Loop
4.6 The Collection Loop
4.7 Nesting Loops
4.8 Review

5.0 Accessing Databases
5.1 Database Overview
5.2 Connecting to a Database
5.3 The <cfquery> Tag and SQL Queries
5.4 Displaying Query Results with the <cfoutput> Tag
5.5 Manipulating Existing Queries
5.6 Viewing Query MetaData
5.7 Review

6.0 Application Framework
6.1 Overview of the Application Framework
6.2 The Application File
6.4 Using Multiple Application Files
6.5 Review

7.0 Level 1 Summary

1.0 Introduction
1.1 Level Overview

2.0 URL Variables
2.1 Overview of URL Variables
2.2 Creating URL Variables
2.3 Passing Multiple URL Variables
2.4 Handling Complicated Strings
2.5 Using URL Variables
2.6 Review

3.0 FORM Variables
3.1 Overview of FORM Variables
3.2 Creating FORM Variables
3.3 Database Driven Form Elements
3.4 Validating Form Fields
3.5 Form Processing
3.6 Review

4.0 APPLICATION and SERVER Variables
4.1 Overview of APPLICATION and SERVER Variables
4.2 Creating APPLICATION Variables
4.3 Using SERVER Variables
4.4 Review

5.0 Managing Sessions
5.1 Overview of Managing Sessions
5.2 Using Cookies
5.3 SESSION Variables
5.4 CLIENT Variables
5.5 Review

6.0 Locking
6.1 Overview of Locking
6.2 The <cflock> Tag
6.3 Deadlocks
6.4 Review

7.0 Level 2 Summary

1.0 Introduction
1.1 Level Overview

2.0 Lists
2.1 Overview of Lists
2.2 List Basics
2.3 Sorting
2.4 Looping Through Lists
2.5 Nesting Lists
2.6 Special Lists
2.7 Review

3.0 Arrays
3.1 Overview of Arrays
3.2 Creating Arrays
3.3 Converting Between Lists and Arrays
3.4 Multidimensional Arrays
3.5 Review

4.0 Structures
4.1 Overview of Structures
4.2 Creating Structures
4.3 Using Structures
4.4 Looping Through Structures
4.5 Internal Structures
4.6 Complex Data
4.7 Pointers
4.8 Queries
4.9 Review

5.0 Level 3 Summary

1.0 Introduction
1.1 Level Overview

2.0 Forms
2.1 Overview of Forms
2.2 HTML Forms
2.3 Flash Forms
2.4 XForms
2.5 Form Action Page
2.6 Review

3.0 Printing
3.1 Overview of Printing
3.2 The <cfdocument> Tag
3.3 Child Tags
3.4 Review

4.0 Reporting
4.1 Overview of Reporting
4.2 The <cfreport> Tag
4.3 Using the Report Builder
4.4 Running Reports
4.5 Review

5.0 Graphing
5.1 Overview of Graphing
5.2 Basic Charts
5.3 Formatting Charts
5.4 Advanced Charting
5.5 Review

6.0 Level Summary

1.0 Introduction
1.1 Level Overview

2.0 Scripting
2.1 Overview of Scripting
2.2 The <cfscript> Tag
2.3 Assigning Variables
2.4 Conditional Processing
2.5 Looping
2.6 Invoking Objects
2.7 Creating Functions
2.8 Error Handling
2.9 Review

3.0 Dynamic Functions
3.1 Overview of Dynamic Functions
3.2 Using Dynamic Functions
3.3 Review

4.0 Stored Procedures
4.1 Overview of Stored Procedures
4.2 <cfquery> vs. <cfstoredproc>
4.3 Using the <cfstoredproc> Tag
4.4 Multiple Recordsets
4.5 Review

5.0 Transactions
5.1 Overview of Transactions
5.2 Using Transactions
5.3 Control Commits
5.4 Review

6.0 Level Summary

1.0 Introduction
1.1 Level Overview

2.0 Debugging
2.1 Overview of Debugging
2.2 ColdFusion Debugging
2.3 Manual Debugging
2.4 Log Files
2.5 Review

3.0 Error Handling
3.1 Overview of Error Handling
3.2 Exception Handling
3.3 Sitewide Error Handler
3.4 Review

4.0 Application Security
4.1 Overview of Application Security
4.2 Implementation
4.3 Using Application Security
4.4 Advanced Options
4.5 Review

5.0 Level Summary

1.0 Introduction
1.1 Level Overview

2.0 Custom Tags
2.1 Overview of Custom Tags
2.2 Simple Custom Tags
2.3 Calling Custom Tags
2.4 Attributes
2.5 CALLER Scope
2.6 Review

3.0 Advanced Custom Tags
3.1 Overview of Advanced Custom Tags
3.2 Tag Pairs
3.3 Tag Families
3.4 The <cfassociate> Tag
3.5 Review

4.0 User-Defined Functions
4.1 Overview of User Defined Functions
4.2 Tag-Based UDFs
4.3 <cfscript> Based UDFs
4.4 Using UDFs
4.5 Advanced UDF Use
4.6 Organizing UDFs
4.7 Review

5.0 ColdFusion Components
5.1 Overview of ColdFusion Components
5.2 Creating Components
5.3 Invoking Components
5.4 Advanced Component Use
5.5 Securing Components
5.6 Documenting Components
5.7 Review

6.0 Level Summary

1.0 Introduction
1.1 Level Overview

2.0 Basic SQL
2.1 The SELECT Statement
2.2 The INSERT Statement
2.3 The UPDATE Statement
2.4 The DELETE Statement
2.5 Review

3.0 Joins
3.1 Overview of Relational Databases
3.2 Basic Joins
3.3 Inner Joins
3.4 Outer Joins
3.5 Self-Joins
3.6 Review

4.0 Aggregates
4.1 Overview of Aggregates
4.2 Using Aggregates
4.3 Grouping Results
4.4 Filtering Results
4.5 Review

5.0 Advanced Database Features
5.1 Overview of Advanced Features
5.2 Constraints
5.3 Indexes
5.4 Stored Procedures
5.5 Triggers
5.6 Review

6.0 Improving Performance
6.1 Overview of Improving Performance
6.2 Eliminating Unnecessary Access
6.3 Using Bind Parameters
6.4 Review

7.0 Level Summary

1.0 Introduction
1.1 Level Overview

2.0 Web Services
2.1 Overview of Web Services
2.2 Consuming Web Services
2.3 Creating Web Services
2.4 Review

3.0 Extending ColdFusion
3.1 Overview of Extending ColdFusion
3.2 Java
3.3 COM
3.4 CORBA
3.5 CFX
3.6 Review

4.0 XML
4.1 Overview of XML
4.2 XML in ColdFusion
4.3 Advanced XML
4.4 Review

5.0 WDDX
5.1 Overview of WDDX
5.2 XML and WDDX
5.3 The <cfwddx> Tag
5.4 Review

6.0 Event Gateways
6.1 Overview of Event Gateways
6.2 Using Gateways
6.3 The SMS Gateway
6.4 Review

7.0 Flash Remoting
7.1 Overview of Flash Remoting
7.2 Using Flash Remoting
7.3 Review

8.0 Level Summary

1.0 Introduction
1.1 Level Overview

2.0 Full-Text Searching
2.1 Overview of Full-Text Searching
2.2 Verity Collections
2.3 Creating a Search Interface
2.4 Review

3.0 System Integration
3.1 Overview of System Integration
3.2 Server File Management
3.3 Registry Integration
3.4 Executing from the Command Line
3.5 Review

4.0 Scheduling and Event Execution
4.1 Overview of Scheduling and Event Execution
4.2 Scheduling Events
4.3 Alternative Scheduling Options
4.4 Review

5.0 Email Integration
5.1 Overview of Email Integration
5.2 Sending Email
5.3 Retrieving POP Mail
5.4 Review Question

6.0 LDAP
6.1 Overview of LDAP
6.2 Connecting to LDAP
6.3 Review

7.0 HTTP and FTP Protocols
7.1 Overview of HTTP and FTP Protocols
7.2 Using HTTP Agents
7.3 FTP Agents
7.4 Review

8.0 Level Review

1.0 Introduction
1.1 Level Overview

2.0 Application Tuning and Optimization
2.1 Overview of Application Tuning and Optimization
2.2 Nesting Guidelines
2.3 <cfcase> vs. <cfelseif>
2.4 Optimizing Conditional Expression
2.5 Avoiding Unnecessary Dynamic Expressions
2.6 Reusing Code
2.7 Variable Performance
2.8 Database Optimization
2.9 Using <cfcache>
2.10 Measuring Performance
2.11 Improving Perceived Response Time
2.12 Review

3.0 Server Performance Tuning
3.1 Overview of Server Tuning
3.2 Operating System
3.3 Web Server
3.4 Application Server
3.5 Keeping Tasks Separate
3.6 ColdFusion Administration Settings
3.7 Server Performance Monitoring
3.8 Review

4.0 Level Review

5.0 Course Review