Course Overview
ColdFusion 9 Fundamentals is a 3-day course that provides experienced Web developers with the knowledge and hands-on practice they need to start building and maintaining dynamic and interactive Web applications using ColdFusion 9
 
 
Objectives
Upon completion of this course, you should be able to:
- Set up and manage the ColdFusion 9 development environment
 
- Use ColdFusion Markup Language (CFML)
 
- Connect to a database
 
- Build queries that retrieve, insert, and update data dynamically
 
- Perform client-side and server-side validation
 
- Authenticate users and secure access to pages
 
- Use local, query, form, and URL variables
 
- Re-use code
 
- Incorporate custom tags, user defined functions, and ColdFusion components into your application
 
- Create a search form
 
- Build a data drill-down interface
 
- Develop fully interactive, database-driven web applications
 
 
Adobe Cold Fusion Essentials – 3 Days Schedule  
| 
 Day 1 
 | 
| 
 09.00am – 10.00am 
 | 
 Course Overview 
- About the course
 
- Course objectives
 
- Course prerequisites
 
- Course format
 
 
 | 
| 10.00am – 10.30am | 
 Breakfast 
 | 
| 
 10.30am – 12.45pm 
 | 
 Introducing ColdFusion 
- Advantages of dynamic web pages
 
- Using ColdFusion Markup Language (CFML)
 
- ColdFusion Components and Features
 
- Configuring ColdFusion environments
 
- Creating a site with Dreamweaver CS4
 
- Creating local variables with cfset
 
- Referencing variables
 
- Displaying variable values using cfoutput
 
- Including files using the cfinclude tag
 
- Creating comments
 
 
 | 
| 
 12.45pm – 02.15pm 
 | 
 Lunch 
 | 
| 
 02.15pm – 05.00pm 
 | 
 Publishing Database Content 
- Understanding Relational Databases
 
- Using Database Drivers to connect to data sources
 
- Understanding the cfquery tag
 
- ColdFusion Administrator debugging
 
- Using <cfoutput> to display database data
 
- Using the Dynamic Table Tool
 
- Additional information returned with queries
 
- Using ColdFusion Functions
 
 
 | 
| 
 Day 2 
 | 
| 
 09.00am – 10.00am 
 | 
 Building Forms with ColdFusion 
- Understanding HTML forms and form controls
 
- Enabling debug output
 
- Self-Posting forms
 
- Determining form submission with cfif and IsDefined()
 
- Evaluating form variables
 
- The cfparam tag
 
- Converting to ColdFusion forms
 
- Using cfselect
 
 
 | 
| 
 10.00am – 10.30am 
 | 
 Breakfast 
 | 
| 
 10.30am – 12.45pm 
 | 
 Building Search Interfaces 
- Using form data in dynamic queries
 
- Preserving form data
 
- Creating dynamic SQL
 
- Using multiple search criteria
 
- Creating a dynamic SQL statement
 
- Using text searches
 
- Using list searches
 
 
 | 
| 
 12.45pm – 02.15pm 
 | 
 Lunch 
 | 
| 
 02.15pm – 05.00pm 
 | 
 Building a Drill-Down Interface 
- Using Dynamic URL parameters
 
- Creating a Query String
 
- Dynamic URL Parameters
 
- Creating a data drill-down
 
- Data drill-down page
 
 
Inserting New Data 
- Building an Insert FORM Page
 
- Using ColdFusion Validation
 
- Using Client-side Validation
 
- Using Server-side Validation
 
- Creating Custom Validation
 
- Building Insert ACTION Logic
 
- Using cfquery with INSERT
 
- Redirecting Process Flow with the cflocation tag
 
 
 | 
| 
 Day 3
  
 | 
| 
 09.00am – 10.00am 
 | 
 Updating Data 
- Building an Update FORM Page
 
- Providing the primary key for update
 
- Pre-Filling HTML Forms
 
- Building Update Logic with cfquery
 
 
 | 
| 
 10.00am – 10.30am 
 | 
 Breakfast 
 | 
| 
 10.30am – 12.45pm 
 | 
 Reusing Templates 
- Reusing Code
 
- Using Custom Tags
 
- Using User-Defined Functions
 
- Finding UDFs
 
- ColdFusion Components
 
- Finding CFCs
 
 
 | 
| 
 12.45pm – 02.15pm 
 | 
 Lunch 
 | 
| 
 02.15pm – 05.00pm 
 | 
 Securing an Application 
- Using the ColdFusion Login Wizard
 
- Understanding the Login Pages
 
- Customizing the Login
 
- Using the Application Framework
 
- Using Application Events
 
- Using Application Variables
 
- Using Session Variables
 
 
 |