Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

Building Database-Driven Web Sites Using Dreamweaver

2 day course

View Detailed Outline in PDF format

Get Adobe Reader

Dreamweaver is typically under utilized concerning its database connectivity features.  Dreamweaver has merged its easy-to-use interface with the robust database integration features of UltraDev and Drumbeat, Macromedia's previous Web-to-database development tools.  Dreamweaver inherits sophisticated source code editing and help facilities from Homesite.  Its current incarnation supports the major server side technologies Classic ASP, PHP, Coldfusion, ASP.NET and JSP.  Skills you will develop through this course include how to choose a web-to-database integration architecture, manage data by building interfaces for managing records from a database, understand SQL fundamentals, build and validate database-driven forms, send email via server-side technology, and test applications before they are deployed.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Introducing Dreamweaver

  • What is Macromedia Dreamweaver?
  • The role of middleware technologies
  • Choosing among ASP, ASP.NET, JSP, PHP, and ColdFusion

Introducing the Dreamweaver Interface

  • The Dreamweaver interface
  • Defining a site in Dreamweaver
  • Starting a site

Building Forms with Dreamweaver

  • Key considerations in designing your form
  • Building a simple form
  • Processing form results

Session Variables

  • Embedded scripts within ASP, ASP.NET and JSP
  • Storing values in the session object
  • Remembering visitors’ names w/session variables

An Overview of SQL

  • Data types in SQL
  • Creating a table in SQL
  • Retrieving info from the database via SELECT
  • Editing records in the database via UPDATE
  • Removing records from the database via DELETE

Defining a Database Connection

Defining a Recordset

  • Creating a Recordset in Dreamweaver
  • Advanced Recordset interface

Server Behaviors

Paging through a Recordset

  • Database cursors
  • Previous record and next record server behaviors

Selectively Showing Regions

Drilling Down with Master/Detail Pages

Inserting a Record

  • Inserting a new director
  • Inserting a new movie/populating a SELECT list

Client-Side Form Validations

  • What is JavaScript?
  • What are form validations?
  • Behaviors, events and actions
  • Implementing a form validation

Updating or Deleting Records

Multi-Table Queries

Using Stored Procedures and Views

  • What are views?
  • What are stored procedures?
  • Advantages of stored procedures
  • Using a view in Dreamweaver

Password Protection

XML and Dreamweaver

Web Services in Dreamweaver

Creating ODBC DSN Outside Dreamweaver

Dreamweaver MX Extensions

  • Sending Email with the CDO Mail Extension