Applicable Job Roles: web programmers, and web application developers.

• Introducing ColdFusion
• Introducing CFML
• Setting Up Web Server
• Installing ColdFusion MX Server
• Installing ColdFusion Server or HomeSite Text Editor
• Setting up Variables using CFSET
• Variable Scope
• Introducing ColdFusion functions
• Displaying your variables using CFOUTPUT
• Commenting your code
• The CGI Scope

• Passing Data Between ColdFusion templates
• ColdFusion Expressions: data types, operators
• Conditional Logic CFI, CFSWITCH
• Exiting and Aborting Templates
• Redirecting to Another Template CFLOCATION

• Using ColdFusion Administrator to set up ODBC Data Source
• Introducing RDBMS model:
  • Understanding database relationships
  • Building a database model
  • Deploying the model: creating a database; creating tables
• Crash Course on Sequential Querying Language (SQL):
  • Querying a database - introducing CFQUERY
  • Retrieving data from the database using SELECT statement
  • SQL Operators

• Inserting data into a database using INSERT statement
• ColdFusion Forms
• Validating Form Data
• Handling Errors CFTRY, CFCATCH
• Including an outside code using CFINCLUDE

• Updating database Records using UPDATE statement
• Building an update form and action page
• Deleting database records using DELETE
• Building a delete form and action page
• File management - working with CFFILE
• Uploading Files and manipulating Files on the server

• Using CFMAIL tag to send email from your template
• Using CFMAILPARAM Tag
• Using CFPOP Tag
• Handling Attachments