Building Data-Driven PHP Web Sites with Dreamweaver Training

PHP with Dreamweaver Training Overview
Accelebrate's Building Data-Driven PHP Web Sites with Dreamweaver training class teaches attendees the Dreamweaver and PHP skills they need to integrate databases with their Web site.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor’s or students’ travel expenses. To receive a customized proposal and price quote private training at your site or online.
In addition, some courses are available as live, online classes for individuals.
PHP with Dreamweaver Training Prerequisites
Accelebrate's Beginning Macromedia Dreamweaver 8, Introduction to Adobe Dreamweaver CS3, or equivalent experience.
Alternative Class
If you are interested in learning PHP programming, we encourage you to consider our Introduction to PHP & MySQL training class.
Hands-on/Lecture Ratio
This Dreamweaver training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.
PHP with Dreamweaver Training Materials
All students for this Dreamweaver training class receive a copy of Macromedia Press' Macromedia Dreamweaver with ASP, ColdFusion, and PHP: Training from the Source and related courseware.
Software Needed on Each Student PC
Firefox 2.0 or later or Internet Explorer 6 or later
Dreamweaver 8, CS3, or later (course can also be taught using Dreamweaver MX 2004 or MX)
Microsoft Internet Information Server, Apache Web server, Tomcat, or another appropriate Web server software package.
A database server, such as MySQL™ (free), SQL Server, or Oracle (this can be installed on each student PC or on a server reachable over the network from these PCs)
PHP with Dreamweaver Training Objective
To learn how to build data-driven Web sites using Dreamweaver, PHP, and a database
PHP with Dreamweaver Training Outline
*Introduction
Roles of server-side languages
Choosing a server-side language
Which server-side language is best?
Overview of PHP and its requirements
Goals of this class / Who is this class for?
*Creating a Dreamweaver site
Site creation - basic
Site creation - advanced
*Database connections
Database basics
Introduction to SQL
Server behaviors
*Querying the database
Building a SQL query using the Simple view
Building a SQL query using the Advanced view
Adding fields from the resulting records to your page
*Displaying and formatting query results
Using Repeat Region to display multiple records
Formatting results
*Paging through records
Schemes for recordset navigation
Paging to first, last, previous, and next records
*Show region if...
Selectively displaying information based on a conditional
Disabling the first and previous record links if the first page of results is displayed
Disabling the last and next record links if the last page of results is displayed
*Displaying the count of the number of records returned
*Creating master-detail views
Overview of the importance of master-detail views and how they convey information
Creating a master-detail view
*Advanced recordsets and multi-table queries
Method 1 - Simple recordset with filter
Method 2 - Advanced recordset
Method 3 - Advanced recordset and multi-table Queries
*Dynamically populating forms
Populating text fields, text areas, and hidden fields
Populating selection lists, radio button lists, and checkboxes
*Building record insertion forms
Building the insertion form by hand
Allowing Dreamweaver to generate the record insertion form automatically
Creating a page that confirms the record insertion
Validating form entries using JavaScript behaviors
*Understanding stored procedures
How they are created in the database
Advantages/disadvantages of stored procedures versus SQL
Calling a stored procedure without passing parameters
Passing input parameters to a stored procedure
Retrieving parameters from a stored procedure
*Updating records
Manually constructing a form that allows the user to update a record
Using Dreamweaver to automatically generate a form for updating the record
Validating the edited information using JavaScript behaviors
Building a confirmation page to display the result of updating the record
*Deleting records
Precautions to take to ensure that records are not inadvertently deleted
Building an appropriate record deletion interface, complete with confirmation dialog
*Implementing user login/logout with Dreamweaver
Overview of Web application security issues
Preferred approach: configuring the Web server to manage security
Alternative approach: having Dreamweaver automatically generate code for logging users in, authenticating them, and logging them out
In-depth instruction on using Dreamweaver with PHP to implement user login/logout and page-by-page authentication
*Conclusion