Course Synopsis: This class provides you with the concepts and skills to use ColdFusion MX 7 effectively. This 3-day course will familiarize you with the ColdFusion development environment and the integration of other Adobe products, including Dreamweaver 8.

Who Should Attend: Experienced web developers will get the knowledge and hands-on practice they need to start building and maintaining dynamic and interactive Web applications. Students should be familiar with Web server technologies and the SQL command set, including SELECT, INSERT, UPDATE and DELETE.

Prerequisites: Because of the amount of material we cover in class, we do require students to be comfortable using a mouse, opening and saving files, and the general operations of computers. While we will make every reasonable effort to help, students with insufficient skills may be required to observe the class lessons or do their best to keep up without slowing down the rest of the class.

What You Will Learn:
• Setting Up ColdFusion development environment
• Using Dreamweaver 8
• Publishing dynamic data using ColdFusion tags
• Reusing common code
• Building forms with ColdFusion
• Building search interfaces
• Incorporating JavaScript to perform client-side validation
• Securing Web pages

Time: Class time is 9:00 a.m.- 4:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled 12-1. Students provide their own lunch.

Locations: We have company-operated facilities in Atlanta, Chicago, Denver, San Diego Washington DC and New Orleans. We also work with a network of rental facilities to offer our classes regularly across the United States and in Canada. Please double-check the location of your class with our office to make sure you get to the right location.

Related Courses: We recommend the following courses that relate to this class: Dreamweaver 8 ColdFusion Application Development, Advanced ColdFusionMX7 Development, and Dreamweaver 8 Web Site Development. Please take a look at our other course outlines.

Goals: Sterling Ledet and Associates realizes the importance of education and we take pride in being able to offer you classes that are more custom fit to your needs. Call us at (770) 414-5007 if you have any special questions or e-mail us at sales@ledet.com.

Registration: Please fill out our registration form and fax it to us at (312) 896-9094.

Adobe ColdFusion MX 7 Training Course Outline

LESSON 1
• Introducing to ColdFusion MX 7
• Advantages of dynamic pages
• ColdFusion Markup Language
(CFML)
• ColdFusion Components and
Features
• Configuring ColdFusion
Environments

LESSON 2
• Working with ColdFusion MX 7
• Exploring Dreamweaver 8
• Developing ColdFusion
Applications
• Creating Local Variables with
<cfset>
• Referencing Variables
• Displaying Variables Using
<cfoutput>
• Include Files Using the <cfinclude>
Tag
• Creating Comments

LESSON 3
• Understanding Relational Databases
• Using Database Drivers to Connect
to Data Sources
• Understanding the <cfquery> Tag
• ColdFusion Administrator
Debugging
• Using <cfoutput> to Display
Dynamic Data
• Using the Dynamic Table Tool
• Additional Information Returned
with Queries
• Using ColdFusion Functions

LESSON 4
• 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>

LESSON 5
• 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

LESSON 6
• Building a Drill-Down Interface
• Using Dynamic URL Parameters
• Creating a Query String
• Dynamic URL Parameters
• Creating a Drill-Down
• Data Drill-Down Page

LESSON 7
• 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
<cfl ocation>

LESSON 8
• Updating Data with ColdFusion
• Building an Update Form Page
• Providing the Primary Key for Update
• Pre-Filling the HTML Forms
• Building Update Logic with <cfquery>

LESSON 9
• Reusing Templates in ColdFusion
• Reusing Code
• Using Custom Tags
• Using User-Defined Functions
• Finding User-Defined Functions
• ColdFusion Components
• Finding ColdFusion Components

LESSON 10
• Securing and 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