Dreamweaver : coldfusion application development

Overview
Adobe Dreamweaver CS3: ColdFusion Application Development provides students with the knowledge and hands-on practice they need to build and manage dynamic websites using Dreamweaver and ColdFusion. In this course, you'll learn how to connect to a database, search and display results, and build a page to update the database. If you've always dreamed of building a more advanced, data-powered site, but didn't know where to start, then this course is for you.

Prerequisites
This course is for people new to Dreamweaver (or who have used it only to build static web sites) that want to use it to create data-driven web applications. To take this course, you should: · Be comfortable working with the Windows or Macintosh operating system. · Be familiar with web terminology. · Be comfortable with what is required to develop a static web application. · Have completed the Adobe Dreamweaver CS3: Website Development course or have equivalent experience.

Course Content Introducing the Course

• Understanding the course format
• Reviewing the course objectives and prerequisites
• Looking at the course outline

Getting Started

• Understanding static vs. dynamic pages
• Introducing ColdFusion
• Working with sites in Dreamweaver
• Learning Dreamweaver interface basics
• Developing dynamic pages
• Including common code

Using the Database Panel

• Using databases on the web
• Creating a database connection
• Using the Database panel
• Using the Bindings panel to create a simple recordset
• Creating an advanced recordset using joins

Binding Data to a Page

• Binding data to a page
• Using Live Data View
• Formatting data using the Bindings panel
• Inserting a dynamic image

Customizing Recordset Display

• Introducing Server Behaviors
• Displaying all rows in a recordset using Repeat Region
• Introducing Application Objects
• Using the Recordset Navigation Bar to page through recordsets
• Displaying Recordset Navigation Status
• Using the Server Debug View

Creating Drill-down Interfaces

• Creating a drill-down interface
• Generating dynamic links
• Using dynamic filters in SQL
• Using the Dynamic Table Application Object
• Creating a master-detail page set

Creating a Search Interface

• Reviewing HTML Forms
• Creating dynamically populated drop-down menus
• Creating filtered recordsets

Inserting Rows into a Table

• Creating a form and using the Insert Record Server Behavior
• Validating form data using Behaviors
• Creating dynamic form elements
• Using the Recordset Insertion Form Application Object

Updating Rows

• Creating an interface for updating data
• Displaying results in a table using the Dynamic Table Application Object
• Creating a pre-filled form for the row to update
• Using URL parameters
• Using the Record Update Form Application Object
• Manually creating a form and applying an Update Record Server Behavior

Deleting Rows

• Understanding the delete process
• Creating a delete confirmation page
• Passing hidden data in a form
• Using a SQL Delete statement
• Using the Delete Row Application Object

Unix

• Learning the basics of SQL (Structured Query Language)
• Basic Select, Insert, Update and Delete commands
• Ordering Results
• Filtering Results

Authenticating Users

• Setting and retrieving cookies
• Authenticating users with a web application
• Building the registration pages
• Building the log-in page
• Creating a ColdFusion Application.cfm
• Restricting access to pages