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.
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.
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.
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.
Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Upon successful completion of this course, students will be able to:
- build a Web page that retrieves information from a database.
- create a data drill-down application in which Web pages retrieve detailed records based on user selections on Web pages that list summary record information.
- create an application that displays subsets of records selected from a database and enables the user to view other subsets on demand.
- add features to a database-driven Web site that enable users to search the database for records that meet their criteria and then have the results displayed in a Web page.
- create functions and custom tags that enable you to easily reuse code within a single page or across many pages.
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