Macromedia Dreamweaver MX Building Database-backed Websites

Dreamweaver MX is Macromedia's tool for building powerful, database-driven Web sites. Dreamweaver MX merges the easy-to-use interface of Dreamweaver with the robust database integration features of UltraDev and Drumbeat, Macromedia's previous Web-to-database development tools. Dreamweaver MX inherits sophisticated source code editing and help facilities from Homesite.

After completing this two-day course, students will be able to:

• Choose a Web-to-Database Integration Architecture
• Learn Standard Query Language (SQL) Fundamentals
• Select, Insert, Update, and Delete Data in Your Database
• Build Database-Driven Forms
• Validate Forms
• Send E-mail Confirmation
• Test Your Applications

Target audience

Students should have a good working knowledge of Dreamweaver gained through practical experience or from attending an introductory-level course. Advanced level Dreamweaver and prior SQL experience are strongly recommended but are not a mandatory prerequisite.

Course content

Introducing Dreamweaver MX What is Macromedia Dreamweaver MX? • The Role of Middleware Technologies • Choosing among ASP, ASP.NET, JSP, PHP, and ColdFusion • Introducing the Application for this Class: The Movie Directors Hall of Fame • Downloading the Files for the Class

Introducing the Dreamweaver MX Interface The Dreamweaver MX Interface • Defining a Site in Dreamweaver MX • Exercise 1: Starting a Site

Building Forms with Dreamweaver MX Key Considerations in Designing your Form • Exercise 2: Building a Simple Form

Processing Form Results Exercise 3: Processing the Greeting page

Session Variables How Scripts are Embedded within ASP, ASP.NET and JSP • Storing Values in the Session Object • Exercise 4: Remembering a Visitor’s Name with a Session Variable

Database Concept Review

An Overview of SQL Data Types in SQL • Creating a Table in SQL • Inserting a Row into the Table in SQL • Inserting a Partial Row (or Fields in a Different Order) in SQL • Retrieving Information from the Database via SELECT • Editing Records in the Database with the UPDATE Statement • Removing Records from the Database with the DELETE Statement

Defining A Database Connection in Dreamweaver MX Exercise 5: Defining a Database Connection

Defining a Recordset Creating a Recordset in Dreamweaver MX • The Advanced Recordset Interface • Exercise 6: Displaying One Director’s Information

Server Behaviors Exercise 7: Displaying Several Directors

Paging through a Recordset Database Cursors • Previous Record and Next Record Server Behaviors • Exercise 8: Paging through the Director List

Selectively Showing Regions Exercise 9: Showing Only Necessary Links

Drilling Down with Master/Detail Pages Exercise 10: Drilling Down from Directors to Movies • Exercise 11: The Director Search Interface

Inserting a Record Exercise 12: Inserting a New Director • Exercise 13: Inserting a New Movie/Populating a SELECT List

Client-Side Form Validations What is JavaScript? • What are form validations? • Dreamweaver: Behaviors, Events and Actions • Exercise 14: Implementing a Form Validation

Updating Records Exercise 15: Updating a Director’s Information

Deleting Records Exercise 16: Deleting a Director

Multi-Table Queries Exercise 17: Listing All Movies with Directors

Using Stored Procedures and Views What are Views? • What are Stored Procedures? • Advantages of Stored Procedures • Exercise 18: Using a View in Dreamweaver MX

Password Protection Exercise 19: Password-Protecting Your Pages

XML and Dreamweaver MX

Web Services in Dreamweaver MX

Appendix A: Creating an ODBC DSN Outside Dreamweaver MX

Appendix B: Dreamweaver MX Extensions Exercise: Sending Email with the CDO Mail Extension

Appendix C: Recommended Resources Books • Newsgroups • Web Resources

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today