Database-Driven Websites with Dreamweaver CS4

Delivery Options

• Live eLearning (2 days): $790.00 (Register)

» Register Now

» Free Demo

» Watch Presentation

» Contact Education Consultant

• Customized Onsite Training (2 days): Request a Proposal

Class Date and Time	Price Volume Discounts Students Discounts 2 5% 3-4 10% 5 or more 15% GSA Price: $750.50	Register
Apr 5 - 6, 2010 10:00 AM - 5:00 PM ET	$790.00 or 2 vouchers	Register
Apr 28 - 29, 2010 10:00 AM - 5:00 PM ET	$790.00 or 2 vouchers	Register
May 24 - 25, 2010 10:00 AM - 5:00 PM ET	$790.00 or 2 vouchers	Register

Class Description

Class Overview

Class Goals

• Learn to create database-driven web sites with Dreamweaver CS4
• 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

Class Outline

1. Introduction to Dreamweaver
   1. Who is Dreamweaver for?
   2. What is a "webmaster"
   3. History of Dreamweaver
   4. Goals of the class
   5. What's new in Dreamweaver CS4
   6. Static pages vs Dynamic pages
   7. Choosing a Server-side language
   8. Server-side Languages covered in this course
   9. Introduction to ColdFusion
   10. Introduction to Active Server Pages
   11. Introduction to PHP
   12. Who This Course Is For
   13. Course Project
   14. Confronting Differences in Technologies
2. Passing Data from Page to Page
   1. Understanding HTTP Requests: Passing data through the URL
   2. Accessing Variable in the URL
   3. HTML Form Basics
3. Creating a Dreamweaver "Site"
   1. Create a new Site - Manage Sites
   2. Site Creation - Basics
   3. Site Creation - Advanced
4. Database Basics
   1. Database Alphabet Soup: ODBC, JDBC, OleDB, DSNs and SQL
   2. Introduction to SQL
   3. Select Statement
   4. Update Statement
   5. Insert Statement
   6. Delete Statement
5. Create a Database Connection
   1. Application Panel Group
   2. ASP: Create a Database Connection
   3. ColdFusion: Connect to Database with a DSN
6. Server Behaviors
   1. Simple Recordset
7. Display Recordset Results
   1. Repeat Region
8. Paging through Records
   1. Record Paging
9. Show Region If
   1. Show Region If
10. Display Recordcount
    1. ColdFusion and PHP: Display Record Count
    2. Shortcut and ASP: Display Record Count
11. Go to Detail Page
    1. Pass a Variable as a Link
    2. ASP: "Go to Detail page" Server Behavior
    3. PHP and ColdFusion: External Extensions available#
12. Filtering a Recordset to Create a Detail Page
    1. Simple Recordset with Filter
    2. View Query in Advanced Recordset
    3. Formatting the Date
13. Review and Cumulative Exercise
14. Create and Admin Section
    1. Create Admin Page
15. Dynamically Created Form Elements
    1. Using Dreamweaver to create forms
    2. Create dynamic select list of movie titles
    3. Advanced SQL Techniques: Create and Alias
16. Insert New Record
    1. Insert New Actor - using "Insert Record Behavior"
17. Client-side Form Validation using Spry
18. Edit (Update) Record
    1. A Closer Look
    2. Adding the Update Record Behavior
19. Delete Record
    1. Delete Record Behavior
    2. Delete a Record from the database
20. Password Protect Pages (User Authentication)
    1. Getting Ready
    2. Password Protect the admin section
    3. Users Table
    4. "Restrict Access to Page" Behavior
    5. Complete the login page
    6. Create Logout page
    7. Check New Username
    8. Coldfusion: Potential Error
21. Site Management Tools
    1. Find and Replace
    2. Built in FTP client
    3. File check-in/check-out
    4. Design Notes
    5. Link Checker
    6. Reports
    7. Browser Compatibility Check

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

• Technical Reference Library

Class Prerequisites

Experience in the following areas is required:

• Basic Dreamweaver

Experience in the following areas would be beneficial:

• HTML
• SQL

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Course technical requirements and setup instructions.