Cold Fusion MX: Level 2
Class Outline:
Length: 1 Day
Course Description:
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.
Course Objective:
You will retrieve information from a database and display it on a Web page, enable drill-down functionality through which users can view detailed information on demand, display subsets of data through a recordset navigation system, enable database-driven searching capabilities, and add email sending features to your Web site.
Course Content:
Lesson 1: Displaying Database Information on a Web Page
Topic 1A: Plan a Database-driven Site
Topic 1B: Connect to a Database
Topic 1C: Retrieve Data from the Database
Topic 1D: Query a Query
Lesson 2: Creating a Data Drill-down Application
Topic 2A: Plan a Data Drill-down Application
Topic 2B: Build the Drill-down Output
Lesson 3: Displaying Subsets of Data on Demand
Topic 3A: Plan the Recordset Navigation Scheme and Components
Topic 3B: Enable Recordset Navigation
Topic 3C: Output the Number of Next and Previous Records
Topic 3D: Format Output of Data Based on the Plan
Lesson 4: Adding Search Features
Topic 4A: Plan the Search Feature
Topic 4B: Create a Dynamic Search Form
Topic 4C: Develop the Search Results Template
Topic 4D: Handle ?No Records Found? Conditions
Topic 4E: Add Single-keyword Search Functionality
Topic 4F: Add Multiple-keyword Search Functionality
Lesson 5: Creating Reusable Code
Topic 5A: Create a User Defined Function
Topic 5B: Create a Custom Tag
Topic 5C: Prepare a Custom Tag to be Shared