Course Synopsis: Adobe Dreamweaver CS3: Application Development provides students with the knowledge and hands-on practice they need to build and manage dynamic websites using Dreamweaver CS3. 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.

Who Should Attend: 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 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.

Prerequisites:
Because of the amount of material we cover in class, we do require students to be comfortable using a mouse, opening and saving files, and the general operations of computers. While we will make every reasonable effort to help, students with insufficient skills may be required to observe the class lessons or do their best to keep up without slowing down the rest of the class. We highly recommend attending the Dreamweaver CS3: Website Development course before attending this class.

What You Will Learn:
• Basics of Dynamic Application Development
• Basics of Drill-Down Interface
• Building Recordsets and Binding Data to a Page
• Server Debug Options
• SQL - INSERT, UPDATE, SELECT, and DELETE
• ColdFusion Security and Login
• Creating a Dynamic Search Interface
• Database Panel and Application Wizards

Time: Class time is 9:00 a.m.- 4:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled 12-1. Students provide their own lunch.

Locations: We have company-operated facilities in Atlanta, Chicago, Denver, San Diego and Washington DC. We also work with a network of rental facilities to offer our classes regularly across the United States and in Canada. Please double-check the location of your class with our office to make sure you get to the right location.

Related Courses: We recommend the following courses that relate to this class: Fast Track to ColdFusion 8, Advanced ColdFusion 8 Development, Dreamweaver CS3 Web Site Development, and Flash CS3 Professional. Please take a look at our other course outlines.

Goals: Sterling Ledet and Associates realizes the importance of education and we take pride in being able to offer you classes that are more custom fit to your needs. Call us at (770) 414-5007 if you have any special questions or e-mail us at sales@ledet.com.

Registration: Please fill out our registration form and fax it to us at (312) 896-9094.

Adobe Dreamweaver CS3 Advanced Training Course Outline

LESSON 1:
Introduction
• Understanding the course format
• Reviewing the course objectives and
prerequisites
• Looking at the course outlines

LESSON 2:
Getting Started
• Understanding static vs. dynamic pages
• Working with sites in Dreamweaver
• Learning Dreamweaver interface basics
• Developing dynamic pages
• Including common code

LESSON 3:
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

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

LESSON 5:
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

LESSON 6:
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

LESSON 7:
Creating a Search Interface
• Reviewing HTML Forms
• Creating dynamically populated
drop-down menus
• Creating filtered recordsets

LESSON 8:
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

LESSON 9:
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

LESSON 10:
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

LESSON 11:
Authenticating Users
• Setting and retrieving cookies
• Authenticating users with a web application
• Building the registration pages
• Building the log-in page
• Restricting access to pages