We continue to offer a popular range of computer training courses at Elstree Film Studios:

This is the second course in a series of tutorials from the Virtual Training Company for Dreamweaver MX. It covers all that techniques required to construct a data driven web site. Author Mark Fletcher (a Certified Macromedia Professional and member of Team Macromedia) will teach you how to construct a database, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), PWS (Personal Web Server) and the Macromedia ColdFusion MX Server using both a PC and Macintosh. Mark also guides you through building dynamic pages using Macromedia s Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion MX. To start, simply click one of the topics below.


Introduction
What is Dreamweaver MX
System Requirements
Lessons && Sites && Trial Software
Workspace - Windows
Workspace - Macintosh
Extensibility
Using CSS
Creating Pages using XHTML
Configuring Dreamweaver for the Course
Update

Database Primer
What is a Database
Designing Databases
Types of Databases
Relational Databases
Creating a Database
Field Data Types
Relationships
Creating Relationships
Database Queries
Creating Queries
How Queries are Created
Creating Indexes
MS SQL Server 2000
Upsizing to MS SQL 2000
What are Stored Procedures
What are Views

SQL
What is SQL
Select Statements
Using Where && Order By
Retrieving Data
Using LIKE

Connecting to Databases
Web && Application Servers
Types of Application Servers
Installing Personal Web Server
Configuring PWS
Configuring IIS
Interfacing with Databases
Database Drivers
Setting up a DSN
Connecting to an MS SQL Server
Connect to a CFMX Server
Creating a Connection in Cold Fusion MX to a MS SQL Server
Connecting a Macintosh to a Windows 2000 Server
Connecting from Mac OS9 to a Shared Windows Folder
Connecting from Mac OSX to a Shared Windows Folder (1)
Connecting from Mac OSX to a Shared Windows Folder (2)

Creating a Site
Defining a Site for ASP
Defining a Site for CFM
Defining a Site for ASP.NET
Deploying Supporting File - ASP.NET
Connecting to an Access Database - ASP
Creating a Connection with a Connection String - ASP
Creating a Remote DSN Connection - ASP
Connecting to a CFMX Data Source
Creating a Database Connection - ASP.NET
Creating a SQL Server Connection - ASP.NET

MySQL and PHP
Creating a MySQL Database
Converting Access to MySQL
Testing PHP in Dreamweaver MX
Connecting to MySQL Database
Additional Resources

Inserting Dynamic Data
Inserting Dynamic Data
Live Data View
Dynamic Images
Formatting Dynamic Data - ASP
Formatting Dynamic Data - CFM
Repeat Regions - All
Adding Navigation Tools
Dynamic Table - ASP
Dynamic Table - CFM
Binding Form Elements - ASP
Binding Form Elements - CFM
Live Data View Settings - All

Record Sets
Advanced Recordset Dialog - ASP
Advanced Recordset Dialog - CFM
Writing SQL Statements - All
Joining Multiple Tables - All
Sorting and Filtering Data - All
Editing and Duplicating Recordsets - All
Views - All
Stored Procedures && Command Object - ASP
Stored Procedures - CFM
Stored Procedures - ASP.NET

Master Detail Page Set
Master Detail Page Set Live Object - ASP
How Master Detail Page Set Works - ASP
Master Detail Page Set Live Object - CFM
How Master Detail Page Set works - CFM
Create Master Page Step by Step - ASP
Create Detail Page Step by Step - ASP
Create Master Page Step by Step - CFM
Create Detail Page Step by Step - CFM
Create Master Page - ASP.NET
Create Detail Page - ASP.NET

Record Insertion Form
Record Insertion Form - Live Object - ASP
Creating a Record Insertion Form Step by Step - ASP
Record Insertion Form - Live Object - CFM
Creating a Record Insertion Form Step by Step - CFM
Record Insertion Form - Live Object - ASP.NET
Creating a Record Insertion Form Step by Step - ASP.NET
Inserting New Record with Command Object - ASP

Updating and Deleting Records
Update Record Live Object - ASP
Update Record Live Object - CFM
Update Record Live Object - ASP.NET
Create Update Record Form Step by Step - ASP
Create Update Record Form Step by Step - CFM
Create Update Record Form Step by Step - ASP.NET
Deleting Records - ASP
Deleting Records - CFM
Deleting Records - ASP.NET
Delete Records with a DataGrid - ASP.NET

Search and Result Pages
Creating a Search Page - ASP
Creating a Results Page - ASP
Create a Dynamic List Box - ASP
Category Results Page - ASP
Dealing with Empty Recordsets - ASP
Creating a Search Page - CFM
Creating a Results Page - CFM
Create a Dynamic List Box - CFM
Category Results Page - CFM
Dealing with Empty Recordsets - CFM
Creating a Search Page - ASP.NET
Creating a Results Page - ASP.NET
Category Results Page - ASP.NET
Dealing with Empty Recordsets - ASP.NET
Displaying Records Based upon Likeness - ASP
Multiple Search Parameters - ASP
Displaying Search and Results on the Same Page - ASP
Displaying Records Based upon Likeness - CFM
Multiple Search Parameters - CFM
Displaying Search and Results on the Same Page - CFM
Displaying Records Based upon Likeness - ASP.NET
Multiple Search Parameters - ASP.NET
Displaying Search and Results on the Same Page - ASP.NET

Authentication
Login Users - ASP
Restricting User Access - ASP
Log out User - ASP
Session Variables - ASP
Checking for New Users - ASP
Login Users - CFM (1)
Login Users - CFM (2)
Restricting User Access - CFM
Log out User - CFM
Session Variables - CFM
Checking for Existing Users - CFM

Shopping Cart
Inserting the WA eCart Object
eCart Object Interface - General and Column Tabs
eCart Object Interface - Calculations Tab
Inserting an Add To Cart Button (1)
Inserting an Add To Cart Button (2)
Quick Checkout Buttons
Display Manager Overview
Merchandising Wizard - Product Discounts
Merchandising Wizard - Flat Rate Discounts
Merchandising Wizard - Sales Tax
Merchandising Wizard - Shipping
Using WA eCart with Dreamweaver MX Templates

ColdFusion
Creating a Dynamic Table
Total Records && Today s Date
Dynamic Form Elements
Creating a Data Drill Down (1)
Creating a Data Drill Down (2)
Reusing Code
Local Variables
Server Debug
Components
Web Services
ColdFusion MX and XML

WA Dynamic Flash Charts
Overview
Creating a Chart with a Static Data Source (1)
Creating a Chart with a Static Data Source (2)
Creating a Chart with Dynamic Data Source (1)
Creating a Chart with Dynamic Data Source (2)
Upgrading a Flash Chart

WA Query Builder
Overview
Create the Master Detail Page
Query Builder Live Object
Making List Box Dynamic
Date Validation

WA Universal Email
Introduction
WA Universal Email - Basic (1)
WA Universal Email - Basic (2)
Creating a Mailing List
Retrieving User Details
Confirmation of Registration
HTML Mail
Universal Email Markup Tags

Click here to find out more about the Macromedia Dreamweaver MX - Web Applications Training CD

No joke ... but we have taught (in many cases, more than once) to all of these companies:

(Click here to see some testimonials as well)