Database-Driven Websites with Dreamweaver CS3 (3 days)

Database-Driven Websites with Dreamweaver CS3 Overview

This Dreamweaver training class teaches students how to use Dreamweaver CS3 to build dynamic database-driven web sites. These sites can be built using ColdFusion , PHP or Active Server Pages.

Database-Driven Websites with Dreamweaver CS3 Course Goals

• Learn to create database-driven web sites with Dreamweaver
• Learn to pass data between pages
• Learn to send email from a web page
• Learn to send build a search interface
• Learn to send build create registration and login pages

Database-Driven Websites with Dreamweaver CS3 Course Prerequisites

Experience in the following areas is required:

• Basic Dreamweaver

Experience in the following areas would be beneficial.

• HTML
• SQL

Database-Driven Websites with Dreamweaver CS3 Course Outline

1. Dynamic Web Sites
   1. Dynamic Web Site Basics
   2. Developing with a Local Server
   3. Developing with a Remote Server
   4. Defining a Dynamic Site in Dreamweaver
   5. Building a Simple Dynamic Application
2. Passing Data Between Pages
   1. Understanding the HTTP Protocol
   2. Retrieving Data from the URL
   3. Sending Data with Hyperlinks
   4. Setting and Retrieving Cookies
3. Sending Email from a Web Form
   1. Introducing SMTP Email Service
   2. Configuring your System to Send SMTP Email Messages
   3. Configuring your System to Send Email
   4. Writing the Code to Send a Message
   5. Understanding Objects, Methods, and Properties
   6. Creating the Web Form
   7. Emailing Dynamic Form Values
   8. Client-Side Form Validation
4. Building a Tour Price Calculator
   1. Creating the Pages
   2. Building the Form
   3. Collecting, Processing, and Displaying the Data
   4. Adding Server-Side Form Validation
   5. Creating the Conditional Region
   6. Creating and Applying a Custom CSS Class
   7. Databases on the Web
   8. Introduction/Review of Databases
   9. Introduction to the Database Used in Class
   10. Connecting to the Database
   11. Retrieving Recordsets and Displaying Database Information
5. Completing the Price Calculator
   1. Dynamically Populated Drop-Down Menus
   2. Creating Filtered Recordsets
   3. Revising the Calculation Script with Live Data
   4. Documenting Your Code with Comments
6. Filtering and Displaying Data
   1. Preparing the Input Page
   2. Generating URLs Dynamically
   3. Preparing the Output Page
   4. Populating Page Layouts Dynamically
   5. Adding Dynamic Images and Formatting the Population Number
   6. Looking Up Foreign Table Data with SQL
   7. Building the Tour Descriptions
   8. Planning the Application
   9. Creating Recordsets with Joins
   10. Building the Descriptions
   11. Inserting the Images and the ALT Attributes
   12. Implementing the Recordset Paging
   13. Passing Data to Other Applications
7. Building Search Interfaces
   1. Preparing the Search Page and Creating the Search All Link
   2. Searching by Region: Building the Interfaces
   3. Searching by Country: Filtering by Form Variable
   4. Switching SQL Statements According to Environment Variables
8. Authenticating Users
   1. User Authentication as a Web Application
   2. Building the Registration Pages
   3. Building the Log-in Page
   4. About Session Variables
   5. Restricting Access to Pages
   6. Managing Content with Forms
9. Creating the Admin Section
   1. Creating the Form Interface
   2. Using Session Variables and Hidden Fields to Track Users
   3. Inserting the Record
10. Building Update Pages
    1. Preparing the Pages
    2. Planning for the Master-Detail Pages
    3. Making the Detail Page Updateable

Database-Driven Websites with Dreamweaver CS3 Course Materials

Each student will receive a copy of Adobe Dreamweaver CS3 with ASP, ColdFusion, and PHP: Training from the Source by Jeffrey Bardzell, which will serve as a guide for the class.

Database-Driven Websites with Dreamweaver CS3 Technical Requirements

1. Adobe Dreamweaver CS3
   • Download
   • System Requirements
2. Browser Options
   • Internet Explorer 6.0 or later
     • Download
   • Firefox
     • Download
   • Safari
     • Download
3. Operating System Options
   • Windows Vista
   • Windows XP with Service Pack 2
4. Internet Information Services
   • Instructions
5. Microsoft Access 2000 or later

Class Files for Database-Driven Websites with Dreamweaver CS3

The class files for this course are included on a CD that is shipped with the book.