Welcome to The Open and Distance
Learning College - the leading
international distance learning
institution
Start changing your life for the better now! A new
career and a new start can be yours by taking a distance learning training
course. Gain a nationally recognised qualification by studying in your own
time and at your own pace.
Macromedia Dreamweaver MX - Web
Applications
Product:
Macromedia Dreamweaver MX - Web Applications 7.5 hrs / 186 lessons. For Win Vista, XP,
2000, Mac OS X, OS 9, Linux
Price:
Details:
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)
ODLC
ODLC
