Adobe ColdFusion MX Training DVD

Introduction

• welcome

1. Introducing ColdFusion

• understanding ColdFusion
• installing
• using the ColdFusion administrator
• setting up the web server
• selecting an editor

2. Learning CFML Basics

• working with variables
• using numbers
• setting variables
• using strings
• viewing variable values
• retrieving query string variables
• retrieving form variables
• building a storyteller application
• adding conditional logic
• checking if variables are defined
• self posting form
• amending the storyteller application part 2
• dynamically including templates
• amending the storyteller application part 3
• ColdFusion parameters
• defining default values
• understanding default values in context
• using CFPARAM
• using default values with text inputs
• amending the storyteller application part 4

3. Managing Code

• adding code comments
• debugging code

4. Working with Databases

• understanding databases
• designing databases
• selecting database management system
• creating a database
• registering a ColdFusion datasource
• configuring the database

5. Using SQL

• understanding SQL
• using SELECT statements
• selecting fields
• adding WHERE clauses
• selecting data from more than one table
• outputting query data
• building a user list application
• viewing details
• building user list details
• adding ORDER BY clauses
• ordering the user list
• making pageable record sets
• making the userlist pageable
• ordering the user list
• adding a records per page feature
• cleaning up the user list
• cleaning up the user list part 2
• matching partial values
• matching partial values note
• searching the user list
• selecting multiple list items
• using IN
• filtering the user list
• caching queries
• caching the user list query
• inserting records
• registering users
• registering users part 2
• registering users part 3
• pre-filling a form
• registering users part 4
• registering users part 5
• validating form input
• registering users part 6
• updating records
• redirecting pages
• looping through queries
• editing user information
• editing user information part 2
• editing user information part 3
• deleting records
• delete confirmation screen
• deleting users

6. Managing Applications

• adding an application framework
• specifying a datasource variable
• adding login functionality
• adding login functionality part 2
• building a login application
• building a login application part 2
• getting the user information
• adding conditional logic based on user
• logging out
• checking for roles
• making the administrator role
• hiding the register option for users that are logged in
• adding administrator subnavigation
• adding a user update form

7. Dates and Times

• creating a dates and times
• formatting dates and times
• parsing dates and times
• introducing CFLOOP
• creating a calendar
• creating a calendar part 2
• inserting dates and times into a database
• adding events to the calendar application
• adding events to the calendar application part 2
• using BETWEEN in SQL
• listing events in the calendar application
• adding an event details page
• adding an event update form
• adding an event update form part 2
• adding an event delete option

8. Storing Client-side Data

• using CFCOOKIE
• building a color panel feature
• building a color panel feature part 2
• building a color panel feature part 3
• building a color panel feature part 4
• understanding MOD
• building a color panel feature part 5
• adding automatic apply JavaScript

9. Ordered Data

• introducing arrays
• looping through arrays
• sorting arrays
• using lists
• filtering user list data
• working with structures
• using array access notation with structures
• looping through structures
• creating arrays of structures
• enabling sessions
• adding session variables
• building a store application
• adding a store product list
• building an add to cart feature
• listing the cart items
• managing duplicate items
• deleting items
• updating items
• checking out
• listing the order
• deleting the order

10. Advanced SQL and Charting

• using SQL function
• working with GROUP BY
• using additional SQL functions
• charting data
• adding a user report chart
• applying chart styles

11. Email

• using CFMAIL
• adding a password retrieval feature

12. Working with Files

• using the ExpandPath() function
• using file fields
• uploading files
• adding an update image feature
• adding an update image feature part 2
• writing new files
• emailing charts
• writing charts to files
• emailing attachments
• emailing charts as attachments

Conclusion

• goodbye