In Adobe Dreamweaver CS5 - Database-Driven Web Applications, instructor, author, and trainer Zak Ruvalcaba delves into the many powerful features of the latest version of this powerful web design application. This 17 hour DVD covers everything from the simplest basics of using Dreamweaver CS5 to applying it to develop a fully interactive and engaging web site. Zak explains the new interface features, and demonstrates how to create, edit, manage, design, and publish a professional web site with Dreamweaver CS5 and complementary applications.
- Decipher the role of Web applications and their terminology
- Identify server-side technologies and their frameworks
- Work with self-contained application frameworks such as XAMPP
- Work with a server-side technology such as PHP
- Pick a database such as MySQL and learn to install and manage it using phpMyAdmin
- Create tables, columns, and manually add data using phpMyAdmin
- Write SQL statements to query, insert, update, and delete data
- Connect Dreamweaver to your database
- Add, update, modify, and delete data in your database from a web page
- Work with database bindings such as Recordsets
- Add dynamic functionality using Server Behaviors
- Work with common data objects such as paging, record counts, etc.
- Add security features to a web application to limit user access
Module 1 - Introduction to Web Applications
Part 1
Overview / Web Architecture
Client vs Server-Side Technologies
Forms - Stepping Stones to Dynamic World
Web Applications
Database Options
The Structured Query Language (SQL)
The Vecta Corp HelpDesk Application
Part 2
Review: Tools in Dreamweaver that we'll be using in this DVD
Part 3
Review: About Dreamweaver Sites
Review: Identifying a Web Host Provider
Review: Creating a Site
Review: Defining the Server
Review: Additional Site Definition Properties
Review: Managing Sites
Review: Options within the Site Menu
Review: Uploading Your Files
Module 2 - Working with Server-Side Technologies
Working with Server-Side Technologies
Picking a Web Server
The Development Web Server - XAMPP
Installing XAMPP on a PC
Configuring XAMPP on a PC
Installing and Configuring XAMPP on a Mac
The Server-Side Technology - PHP
Creating a Simple PHP Page
Configuring Vecta Corp to Run under PHP
Using PHP in Dreamweaver
Module 3 - Working with Databases
What is a Database?
An Overview of the HelpDesk Database
The Database Management System
Creating the Database
Creating the Tickets and Employees Tables
Normalization
Keys & Relationships
Manually Adding Data to Tables
Deploying the Completed Database to MySQL
Connecting the Database to the Defined Site
Module 4 - Working with the Structured Query Language (SQL)
Introduction to SQL
SQL Queries (The SELECT Statement)
SQL Clauses (WHERE and ORDER BY)
The INSERT Statement
The UPDATE Statement
The DELETE Statement
Expressions
Operators
Functions
Joins (INNER and OUTER Joins)
Generating and Saving Queries Visually
Module 5 - Working with Dynamic Data in Dreamweaver (Inserting Data)
Part 1 - Forms
Working with HTML Forms:
Adding a Form
Text Fields / Password Fields / Textarea
Menus / List Boxes / Jump Menu
Checkboxes / Checkbox Group
Radio Buttons / Radio Group
Submit Button, Reset Button, and Image Field
Other Form Elements
Stylizing the Form with CSS
Processing the Form Data
Part 2 - Inserting a New Ticket
Creating the HelpDesk Request Page
Validating the Form using Behaviors
Creating the Recordset
Inserting a New Ticket
Creating the Redirection Page
Part 3 - Inserting a New Employee
Creating the Administration Page
Creating the New Employee Page
Validating the Form using Behaviors
Creating the Recordset
Inserting a New Employee
Writing PHP to Display a Success Message
Module 6 - Working with Dynamic Data in Dreamweaver (Selecting Data)
Part 1 - Creating a Manage Tickets Page
Creating the Manage Tickets Page
Creating a Simple Recordset
Creating an Advanced Recordset
Creating a Recordset from a View
Working with Dynamic Text (Part 1)
Working with Dynamic Text (Part 2)
Recordset Paging / Recordset Navigation Bar
Displaying Recordset Counts
Showing Specific Regions
Using Repeat Region
Part 2 - Creating a Manage Employees Page
Creating the Manage Employees Page
Creating the Recordset
Using Dynamic Tables
Module 7 - Working with Dynamic Data in Dreamweaver (Updating and Deleting Data)
Creating the Employee Update Page
Passing Parameters
Filtering a Recordset by a Parameter
Working with Dynamic Form Elements
Using the Update Record Server Behavior
Creating the Ticket Update Page
Passing Params to the Ticket Update Page
Creating Ticket Recordsets
Filtering Recordsets by a Parameter
Setting Dynamic Form Elements
Using the Update Record Server Behavior
Using the Delete Record Server Behavior
Using the Master Detail Page Set
Module 8 - Securing your Web Application
Creating a Login Page
Logging in the Employee
Restricting Access Based on Username
Restricting Access Based on Password
Restricting Access Based on Role
Custom Error Messages
Check to See if an Employee Is Logged In
Logging Out Employees
Checking for Duplicate Usernames
Instructor: Zak Ruvalcaba
Zak Ruvalcaba has been researching, designing, and developing for the web
since 1995. He holds a Bachelor's Degree from San Diego State University and a Master of Science in
Instructional Technology from National University in San Diego. He served as Creative Director
with EPIC Solutions until 1998. His expertise in developing Web applications led him to a position
as Manager of Web Development at SkyDesk, Inc., where he developed Web applications for such
companies as Gateway, HP, Toshiba, IBM, Intuit, Peachtree, Dell, Covad Communications, and Microsoft.
He's worked for such companies as Wireless Knowledge (a Microsoft / Qualcomm company) as a wireless
software engineer developing web solutions for companies including Mellon Financial, Goldman Saks,
TV Guide, Healthbanks, The Gartner Group, Microsoft, Qualcomm, and Commerce One. His skill set
includes technologies and languages from HTML/XHTML, XML/XSLT/XPATH/XQUERY, JavaScript, CSS,
ASP, ASP.NET, VB, C#, ADO.NET, Web Services, SQL, T-SQL, Flash, ActionScript, and ColdFusion.
Aside from teaching and holding design lectures on various technologies and tools including HTML,
Dreamweaver, Flash, ASP.NET, ADO.NET, and Web Services for the San Diego Community College District,
Palomar College, and Mt. San Jacinto College, Zak Ruvalcaba is the author of the 10 Minute Guide to
Dreamweaver 4 on Que Publishing, Build Your Own ASP.NET Website using C# and VB on SitePoint Press,
Dreamweaver CS4 Unleashed on Sams Publishing, and Beginning Expression Web on Wrox Press.
Zak is a Microsoft Certified Application Developer for .NET (MCAD) and a Microsoft Certified
Solutions Developer for .NET (MCSD). He has also written numerous online articles involving Web
development, specifically ASP.NET technologies for Sitepoint.com as well as a featured cover story
in ASP.NET Pro Magazine's March 2005 issue.
