
Macromedia Dreamweaver MX - Web Applications
by Mark Fletcher
Start the free chapterThis 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 content
Introduction10 lessons
Database Primer16 lessons
- What is a Database2:571 credit or ad
- Designing Databases1:451 credit or ad
- Types of Databases1:481 credit or ad
- Relational Databases1:141 credit or ad
- Creating a Database3:041 credit or ad
- Field Data Types3:031 credit or ad
- Relationships2:031 credit or ad
- Creating Relationships1:511 credit or ad
- Database Queries1:301 credit or ad
- Creating Queries1:381 credit or ad
- How Queries are Created2:141 credit or ad
- Creating Indexes1:311 credit or ad
- MS SQL Server 20002:451 credit or ad
- Upsizing to MS SQL 20002:271 credit or ad
- What are Stored Procedures2:461 credit or ad
- What are Views3:181 credit or ad
SQL5 lessons
Connecting to Databases15 lessons
- Web & Application Servers2:141 credit or ad
- Types of Application Servers2:091 credit or ad
- Installing Personal Web Server1:281 credit or ad
- Configuring PWS1:471 credit or ad
- Configuring IIS1:551 credit or ad
- Interfacing with Databases1:141 credit or ad
- Database Drivers2:321 credit or ad
- Setting up a DSN2:101 credit or ad
- Connecting to an MS SQL Server1:571 credit or ad
- Connect to a CFMX Server1:451 credit or ad
- Creating a Connection in Cold Fusion MX to a MS SQL Server1:361 credit or ad
- Connecting a Macintosh to a Windows 2000 Server2:541 credit or ad
- Connecting from Mac OS9 to a Shared Windows Folder1:221 credit or ad
- Connecting from Mac OSX to a Shared Windows Folder (1)1:171 credit or ad
- Connecting from Mac OSX to a Shared Windows Folder (2)2:261 credit or ad
Creating a Site10 lessons
- Defining a Site for ASP4:121 credit or ad
- Defining a Site for CFM4:161 credit or ad
- Defining a Site for ASP.NET3:091 credit or ad
- Deploying Supporting File - ASP.NET1:091 credit or ad
- Connecting to an Access Database - ASP3:431 credit or ad
- Creating a Connection with a Connection String - ASP1:551 credit or ad
- Creating a Remote DSN Connection - ASP2:151 credit or ad
- Connecting to a CFMX Data Source2:321 credit or ad
- Creating a Database Connection - ASP.NET3:351 credit or ad
- Creating a SQL Server Connection - ASP.NET1:081 credit or ad
MySQL and PHP5 lessons
Inserting Dynamic Data12 lessons
- Inserting Dynamic Data2:091 credit or ad
- Live Data View1:381 credit or ad
- Dynamic Images3:381 credit or ad
- Formatting Dynamic Data - ASP1:081 credit or ad
- Formatting Dynamic Data - CFM0:571 credit or ad
- Repeat Regions - All2:481 credit or ad
- Adding Navigation Tools4:551 credit or ad
- Dynamic Table - ASP2:101 credit or ad
- Dynamic Table - CFM2:041 credit or ad
- Binding Form Elements - ASP1:511 credit or ad
- Binding Form Elements - CFM1:491 credit or ad
- Live Data View Settings - All1:301 credit or ad
Record Sets10 lessons
- Advanced Recordset Dialog - ASP2:521 credit or ad
- Advanced Recordset Dialog - CFM2:521 credit or ad
- Writing SQL Statements - All1:271 credit or ad
- Joining Multiple Tables - All3:471 credit or ad
- Sorting and Filtering Data - All1:451 credit or ad
- Editing and Duplicating Recordsets - All1:451 credit or ad
- Views - All0:481 credit or ad
- Stored Procedures & Command Object - ASP2:131 credit or ad
- Stored Procedures - CFM0:571 credit or ad
- Stored Procedures - ASP.NET0:481 credit or ad
Master Detail Page Set10 lessons
- Master Detail Page Set Live Object - ASP4:001 credit or ad
- How Master Detail Page Set Works - ASP2:471 credit or ad
- Master Detail Page Set Live Object - CFM3:541 credit or ad
- How Master Detail Page Set works - CFM2:051 credit or ad
- Create Master Page Step by Step - ASP2:081 credit or ad
- Create Detail Page Step by Step - ASP2:031 credit or ad
- Create Master Page Step by Step - CFM2:341 credit or ad
- Create Detail Page Step by Step - CFM2:281 credit or ad
- Create Master Page - ASP.NET2:131 credit or ad
- Create Detail Page - ASP.NET2:521 credit or ad
Record Insertion Form7 lessons
- Record Insertion Form - Live Object - ASP3:421 credit or ad
- Creating a Record Insertion Form Step by Step - ASP2:241 credit or ad
- Record Insertion Form - Live Object - CFM3:561 credit or ad
- Creating a Record Insertion Form Step by Step - CFM2:121 credit or ad
- Record Insertion Form - Live Object - ASP.NET3:461 credit or ad
- Creating a Record Insertion Form Step by Step - ASP.NET2:001 credit or ad
- Inserting New Record with Command Object - ASP3:481 credit or ad
Updating and Deleting Records10 lessons
- Update Record Live Object - ASP3:271 credit or ad
- Update Record Live Object - CFM3:001 credit or ad
- Update Record Live Object - ASP.NET2:521 credit or ad
- Create Update Record Form Step by Step - ASP2:371 credit or ad
- Create Update Record Form Step by Step - CFM2:411 credit or ad
- Create Update Record Form Step by Step - ASP.NET2:411 credit or ad
- Deleting Records - ASP3:461 credit or ad
- Deleting Records - CFM2:581 credit or ad
- Deleting Records - ASP.NET3:071 credit or ad
- Delete Records with a DataGrid - ASP.NET1:201 credit or ad
Search and Result Pages23 lessons
- Creating a Search Page - ASP1:291 credit or ad
- Creating a Results Page - ASP1:561 credit or ad
- Create a Dynamic List Box - ASP2:521 credit or ad
- Category Results Page - ASP3:391 credit or ad
- Dealing with Empty Recordsets - ASP1:481 credit or ad
- Creating a Search Page - CFM1:331 credit or ad
- Creating a Results Page - CFM2:051 credit or ad
- Create a Dynamic List Box - CFM2:551 credit or ad
- Category Results Page - CFM3:281 credit or ad
- Dealing with Empty Recordsets - CFM1:341 credit or ad
- Creating a Search Page - ASP.NET1:281 credit or ad
- Creating a Results Page - ASP.NET1:541 credit or ad
- Category Results Page - ASP.NET4:311 credit or ad
- Dealing with Empty Recordsets - ASP.NET1:551 credit or ad
- Displaying Records Based upon Likeness - ASP2:331 credit or ad
- Multiple Search Parameters - ASP1:001 credit or ad
- Displaying Search and Results on the Same Page - ASP0:541 credit or ad
- Displaying Records Based upon Likeness - CFM2:241 credit or ad
- Multiple Search Parameters - CFM1:041 credit or ad
- Displaying Search and Results on the Same Page - CFM0:481 credit or ad
- Displaying Records Based upon Likeness - ASP.NET2:191 credit or ad
- Multiple Search Parameters - ASP.NET0:511 credit or ad
- Displaying Search and Results on the Same Page - ASP.NET0:471 credit or ad
Authentication11 lessons
- Login Users - ASP2:411 credit or ad
- Restricting User Access - ASP2:241 credit or ad
- Log out User - ASP1:101 credit or ad
- Session Variables - ASP1:551 credit or ad
- Checking for New Users - ASP1:331 credit or ad
- Login Users - CFM (1)1:591 credit or ad
- Login Users - CFM (2)2:111 credit or ad
- Restricting User Access - CFM2:191 credit or ad
- Log out User - CFM1:031 credit or ad
- Session Variables - CFM1:541 credit or ad
- Checking for Existing Users - CFM1:331 credit or ad
Shopping Cart12 lessons
- Inserting the WA eCart Object3:201 credit or ad
- eCart Object Interface - General and Column Tabs3:561 credit or ad
- eCart Object Interface - Calculations Tab2:351 credit or ad
- Inserting an Add To Cart Button (1)2:471 credit or ad
- Inserting an Add To Cart Button (2)3:521 credit or ad
- Quick Checkout Buttons3:001 credit or ad
- Display Manager Overview5:261 credit or ad
- Merchandising Wizard - Product Discounts4:301 credit or ad
- Merchandising Wizard - Flat Rate Discounts1:521 credit or ad
- Merchandising Wizard - Sales Tax3:531 credit or ad
- Merchandising Wizard - Shipping3:501 credit or ad
- Using WA eCart with Dreamweaver MX Templates4:501 credit or ad
ColdFusion11 lessons
- Creating a Dynamic Table6:501 credit or ad
- Total Records & Todayâs Date1:551 credit or ad
- Dynamic Form Elements3:031 credit or ad
- Creating a Data Drill Down (1)2:491 credit or ad
- Creating a Data Drill Down (2)3:561 credit or ad
- Reusing Code2:451 credit or ad
- Local Variables2:281 credit or ad
- Server Debug2:191 credit or ad
- Components4:271 credit or ad
- Web Services4:421 credit or ad
- ColdFusion MX and XML3:461 credit or ad
WA Dynamic Flash Charts6 lessons
- Overview1:331 credit or ad
- Creating a Chart with a Static Data Source (1)2:281 credit or ad
- Creating a Chart with a Static Data Source (2)5:301 credit or ad
- Creating a Chart with Dynamic Data Source (1)4:071 credit or ad
- Creating a Chart with Dynamic Data Source (2)1:491 credit or ad
- Upgrading a Flash Chart1:371 credit or ad
WA Query Builder5 lessons
WA Universal Email8 lessons
- Introduction0:361 credit or ad
- WA Universal Email - Basic (1)4:021 credit or ad
- WA Universal Email - Basic (2)3:141 credit or ad
- Creating a Mailing List2:481 credit or ad
- Retrieving User Details3:331 credit or ad
- Confirmation of Registration2:001 credit or ad
- HTML Mail2:371 credit or ad
- Universal Email Markup Tags4:001 credit or ad