Macromedia Dreamweaver MX Tutorials

In this Training course which contains over 186 Dynamic Dreamweaver MX tutorials. You will learn the techniques required to construct a database driven and dynamnic web site using many of the common scripting languages such as PHP, ASP, ASP.NET, JSP and even JavaScript . Author Mark Fletcher (a member of Team Macromedia) will teach you how to construct and connect to a database on your local and remote server, create database queries using SQL (Structure Query Language) and how to connect to a database using IIS (Internet Information Server), or Microsoft's PWS (Personal Web Server) and the Macromedia ColdFusion MX Server on both the PC and Macintosh operating system. This Online Training course also guides you through building dynamic pages using Macromedia's Live Object and Server Behaviors with ASP, ASP.NET and ColdFusion MX. Dreamweaver MX can also be used to connect to a MySQL database with the querys being passed in PHP

The links below are free Dreamweaver MX tutorials. The entire contents may be purchased either on CD or watched via the Online University


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
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