Building Database-Driven Web Sites Using Dreamweaver

2 day course

Dreamweaver is typically under utilized concerning its database connectivity features.  Dreamweaver has merged its easy-to-use interface with the robust database integration features of UltraDev and Drumbeat, Macromedia's previous Web-to-database development tools.  Dreamweaver inherits sophisticated source code editing and help facilities from Homesite.  Its current incarnation supports the major server side technologies Classic ASP, PHP, Coldfusion, ASP.NET and JSP.  Skills you will develop through this course include how to choose a web-to-database integration architecture, manage data by building interfaces for managing records from a database, understand SQL fundamentals, build and validate database-driven forms, send email via server-side technology, and test applications before they are deployed.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• Introducing Dreamweaver
• Introducing the Dreamweaver Interface
• Building Forms with Dreamweaver
• Session Variables
• An Overview of SQL
• Defining a Database Connection
• Defining a Recordset
• Server Behaviors
• Paging Through a Recordset
• Selectively Showing Regions
• Drilling Down with Master/Detail Pages
• Inserting a Record
• Client-Side Form Validations
• Updating or Deleting Records
• Multi-Table Queries
• Using Stores Procedures and Views
• Password Protection
• XML and Dreamweaver
• Web Services in Dreamweaver
• Creating ODBC DSN Outside Dreamweaver
• Dreamweaver MX Extensions