Adobe Dreamweaver CS4: Dynamic Application Development

Prerequisites:

Be comfortable with what is required to develop a static web application and have completed the Dreamweaver Introduction course.

Course Description:

On 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.

By the time students are finished with this course they will have knowledge of basics of Dynamic App Dev, overview of ColdFusion Administrator, basics of Drill-Down Interface, Building Recordsets and Binding Data to a Pages, Server Debug Options, SQL - INSERT, UPDATE, SELECT, and DELETE, ColdFusion Security and Login, Creating a Dynamic Search Interface, Database Panel and Application Wizards.

This course includes the following modules:

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 Adobe ColdFusion
• Working with sites in Adobe Dreamweaver
• Learning Adobe 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

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

Authenticating Users

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