Database-Driven Websites with Dreamweaver CS4

Print

Request an offer for delivery of this course

Course duration

Course Outline

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

  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

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.