Lesson 1: COMPARING STATIC & DYNAMIC SITES (25 min)
1. Explaining Dynamic Web Pages
2. Differences between Static & Dynamic Sites
3. The Advantages of Dynamic Web Sites
4. Using Templates & Include Files
5. Using the Application Panel
6. Collecting & Editing Data
7. Planning a Dynamic Site Structure
8. Explaining Dynamic Site Publishing

Lesson 2: INSTALLING THE SOFTWARE (24 min)
1. Setting the Stage
2. Installing ColdFusion®
3. Using Debugging in ColdFusion
4. Updating ColdFusion for MySQL®
5. Working with MySQL
6. Restoring the Database

Lesson 3: SETTING UP A DYNAMIC SITE IN DREAMWEAVER (61 min)
1. Moving Project Files
2. Setting Up a Site in Dreamweaver
3. Creating a .CFM Page
4. Creating a Database Connection
5. Designing a .CFM Page with CSS
6. Adjusting Columns in CSS
7. Adding Static Images & Text
8. Styling a Navigation Bar with CSS
9. Creating a Footer with CSS
10. Using ColdFusion Components
11. Using Multiple Record Sets

Lesson 4: CREATING TEMPLATES & QUERIES (34 min)
1. Adding Styles to Dynamic Content
2. Creating Include Files
3. Creating a .CFM Template
4. Creating Pages from a Template
5. Creating a Simple Query
6. Adding Images to a Query

Lesson 5: LINKING TO DYNAMIC PAGES (44 min)
1. Creating a Filtered Query
2. Binding Images
3. Setting Links to Multiple Pages
4. Starting with Where Statements
5. Inserting Dynamic Data Tables
6. Using Dynamic Data Tables
7. Styling Links in Dynamic Pages
8. Creating Record Set Navigation

Lesson 6: CREATING COLDFUSION® COMPONENTS (32 min)
1. Getting Started with Components
2. Using a Where Statement
3. Inserting Data from a CFC Query
4. Displaying Individual Columns
5. Adding Where Statements
6. Binding Data to a Page
7. Creating Links to Dynamic Pages

Lesson 7: CREATING ADMIN PAGES (40 min)
1. Enabling Sessions
2. Creating a Login Page
3. Setting Up User Authentication
4. Adding a Login Failed Message
5. Restricting Access to Pages
6. Adding a Logout Link
7. Checking for User Login
8. Adding a Link to an Edit Page
9. Creating an Update Page
10. Using the Update Record Form Wizard
11. Updating Records

Lesson 8: USING THE SPRY FRAMEWORK (23 min)
1. Using Spry for Form Validation
2. Creating Dropdown Navigation Menus
3. Linking a Spry Menu Bar
4. Final Comments & Credits