Training Course: ColdFusion MX - Level 2

Training Course Summary:

This is the second course in the ColdFusion MX series of courseware. In the first course, you created dynamic non-database-driven Web sites with ColdFusion MX. Most professionally-built Web sites are powered by a database. So, in this course, you will build dynamic, database-driven Web sites.

Pre-Requisites:

Students taking this course should first complete the ColdFusion MX: Level 1 course or have equivalent knowledge. Students will be especially well-prepared if they also take the SQL: Fundamentals of Querying and Relational Database Design courses or have equivalent knowledge before attending this course.

Who Should Attend:

The target student for this course is someone who has added dynamic features to their Web site using ColdFusion MX and is looking to connect their Web site to a database. They are someone who will be developing their own solutions rather than using off-the-shelf components, someone who might be familiar with another programming language, or someone who has used UltraDev to develop their ColdFusion solutions. It is likely that their primary job responsibility is creating Web pages.

Training Course Overview/Content:

Displaying Database Information on a Web Page
Plan a Database-driven Site
Connect to a Database
Retrieve Data from the Database
Query a Query

Creating a Data Drill-down Application
Plan a Data Drill-down Application
Build the Drill-down Output

Displaying Subsets of Data on Demand
Plan the Recordset Navigation Scheme and Components
Enable Recordset Navigation
Output the Number of Next and Previous Records
Format Output of Data Based on the Plan

Adding Search Features
Plan the Search Feature
Create a Dynamic Search Form
Develop the Search Results Template
Handle “No Records Found” Conditions
Add Single-keyword Search Functionality
Add Multiple-keyword Search Functionality

Creating Reusable Code
Create a User Defined Function
Create a Custom Tag
Prepare a Custom Tag to be Shared