English French German Italian Portuguese Russian Spanish

logo_old

  • Adobe Training

    adobeInterSource offers live instructor-led courses on all Adobe technologies, including Acrobat, ActionScript, AfterEffects, Captivate, ColdFusion, Contribute, Dreamweaver, Fireworks, Flash, Flex, FrameMaker, Illustrator, InDesign,Photoshop, Premiere Pro, and RoboHelp.

    Please refer to our detailed course outlines below.

  • About Adobe

    Following the acquisition of its former arch-rival Macromedia, Adobe Inc. has assumed a place of unrivalled dominance in the fields of multimedia, graphic and print production. In many of these domains, Adobe products are the technology-defining industry standards. These include:

    • Photoshop, InDesign, Fireworks and Illustrator to create and manipulate documents and images;
    • ColdFusion and Content Server for database management and server requirements;
    • Flash and Flex and for more interactive, dynamic sites and rich internet applications;
    • FrameMaker for authoring documents and creating efficient, reusable templates;
    • Acrobat, for creation of Portable Document Format (PDF), the industry standard for portable content;
    • Dreamweaver and Adobe Contribute for Web design;
    • Premiere Pro and Adobe After Effects for Video editing and visual effects.
    • RoboHelp for providing context-sensitive Help internal to the application;
    • and finally Adobe Captivate for the creation of eLearning software.

    Extensive product descriptions, video demonstrations, and trial downloads are available for each application at the Adobe website.

    Read More
  • Course Details Adobe

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative date, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

Comprehensive ColdFusion Training

 PDF PrintEmail

Course duration

  • 5 Days

Course Outline

