PHP with Dreamweaver Training Overview

Appextech'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.

PHP with Dreamweaver Training Objective

1. To learn how to build data-driven Web sites using Dreamweaver, PHP, and a database

PHP with Dreamweaver Training Outline

1. Introduction
1. Roles of server-side languages
2. Choosing a server-side language
3. Which server-side language is best?
4. Overview of PHP and its requirements
5. Goals of this class / Who is this class for?
2. Creating a Dreamweaver site
1. Site creation - basic
2. Site creation - advanced
3. Database connections
1. Database basics
2. Introduction to SQL
3. Server behaviors
4. Querying the database
1. Building a SQL query using the Simple view
2. Building a SQL query using the Advanced view
3. Adding fields from the resulting records to your page
5. Displaying and formatting query results
1. Using Repeat Region to display multiple records
2. Formatting results
6. Paging through records
1. Schemes for recordset navigation
2. Paging to first, last, previous, and next records
7. Show region if...
1. Selectively displaying information based on a conditional
2. Disabling the first and previous record links if the first page of results is displayed
3. Disabling the last and next record links if the last page of results is displayed
8. Displaying the count of the number of records returned
9. Creating master-detail views
1. Overview of the importance of master-detail views and how they convey information
2. Creating a master-detail view
10. Advanced recordsets and multi-table queries
1. Method 1 - Simple recordset with filter
2. Method 2 - Advanced recordset
3. Method 3 - Advanced recordset and multi-table Queries
11. Dynamically populating forms
1. Populating text fields, text areas, and hidden fields
2. Populating selection lists, radio button lists, and checkboxes
12. Building record insertion forms
1. Building the insertion form by hand
2. Allowing Dreamweaver to generate the record insertion form automatically
3. Creating a page that confirms the record insertion
4. Validating form entries using JavaScript behaviors
13. Understanding stored procedures
1. How they are created in the database
2. Advantages/disadvantages of stored procedures versus SQL
3. Calling a stored procedure without passing parameters
4. Passing input parameters to a stored procedure
5. Retrieving parameters from a stored procedure
14. Updating records
1. Manually constructing a form that allows the user to update a record
2. Using Dreamweaver to automatically generate a form for updating the record
3. Validating the edited information using JavaScript behaviors
4. Building a confirmation page to display the result of updating the record
15. Deleting records
1. Precautions to take to ensure that records are not inadvertently deleted
2. Building an appropriate record deletion interface, complete with confirmation dialog
16. Implementing user login/logout with Dreamweaver
1. Overview of Web application security issues
2. Preferred approach: configuring the Web server to manage security
3. Alternative approach: having Dreamweaver automatically generate code for logging users in, authenticating them, and logging them out
4. In-depth instruction on using Dreamweaver with PHP to implement user login/logout and page-by-page authentication