Two-Day ColdFusion Course

You will learn:

Day 1

• What is Coldfusion
• Editions of ColdFusion
• ColdFusion Components
• Language Reference Features
• Using End Tags
• Resources
• Administering ColdFusion
• The Administrator
• Summary of Administrative Tasks
• Adding Data Sources
• ColdFusion Tags
• CFINCLUDE
• Create a coldfusion page
• Elements of ColdFusion Expressions
• Date-and-time values
• Escaping
• Using Variables
• Testing the existence of a variable
• CFML comments
• Building a Query
• Add a data source with the Administrator
• Retrieving Data using CFQUERY
• Display data from a database to the web page
• Create a Query to retrieve data
• Write a ColdFusion page to retrieve all its records
• Display your retrieved data and order it
• Output a Maximum number of record rows
• Insert records in a database through a web interface
• Find the number of Records in a database Using RecordCount
• Writing SQL statements
• Basic SQL Syntax elements
• Form and form action file to process the form
• Creating Action Pages
• Setting conditions in your QUERY
• Linking & passing variables to another page
• Passing variables using url and ParameterExists
• Incorporate Java applet in your ColdFusion page
• Create form and input types using CFFORM and CFINPUT
• Create drop-down list box form control using ColdFusion tags
• Create a Slider Control in your ColdFusion page
• Create text-entry box with input validation and font characteristics
• Output and format Data to a web page from a Query
• Looping and Display Query output
• Setting Cookies
• Exception Handling using CFTRY CFCATCH

Day 2

• Operators
• Shorthand notations
• Manipulation of Database
• Insert new records through web interface using CFINSERT
• Update database through web interface using CFUPDATE
• Flow control using CFIF CFELSEIF CFELSE3
• Using CFFILE
• Repeat instructions using CFLOOP
• Looping over a Query
• Using CFMAIL
• Using CFMAILPARAM
• Using CFSCRIPT
• Using CFSILENT
• CFSWITCH CFCASE CFDEFAULTCASE
• Date and Time Functions
• Decision Functions
• Using isarray
• Using ParameterExists
• Using isnumerdate
• String functions
• Using max
• Using Mid
• Using RemoveChars
• Using Replace
• Using Val
• Mathematical Functions
• Using fix
• Using rand
• Using rand
• Using RandRange
• Display and Formatting Functions
• Using DollarFormat
• Using FormatBaseN
• Using YesNoFormat
• Using ParagraphFormat
• Using TimeFormat
• Dynamic Evaluation Functions
• DE
• Using iif
• International Functions
• List Functions
• Using ListGetAt
• Using ListDeleteAt
• Using ListSort
• Query Functions
• Create user logon page and user login name and password verification
• Create a search page

Date: Monday 20 September and Tuesday 21 September 2010

Cost: $660 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk