Adobe Dreamweaver Databases Intermediate

You've been working with Dreamweaver and are familiar with the concepts of web design maybe having designed a couple of static websites in html, or having been involved with the development of an ongoing web project and you now need to dynamically empower your website using Dreamweaver ASP.
This course will enable you to use the power of ASP(Active Server Pages)to create on line applications such as shopping carts, newsgroups etc. You will learn the concepts of connecting to a database so that you can update, insert and delete records.
Adobe Dreamweaver Databases Training Course (Intermediate) Outline
The Present and the futureJ

• Defining a static site
• The Code
• Business Processes

Upgrading to XHTML

• Upgrading to the XHTML Document Type
• Replacing Strings in the Source Code
• Replacing Tags
• Stripping Unwanted Tags
• Closing Empty Tags that have attributes
• Finding Images without the alt attribute
• Validating your XHTML

Creating the Presentation Layer

• Redefining HTML Elements with CSS
• Creating and Applying Custom CSS Styles
• Creating a reusable template
• Enhancing Accessibility with Invisible Navigation

Dynamic Websites

• Dynamic Website Basics
• Choosing a Server Model
• Redefining a Site for Dynamic Development
• Building a simple, dynamic application

Passing Data Between Pages

• Understanding the HTTP protocol
• Retrieving data with querystrings
• Sending data with hyperlinks
• Setting and retrieving cookies

Sending email from a web form

• Introducting SMTP Email Service
• Configuring your System to Send SMTP Email Messages
• Configuring IIS to Send Email (ASP)
• Writing the code to send a message
• Understanding Objects, Methods, and Properties
• Creating the webform
• Emailing dynamic form values
• Client-site form validation

Building a Server Side Application

• Creating the pages
• Building the form
• Collecting, Processing and displaying data
• Adding Server-side form validation
• Creating a conditional region
• Creating and applying a Custom CSS class

Databases on the Web

• Introduction to Databases
• Connecting to a Database
• Creating Recordsets and displaying database information

Dynamic Form Interfaces

• Dynamically populated drop down menus
• Filtered Recordsets
• Live Data view
• Documenting your code with comments

Filtering and Displaying Data

• Preparing the input page
• Generating URL's dynamically
• Preparing the output page
• Populating page layouts dynamically
• Adding dynamic images and formatting the population number
• Looking up related table data with SQL

Adding ASP script to a Web Page

• Planning the application
• Creating Recordsets and Joines
• Building descriptions
• Inserting images and alt attributes
• Recordset paging
• Passing data to other applications

Building search interfaces

• Preparing the search pages
• Building the interfaces
• Debugging and Testing the code
• Supressing the navigation bar
• Filtering by form variable
• Switching SQL statements according to envrionmental variables

Authenticating Users

• User authentication as a web application
• Building the registration pages
• Building the log-in page
• Restricting access to pages

Managing Content with Forms

• Creating the admin section
• Two approaches to formatting content stored in a database
• Creating the form interfaces
• Session variables and hidden fields to track users
• Inserting records

Building update pages

• Preparing the pages
• Planning for the master detail pages
• Making the detail page updateable