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 CS3
• 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 by Jeffrey Bardzell, which will serve as a guide for the class.

Each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

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 Systems Options
   • Operating System Options
     • Windows Vista
     • Windows XP with Service Pack 2
   • Macintosh
4. Instead of installing a Web Server, Applications Server, and Database, you can select one of the following:
   • XAMPP (Apache, PHP, MySQL on Windows)
     • Download
   • MAMPP (Apache, PHP, MySQL on Macintosh)
     • Download
5. Web Server Options
   • Internet Information Services
     • Instructions
   • Apache HTTP Server
     • Download
     • System Requirements
6. Application Server Options
   • ColdFusion Application Server
     • Download
     • System Requirements
   • PHP 5.2 or later
     • Download
   • If using ASP Classic with IIS, no Application Server is required
7. Database Options
   • Microsoft Access 2000 or later
   • Microsoft SQL Server 2005
     • Download - Express Edition will work fine.
   • MySQL 4.1 or later
     • Download
   • Oracle 8i or later
     • Download - - Oracle Database 10g Express Edition
     1. The file you want to download is Oracle Database 10g Express Edition (Western European) - OracleXE.exe.
     2. You will need to register for a free account.
     3. Run through the Installer accepting all the defaults. Make sure to write down your password.
     4. Follow steps 1-3 of the Getting Started Guide available at the Oracle Web site

*If you have questions about your specific setup, please contact us.

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.