Building Data-Driven
Websites with Dreamweaver 8 (with ColdFusion MX, PHP, ASP.NET
or ASP)
Note: This course can be taught using either
Macromedia ColdFusion MX, PHP, ASP.NET or ASP 3.0.
Macromedia Dreamweaver 8 allows all users to create dynamic
database-driven websites with absolutely no hand-coding at all.
It has WYSIWYG (What You See Is What You Get) functions called
Server Behaviors that allow you to create a connection to a database,
query the database with a "Recordset" and display the
resulting records.
Course Outline
- Introduction to Dreamweaver MX
- The Dreamweaver MX interface
- Which server-side language is best?
- ColdFusion vs. PHP vs. ASP.NET vs. ASP
- Create a Dreamweaver "Site"
- EXERCISE: Build a Dreamweaver "Site"
- Database Basic
- Creating Database Connections
- Introduction to SQL
- Recordset Behavior
- EXERCISE: Build Recordset to Query the Database
- Display Resulting Records
- Repeat Region Behavior
- EXERCISE: Display Results from Recordset
- Paging Through Records
- Use "Go to next record" and "Go to Previous record" Behaviors
- EXERCISE: Paging through Records
- Conditional Display of Content
- "Show Region If..." Behaviors
- EXERCISE: Display Next and Previous Links only if needed
- Recordcount
- Display the number of Records returned
- EXERCISE: Display recordcount
- Psssing Variables
- "Go to Detail Page" Behavior
- EXERCISE: Build a link to pass a variable
- Advanced Recordsets and Multi-table Queries
- Simple Recordset with Filter
- Advanced Recordset
- Advanced Recordset and Multi-table Queries (JOIN)
- EXERCISE: Build a query that uses variable input
- Review
- EXERCISE: Cumulative Exercise
- Build Dynamic Select Lists
- Review of HTML Forms
- Display data in Select List
- EXERCISE: Dynamically Create Select Lists
- Insert Records
- "Insert Record" Behavior
- Client-side Form Validation
- EXERCISE: Insert Record
- Stored Procedures
- Insert new Record using Stored Procedure
- SQL Insert Statement
- EXERCISE: Insert New Record with Stored Procedure
- Edit Record
- "Edit Record" Behavior
- EXERCISE: BuildEdit Records
- Delete Records
- "Delete Record" Behavior
- EXERCISE: Build Page to Delete Record
- Build Password Protected Admin Section
- Create Login Page using "Login User" Behavior
- Password Protect a page with "Restrict Access to Page" Behavior
- EXERCISE: Utilize the "User Authentication" Behaviors
- Site Management Tools
- Design Notes
- Check Target Browsers
- Link Checker
- Reports
- Appendix: Extending Dreamweaver
- Find available Extensions
See also:
Adobe ColdFusion 8 Training Courses
Adobe Dreamweaver CS3 Training Courses
|