|
Provided by: 123-CBT Computer Based Training Dreamweaver MX Web Applications |
 |
Training
Provided by 123-CBT Computer Based Training
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 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.
Course Duration: 7.5 Hours
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
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 & Todaya 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
Course Duration: 7.5 Hours
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
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 & Todaya 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
|
|
||||||||
Dreamweaver MX Web Applications
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
