About the Course
Advanced Dreamweaver 8 with Matthew Pizzi
Advanced Dreamweaver 8 with Matthew Pizzi provides students with the knowledge and practice they need to build and
manage dynamic websites using Dreamweaver and ColdFusion. In this course, you’ll learn how to connect to a database,
search and display results, and build a page to update the database. If you’ve always dreamed of building a more advanced,
data-powered site, but didn't know where to start, then this course is for you. This class contains approx 5 hours of
advanced Dreamweaver tutorials.
Prerequisites: Introduction to Dreamweaver or equivalent knowledge.
More about Matthew Pizzi
Advanced Dreamweaver 8 with Matthew Pizzi is available as part of our online training subscription service,
or it's available for purchase in DVD-ROM or CD-ROM format. You can purchase a disc by visiting our store.
Course Outline
Lesson 1 - Getting started with Application Development
The Application
What is ColdFusion?
What is a Database?
What is a DSN?
Lesson 2 - Setting up the Site (Windows)
Install ColdFusion MX 7
Create a DSN
Define a Site
Lesson 3 - Setting up the Site (Mac)
Installing ColdFusion MX 7
Installing MySQL
Working with a GUI MySQL Admin
Setting up the DSN
Define a Site
Lesson 4 - Building Queries
Establish a Database Connection
Create a Recordset/Query
Binding Data to the Page
Creating a Dynamic Image
Format Currency
Build a Recordset Navigation System
Recordset Status
Dynamic Table - Application Object
Build a Navigation System with Server Behaviors
Create a Dynamic Title
Lesson 5 - Master-Detail Pages
Building the Results Page
Repeat Region
Passing URL Parameters
Master-Detail Application Object
Lesson 6 - Insert Records
Preparing the Form
Building Dynamic Select Controls
Insert Form
Insert Form Wizard
Lesson 7 - Update Records
Prepare the Form
Bind Dynamic Data to the Form
Passing a URL Parameter
Update Record
Update Record Wizard
Delete Record
Lesson 8 - Building Search Interfaces
Building the Search Interface
Using Wildcards for More Flexible Searchs
Creating Multi-Dimensional Searches
Application Flow
Text-Based Searches
Creating Conditional Statements
Lesson 9 - Working with Security
Building the Application.cfm Page
Build the Login Sequence
Restrict Access to Pages
Working with Access Levels
Logout of the Application
Add Personalization
Appendix
Microsoft Access Primer
ColdFusion MX 7 Primer
