ColdFusion MX Training Course in Los Angeles
Databases and SQL
Training
Provided by American Media Training
Macromedia ColdFusion MX Authorized Training Courses offered by American Media Training. We have open enrollment courses in the following cities across America: Los Angeles, San Diego, Phoenix, Denver, Miami, Boston, Chicago, Atlanta and Houston. We also deliver on-site Flash Training on all levels anywhere in the USA
|
|
||||||||||||||
ColdFusion MX Training Course in Los Angeles
ColdFusion training course outline - Los Angeles
Setting up the ColdFusion development environment
Using ColdFusion MX
Publishing dynamic data using ColdFusion tags
Reusing common code
Building forms with ColdFusion MX
Building search interfaces
Building data drill-down interfaces
Accepting user information for updating and inserting data in databases
Incorporating JavaScript to perform client side validation
Securing web pages
Prerequisites:
To gain the most from this class, you should already:
A familiarity with Web terminology
An understanding of Web server characteristics
Experience with the HTML tag set and syntax
Familiarity with the SQL command set, including SELECT, INSERT, UPDATE, and DELETE
Objectives:
Upon completion of this course, students should be able to:
Set up and manage the ColdFusion MX 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
Outline:
Unit 1: Course Overview
About the course
Course objectives
Course prerequisites
Course format
Internet Applications: The Big Picture
Unit 2: Introducing to ColdFusion MX
Advantages of dynamic pages
ColdFusion Markup Language (CFML)
ColdFusion MX Components and Features
Unit 3: Getting Started
Working with ColdFusion MX
Exploring ColdFusion MX
Developing ColdFusion Applications
ColdFusion MX Variables
Displaying Variables
Using ColdFusion MX Functions
Commenting Your Code
Unit 4: Publishing Database Content
Connecting to a Database
Querying a Database Table
Viewing Debug Data
Displaying Database Data
Renaming Query Columns
Using the Dynamic Table Tool
Additional Information Returned with Queries
Unit 5: Reusing Templates
Reusing Code
cfinclude
Creating ColdFusion MX Mappings
Using Custom Tags
Using User-Defined Functions
ColdFusion Components
Unit 6: Building Forms with ColdFusion MX
Understanding HTML Forms
Enabling Debug Output
ColdFusion MX and Forms
Conditional Processing
Testing Submitted Forms
Evaluating Form Variables
Dynamically Populating SELECT Controls
Unit 7: Building Search Interfaces
Using Form Data in Queries
Using Multiple Search Criteria
Text Searches
List Searches
Unit 8: Building a Data Drill-Down Interface
Using Dynamic URL Parameters
Data Drill-Down
Unit 9: Inserting New Data
Building an Insert Interface
Building an Insert Form Page
Server-Side Validation
Building an Insert Action Page
Redirecting a URL
Unit 10: Updating Data
Updating Database Data
Building an Update Form Page
Pre-Filling HTML Forms
Client-Side Validation
Server- Side Versus Client-Side Validation
Building an Update Action Page
Unit 11: Maintaining Session State
Addressing the Web's Statelessness
The Application Framework
Application.cfm Variables
cflogin
Setting up the ColdFusion development environment
Using ColdFusion MX
Publishing dynamic data using ColdFusion tags
Reusing common code
Building forms with ColdFusion MX
Building search interfaces
Building data drill-down interfaces
Accepting user information for updating and inserting data in databases
Incorporating JavaScript to perform client side validation
Securing web pages
Prerequisites:
To gain the most from this class, you should already:
A familiarity with Web terminology
An understanding of Web server characteristics
Experience with the HTML tag set and syntax
Familiarity with the SQL command set, including SELECT, INSERT, UPDATE, and DELETE
Objectives:
Upon completion of this course, students should be able to:
Set up and manage the ColdFusion MX 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
Outline:
Unit 1: Course Overview
About the course
Course objectives
Course prerequisites
Course format
Internet Applications: The Big Picture
Unit 2: Introducing to ColdFusion MX
Advantages of dynamic pages
ColdFusion Markup Language (CFML)
ColdFusion MX Components and Features
Unit 3: Getting Started
Working with ColdFusion MX
Exploring ColdFusion MX
Developing ColdFusion Applications
ColdFusion MX Variables
Displaying Variables
Using ColdFusion MX Functions
Commenting Your Code
Unit 4: Publishing Database Content
Connecting to a Database
Querying a Database Table
Viewing Debug Data
Displaying Database Data
Renaming Query Columns
Using the Dynamic Table Tool
Additional Information Returned with Queries
Unit 5: Reusing Templates
Reusing Code
cfinclude
Creating ColdFusion MX Mappings
Using Custom Tags
Using User-Defined Functions
ColdFusion Components
Unit 6: Building Forms with ColdFusion MX
Understanding HTML Forms
Enabling Debug Output
ColdFusion MX and Forms
Conditional Processing
Testing Submitted Forms
Evaluating Form Variables
Dynamically Populating SELECT Controls
Unit 7: Building Search Interfaces
Using Form Data in Queries
Using Multiple Search Criteria
Text Searches
List Searches
Unit 8: Building a Data Drill-Down Interface
Using Dynamic URL Parameters
Data Drill-Down
Unit 9: Inserting New Data
Building an Insert Interface
Building an Insert Form Page
Server-Side Validation
Building an Insert Action Page
Redirecting a URL
Unit 10: Updating Data
Updating Database Data
Building an Update Form Page
Pre-Filling HTML Forms
Client-Side Validation
Server- Side Versus Client-Side Validation
Building an Update Action Page
Unit 11: Maintaining Session State
Addressing the Web's Statelessness
The Application Framework
Application.cfm Variables
cflogin
About The Training Provider: American Media Training
American Media Training - American Media Training offers Macromedia, Adobe, Quark and Apple Certified training courses across the United States. We are based in Los Angeles with training partners in Phoenix, AZ, Denver, CO, Atlanta GA, Miami, FL, Boston, MA, Chicago, IL. We have open enrollment courses in these cities and also offer on-site training nationwide. Our courses are hands-on instructor led.
