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