In this Comprehensive ColdFusion training course, students will spend the first part of the week learning the basics of ColdFusion and the second part of the week learning advanced ColdFusion techniques.

  • Learn to get data from a database and display it on the page
  • Learn to insert, Edit and Delete records from a database
  • Learn to pass data from one page and receive it on another using HTML Forms
  • Learn to create Dynamic Form Fields including Dynamic Select Lists
  • Learn to build a Search Interface
  • Learn to use Session Variables to provide Password Protection
  • Learn to call ColdFusion Components (CFCs) and Custom Tags
  • Learn to create and use complex data objects.
  • Learn to write <cfscript> code.
  • Learn to build and use Custom Tags.
  • Learn to build and use ColdFusion Components (CFCs).
  • Learn to handle errors properly.
  • Learn to page through recordsets.
  • Learn advanced form validation with regular expressions.
  • HTML
  • SQL
  • JavaScript
  • CSS
  1. Introduction to ColdFusion
    1. Static pages vs. Dynamic pages
    2. Server-side Web Technologies
    3. Database Alphabet Soup: ODBC/JDBC, DSNs and SQL
    4. Course Objectives and Prerequisites
    5. Introduction to Course Project
  2. ColdFusion Basics
    1. Using CFML
      1. Code Editors
      2. Dreamweaver Interface
      3. Tag Updaters / Extensions
      4. Tag Editing Dialog Boxes
    2. Embedded Tag Help
    3. Using ColdFusion Comments
    4. Creating Variables
      1. <cfset> and <cfoutput>
    5. Variable Scope/Prefixes
    6. Built-in ColdFusion Functions
      1. CF Function Reference (Dreamweaver specific)
      2. Online Reference (http://livedocs.adobe.com)
      3. Tip: (http://cfquickdocs.com)
    7. Using <cfinclude> to reuse code
  3. Dynamic Data: Querying the Database
    1. Database Basics
      1. Introduction to SQL
      2. Select Statement
      3. Update Statement
      4. Insert Statement
      5. Delete Statement
      6. Data Source Name (DSN) / Remote Development Server (RDS)
      7. The DSN Used in This Class: movieList
    2. Course Project Database
    3. Querying the database with <cfquery>
      1. <cfdump> for Quick Output
    4. Customizing Display with <cfoutput>
      1. Building Dynamic Tables
      2. Shortcut: <cftable>
      3. Shortcut: Dynamic Table Tool (in Dreamweaver)
  4. Creating a Drill-down Interface
    1. Passing Variables between Pages
      1. "Two-page method"
    2. Receive Variables through the URL
      1. Using a WHERE clause in a SQL Statement
      2. Protecting Against SQL Injection Attacks with <cfqueryparam>
  5. Conditional Statements and Forms
    1. Conditional Statements
      1. <cfif>, <cfelseif> and <cfelse>
      2. Comparison Operators
      3. Operator
      4. Description
      5. Using the isDefined() function
    2. HTML Form Review
    3. Self-Submitting Forms
      1. Using the <cfparam> tag to set a default value
      2. Quick Examination of a ColdFusion Framework (Methodology): Fusebox
    4. Dynamically Populating Select Lists
      1. HTML Review: <select> tags
      2. Introducing the <cfform> Tag
      3. Shortcut: <cfselect>
  6. Quick Introduction to RSS and Ajax with <cfform>
    1. Reading an RSS Feed
    2. Introducing the <cfform> Tag
    3. Building a Mask with <cfform>
    4. Automatically Build a Dynamic Select List with <cfselect>
  7. Search Interface
    1. Creating a Search Interface
      1. Using % and _ in a LIKE Statement
  8. Insert Records into the Database
    1. Inserting Records
      1. SQL Insert Statement
      2. Insert Record Step 2 - the Insert
      3. Shortcut: <cfinsert>
      4. Redirect Users with <cflocation>
    2. Automated Form Validation
      1. Client-side vs. Server-side validation: When does the validation code run?
  9. Edit (Update) Database Records
    1. Updating records
      1. SQL UPDATE Statement Review
      2. Passing the Primary Key
      3. Page 2 - View Current Data in a Form
      4. Page 3 - Perform the Update to the Database
      5. Shortcut: <cfupdate>
    2. Deleting Records
      1. Note on Deleting records
      2. Review of the SQL Delete Statement
      3. "Deleting" without deleting
      4. No <cfdelete>!
  10. Reusing Code
    1. Reusing code with <cfinclude> and <cflocation>
    2. Custom Tags
      1. Where to store Custom Tags
      2. CALLER and ATTRIBUTE scopes
      3. Using <cfmodule>
      4. A Note about CFX tags
    3. User Defined Functions (UDFs) and ColdFusion Components (CFCs)
      1. Creating UDFs with the <cffunction> tag
      2. Using ColdFusion Components (CFCs)
    4. Creating Components
      1. Calling or Invoking Components
      2. Passing Arguments to Components
      3. The Component Code
      4. The main CFML page
      5. View a Component directly in the browser
  11. Using Session Variables for Password Protection
    1. Session Variables
      1. Using Application.cfc to Enable Session Management
      2. Creating Password Protected Pages
      3. Password-protect.cfm (the included page)
      4. Application.cfm
      5. Locking Session and Application variables with <cflock>
  12. Tracking User Information with Cookies (optional)
    1. Using Cookies to Track Users
  13. Sending email with <cfmail> (optional)
    1. Using ColdFusion to Send Email
      1. <cfmail> Tag Syntax
  14. Charting
    1. Course Introduction and <cfchart>
      1. Introduction
      2. Course Objectives
      3. Course Prerequisites
      4. Course Project
    2. Charting and Graphing Options
      1. Using <cfchart> vs. <cfchartseries>
      2. Caching Charts
  15. Complex Objects
    1. Manipulating Complex Data Objects (Lists, Arrays, Structures and Queries)
      1. Scalar Variables
      2. Lists
      3. Arrays
      4. Structures
    2. Looping with <cfloop>
      1. Syntax of <cfloop>
      2. Weeding Out the FIELDNAMES Variable
      3. Using <cfloop> for automatic query output
      4. Display Web-safe Colors using CFLOOP
    3. Queries of Queries
  16. Components
    1. CFCs - Building ColdFusion Components
      1. Benefits to using CFCs
      2. Creating Components
      3. Calling or Invoking Components
      4. Passing Arguments to Components
      5. The main CFML page
      6. Three Ways to Pass Arguments
      7. Where to save CFCs
      8. Self-documenting - View a Component directly in the browser
    2. Object-Oriented CFCs
      1. Object-Oriented Principles
      2. How does use of a CFC compare to other OO languages?
      3. Inheritance
      4. Access control
      5. Exposing CFCs as Web Services
  17. Application Framework
    1. Application Framework
      1. Automatic Includes: Application.cfm and onRequestEnd.cfm
      2. New Application Framework: Application.cfc
    2. Using Application Variables
  18. Error Handling
    1. Errors and Exceptions
      1. Standard Error Handling
      2. Application.cfm
    2. Structured Error Handling
      1. <cftry> and <cfcatch>
      2. Transactions with <cftransaction> and <cftry>
      3. Classic <cftransaction> example
  19. Reusing Code
    1. Reusing Code
      1. Limited Capabilities of <cfscript>
      2. Syntax Rules
      3. Reserved Words
      4. Looping with <cfscript>
      5. GetTickCount() - testing the speed of your code
    2. Custom Tags
      1. Where to store Custom Tags
      2. CALLER and ATTRIBUTE scopes
      3. Using <cfmodule>
    3. Stored Procedures
      1. Benefits of Stored Procedures
    4. Showing portions of a Recordset
      1. Paging through records
  20. Regular Expressions (optional)
    1. Advanced Validation with Regular Expressions (optional)
      1. Special Symbols for Matching Specific Characters
      2. Specify the number of occurrences
      3. Placement of the pattern
      4. POSIX Syntax
      5. Perl Syntax

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.