Course Specifications
Course number: 085170Software: Adobe ColdFusion 8
Course length: 1.0 day(s)
Course Description
You have created dynamic, non-database-driven websites using Adobe ColdFusion 8. Most professionally-built and complex websites are powered by a database. In the Adobe ColdFusion 8: Level 2 course, you will build dynamic, database-driven websites.
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 features that lets you build reports and add charts to your website.Target Student: The target students for this course are those who have added dynamic features to their website using ColdFusion 8.0 and who want to connect their website to a database. They are those who will be developing their own solutions rather than using off-the-shelf components, those who might be familiar with another programming language, or those who have used UltraDev to develop their ColdFusion solutions. It is likely that their primary job responsibility is creating web pages.
Prerequisites: Students taking this course should first complete the Adobe ColdFusion 8: 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.
Performance-Based Objectives
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 enables users to search the database for records and have the results displayed on a web page.
- create functions and custom tags.
- create reports, charts, and forms.
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 a Drill-Down Application
- Lesson 3: Displaying Subsets 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 a Single-Keyword Search Functionality
- Topic 4F: Add a Multiple-Keyword Search Functionality
- Topic 4G: Enhance the Search Functionality with the Verity Search Engine
- 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
- Lesson 6: Working with Reports, Charts, and Forms
- Topic 6A: Create Reports in ColdFusion
- Topic 6B: Create a Basic Chart
- Topic 6C: Create an AJAX Form
