Macromedia Dreamweaver MX - Web Applications
This is the second course in a
series of tutorials 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.
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
For the above course and
many more For Only $30 a Month.
GO BACK - IT E-LEARNING-TRAINING CENTRE: LIST OF IT
COURSES
|