Macromedia Dreamweaver MX Web Applications Tutorial Video

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

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

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

If you purchase the CD all the contents listed below are also included.

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 in Dreamweaver MX
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
Creating a Search Page - CFM
Creating a Results Page - CFM
Create a Dynamic List Box - CFM
Dealing with Empty Recordsets
Category Results Page - CFM
Creating a Search page - ASP.NET
Creating a Results Page - ASP.NET
Category Search 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