by Candyce Mairs, video2brain | Publisher: Peachpit Press | Release Date: July 2011 | ISBN: 9780132808873

This innovative product is a focused video workshop and accompanying 48-page full-color book that teaches web developers how to use Adobe Dreamweaver CS5.5 to code websites that use databases to update pages with changing information. The video begins with a description of the database-driven website process, including installation of the development environment. Then it explains how to pull data from a database and display it in a variety of ways using Dreamweaver features; and how to pass data between pages. The video also covers building an administration interface to insert and update database data using web forms. Experienced instructor, Candyce Mairs presents three hours of exceptional quality video tutorials, complete with lesson files, assessment quizzes, and review materials. The video is wrapped in a unique interface that allows the viewer to jump to any topic and also bookmark individual sections for later review. The unique Watch-and-Work mode shrinks the video into a small window to allow the student to work alongside in Dreamweaver. Project files used in the lessons are included on the disc so viewers can practice what they've learned, and interactive review questions help reinforce freshly gained knowledge.This title includes additional digital media when purchased in print format. For this digital book edition, media content may not be included. Contact the publisher's customer service directly for assistance.

1. Introduction
   • Course Overview 00:01:06
   • Course Environment 00:01:17
2. Setting Up the Development Environment
   • What You Need 00:02:20
   • Installing XAMPP on a Windows System 00:07:03
   • Installing MAMP on a Mac System 00:08:39
   • Controlling the Development Environment 00:06:10
   • Installing Necessary Files 00:07:03
   • Setting Up the Testing Server 00:06:43
3. Working with Server-Side Code
   • Creating a PHP Page 00:04:23
   • Storing Information as Variables 00:05:28
   • Displaying Variables 00:03:17
   • Commenting Code 00:05:33
   • The Benefits of Includes 00:05:46
   • Converting Pages to Use Includes 00:05:46
4. Passing Data Between Pages
   • HTML Limitations 00:05:00
   • URL Variables 00:04:18
   • Passing Data Between Pages 00:15:17
   • Dynamic URL Variables 00:05:26
5. Working with a Database
   • What Is a Database? 00:07:14
   • Viewing the Course Database 00:08:17
   • SQL: The Language of the Database 00:03:12
   • Getting Data from a Database 00:08:42
6. Creating Data-Driven Pages
   • Using Server Behaviors 00:05:11
   • Using Dynamic Tables 00:06:16
   • Navigating Database Data 00:06:07
   • Recordset Navigation 00:03:24
   • Using the Master-Detail Page Set 00:11:54
7. Dynamic Forms
   • Form Basics 00:04:34
   • Populating Forms with Database Data 00:05:09
   • Correcting Form Output 00:04:05
   • Redirecting the User 00:07:38
   • Validating Text Fields 00:05:17
   • Inserting Data into a Database 00:08:14
   • Creating an Update Interface 00:14:31
   • Deleting Database Data 00:03:43
8. Conclusion
   • Course Wrap-Up 00:00:53