Course Title: Macromedia Dreamweaver MX-Web Applications



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.


Course Author/Expert: Mark Fletcher

Language: english

Full Online Training Available: Yes

Number of Course Movies: 186

Course Duration: 7.5 hours



Never has it been so easy to learn Macromedia Dreamweaver MX-Web Applications.
No expensive classroom training courses.
No boring hard to follow books to read.
Learn from your own desk at a pace that suits you.
High quality affordable training that is easy to use and follow.
Use unique training methods, it makes learning easy no matter what your learning style.




Course Outline:



The FIRST THREE chapters of this online training course can be viewed right now!





Click Here Now To View the First Three Chapters of Macromedia Dreamweaver MX-Web Applications Online Training For Free






If you then need all the lessons or complete access to over seven hundred different courses then join the online university for as long as you need them and even get an online university certificate.


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

Creating a Search Page - CFM

Creating a Results Page - CFM

Create a Dynamic List Box - CFM

Category Results Page - CFM

Dealing with Empty Recordsets - CFM

Creating a Search Page - ASP.NET

Creating a Results Page - ASP.NET

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









To continue your learning, Click Here for the Online University and get access to all of the training courses, that's over 550 software programmes including 60,000 tutorial videos, for editing, image manipulation and graphics programmes. All for just $30 (approx £16) month. Unlimited access for as long as you need, cancel when you're finished, no contract, no minimum period, no hassle.



or


Click Here and we'll send you the training CD itself for Macromedia Dreamweaver MX-Web Applications at £79.95

| rss feed | add to google toolbar Add latest courses to Google Toolbar | After Effects Projects | Background Loops |

• TutorRoom© 2005 •