Title Language  : 

Find a Course... Try for Free!

 

Macromedia Dreamweaver MX - Web Applications Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

«« Hide This
Introduction
What is Dreamweaver MX (04:19)
System Requirements (01:23)
Lessons & Sites & Trial Software (01:54)
Workspace - Windows (04:55)
Workspace - Macintosh (03:19)
Extensibility (02:42)
Using CSS (01:22)
Creating Pages using XHTML (01:56)
Configuring Dreamweaver for the Course (01:19)
Update (00:46)
Database Primer
What is a Database (02:56)
Designing Databases (01:45)
Types of Databases (01:48)
Relational Databases (01:13)
Creating a Database (03:04)
Field Data Types (03:03)
Relationships (02:02)
Creating Relationships (01:51)
Database Queries (01:30)
Creating Queries (01:37)
How Queries are Created (02:13)
Creating Indexes (01:31)
MS SQL Server 2000 (02:45)
Upsizing to MS SQL 2000 (02:26)
What are Stored Procedures (02:46)
What are Views (03:17)
SQL
What is SQL (00:52)
Select Statements (00:58)
Using Where & Order By (01:48)
Retrieving Data (02:26)
Using LIKE (02:04)
Connecting to Databases
Web & Application Servers (02:13)
Types of Application Servers (02:09)
Installing Personal Web Server (01:27)
Configuring PWS (01:47)
Configuring IIS (01:55)
Interfacing with Databases (01:13)
Database Drivers (02:31)
Setting up a DSN (02:09)
Connecting to an MS SQL Server (01:57)
Connect to a CFMX Server (01:44)
Creating a Connection in Cold Fusion MX to a MS SQL Server (01:36)
Connecting a Macintosh to a Windows 2000 Server (02:54)
Connecting from Mac OS9 to a Shared Windows Folder (01:22)
Connecting from Mac OSX to a Shared Windows Folder (1) (01:16)
Connecting from Mac OSX to a Shared Windows Folder (2) (02:26)
Creating a Site
Defining a Site for ASP (04:12)
Defining a Site for CFM (04:16)
Defining a Site for ASP.NET (03:08)
Deploying Supporting File - ASP.NET (01:09)
Connecting to an Access Database - ASP (03:43)
Creating a Connection with a Connection String - ASP (01:55)
Creating a Remote DSN Connection - ASP (02:14)
Connecting to a CFMX Data Source (02:31)
Creating a Database Connection - ASP.NET (03:34)
Creating a SQL Server Connection - ASP.NET (01:08)
MySQL and PHP
Creating a MySQL Database (04:51)
Converting Access to MySQL (03:03)
Testing PHP in Dreamweaver MX (01:07)
Connecting to MySQL Database (02:44)
Additional Resources (01:02)
Inserting Dynamic Data
Inserting Dynamic Data (02:09)
Live Data View (01:37)
Dynamic Images (03:38)
Formatting Dynamic Data - ASP (01:07)
Formatting Dynamic Data - CFM (00:57)
Repeat Regions - All (02:48)
Adding Navigation Tools (04:54)
Dynamic Table - ASP (02:09)
Dynamic Table - CFM (02:04)
Binding Form Elements - ASP (01:50)
Binding Form Elements - CFM (01:48)
Live Data View Settings - All (01:29)
Record Sets
Advanced Recordset Dialog - ASP (02:52)
Advanced Recordset Dialog - CFM (02:52)
Writing SQL Statements - All (01:26)
Joining Multiple Tables - All (03:47)
Sorting and Filtering Data - All (01:45)
Editing and Duplicating Recordsets - All (01:44)
Views - All (00:48)
Stored Procedures & Command Object - ASP (02:13)
Stored Procedures - CFM (00:57)
Stored Procedures - ASP.NET (00:47)
Master Detail Page Set
Master Detail Page Set Live Object - ASP (03:59)
How Master Detail Page Set Works - ASP (02:46)
Master Detail Page Set Live Object - CFM (03:54)
How Master Detail Page Set works - CFM (02:04)
Create Master Page Step by Step - ASP (02:07)
Create Detail Page Step by Step - ASP (02:02)
Create Master Page Step by Step - CFM (02:33)
Create Detail Page Step by Step - CFM (02:28)
Create Master Page - ASP.NET (02:12)
Create Detail Page - ASP.NET (02:51)
Record Insertion Form
Record Insertion Form - Live Object - ASP (03:41)
Creating a Record Insertion Form Step by Step - ASP (02:24)
Record Insertion Form - Live Object - CFM (03:56)
Creating a Record Insertion Form Step by Step - CFM (02:11)
Record Insertion Form - Live Object - ASP.NET (03:45)
Creating a Record Insertion Form Step by Step - ASP.NET (01:59)
Inserting New Record with Command Object - ASP (03:48)
Updating and Deleting Records
Update Record Live Object - ASP (03:27)
Update Record Live Object - CFM (03:00)
Update Record Live Object - ASP.NET (02:51)
Create Update Record Form Step by Step - ASP (02:36)
Create Update Record Form Step by Step - CFM (02:41)
Create Update Record Form Step by Step - ASP.NET (02:41)
Deleting Records - ASP (03:45)
Deleting Records - CFM (02:57)
Deleting Records - ASP.NET (03:07)
Delete Records with a DataGrid - ASP.NET (01:19)
Search and Result Pages
Creating a Search Page - ASP (01:29)
Creating a Results Page - ASP (01:56)
Create a Dynamic List Box - ASP (02:52)
Category Results Page - ASP (03:39)
Dealing with Empty Recordsets - ASP (01:48)
Creating a Search Page - CFM (01:32)
Creating a Results Page - CFM (02:04)
Create a Dynamic List Box - CFM (02:54)
Category Results Page - CFM (03:27)
Dealing with Empty Recordsets - CFM (01:33)
Creating a Search Page - ASP.NET (01:28)
Creating a Results Page - ASP.NET (01:54)
Category Results Page - ASP.NET (04:31)
Dealing with Empty Recordsets - ASP.NET (01:54)
Displaying Records Based upon Likeness - ASP (02:32)
Multiple Search Parameters - ASP (01:00)
Displaying Search and Results on the Same Page - ASP (00:54)
Displaying Records Based upon Likeness - CFM (02:23)
Multiple Search Parameters - CFM (01:03)
Displaying Search and Results on the Same Page - CFM (00:48)
Displaying Records Based upon Likeness - ASP.NET (02:19)
Multiple Search Parameters - ASP.NET (00:50)
Displaying Search and Results on the Same Page - ASP.NET (00:46)
Authentication
Login Users - ASP (02:41)
Restricting User Access - ASP (02:24)
Log out User - ASP (01:10)
Session Variables - ASP (01:54)
Checking for New Users - ASP (01:32)
Login Users - CFM (1) (01:58)
Login Users - CFM (2) (02:11)
Restricting User Access - CFM (02:19)
Log out User - CFM (01:03)
Session Variables - CFM (01:54)
Checking for Existing Users - CFM (01:33)
Shopping Cart
Inserting the WA eCart Object (03:20)
eCart Object Interface - General and Column Tabs (03:56)
eCart Object Interface - Calculations Tab (02:34)
Inserting an Add To Cart Button (1) (02:46)
Inserting an Add To Cart Button (2) (03:51)
Quick Checkout Buttons (03:00)
Display Manager Overview (05:25)
Merchandising Wizard - Product Discounts (04:29)
Merchandising Wizard - Flat Rate Discounts (01:51)
Merchandising Wizard - Sales Tax (03:52)
Merchandising Wizard - Shipping (03:49)
Using WA eCart with Dreamweaver MX Templates (04:49)
ColdFusion
Creating a Dynamic Table (06:50)
Total Records & Today’s Date (01:54)
Dynamic Form Elements (03:02)
Creating a Data Drill Down (1) (02:48)
Creating a Data Drill Down (2) (03:56)
Reusing Code (02:45)
Local Variables (02:28)
Server Debug (02:19)
Components (04:26)
Web Services (04:41)
ColdFusion MX and XML (03:45)
WA Dynamic Flash Charts
Overview (01:32)
Creating a Chart with a Static Data Source (1) (02:27)
Creating a Chart with a Static Data Source (2) (05:29)
Creating a Chart with Dynamic Data Source (1) (04:06)
Creating a Chart with Dynamic Data Source (2) (01:48)
Upgrading a Flash Chart (01:37)
WA Query Builder
Overview (02:18)
Create the Master Detail Page (02:30)
Query Builder Live Object (04:42)
Making List Box Dynamic (01:06)
Date Validation (02:01)
WA Universal Email
Introduction (00:35)
WA Universal Email - Basic (1) (04:02)
WA Universal Email - Basic (2) (03:14)
Creating a Mailing List (02:48)
Retrieving User Details (03:33)
Confirmation of Registration (01:59)
HTML Mail (02:36)
Universal Email Markup Tags (04:00)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Macromedia Dreamweaver MX - Web Applications
Author: Mark Fletcher
SKU: 33400
ISBN: 1932072160
Duration: 7.5 hrs / 186 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products