Overview
Dreamweaver is Macromedia's tool for building powerful, database-driven Web sites. Dreamweaver 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 inherits sophisticated source code editing and help facilities from Homesite.
Objectives
By the end of the class students will be able to:
- Choose a Web-to-database integration architecture
- Understand Standard Query Language (SQL) fundamentals, the standard query language supported by all relational databases
- Select, insert, update, and delete data by building interfaces for retrieving, adding, editing, and removing records from a database
- Build database-driven forms to populate their information via a database
- Validate forms using Dreamweaver's automatic form validation features
- Send e-mail via server-side technology
- Test applications before they're deployed
NOTE: During class, ColdFusion MX 7 will be used as the server side technology. However, the techniques taught work equally well (with some modifications) with Active Server Pages (both Classic and .NET), or PHP technology. We recommend that you teach this class using version MX 2004 and 8.
Prerequisites:
- Introduction to Macromedia Dreamweaver or equivalent real-world experience with Dreamweaver.
Stronly Recommended (not required)
- Advanced Macromedia Dreamweaver
- Prior SQL experience
Follow-Ups:
- I Introduction to ColdFusion MX 7 for New Programmers
- Introduction to Microsoft Active Server Pages for New Programmers
- Introduction to SQL and Database Design
- Introduction to Macromedia Flash
Course duration
2 Days
Course outline
Introducing Dreamweaver MX 2004
- What is Macromedia Dreamweaver MX?
- The Role of Middleware Technologies
- Choosing among ASP, ASP.NET, JSP, PHP, and ColdFusion
Introducing the Dreamweaver Interface
- The Dreamweaver MX Interface
- Defining a Site in Dreamweaver MX
- Starting a Site
Building Forms with Dreamweaver Key Considerations in Designing your Form
Processing Form Results
- Session Variables
- How Scripts are Embedded within ASP, ASP.NET and JSP
- Storing Values in the Session Object
- 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
- Defining a Recordset
- Creating a Recordset in Dreamweaver MX
- The Advanced Recordset Interface
- Displaying One Director’s Information
Server Behaviors
- Displaying Several Directors
Paging through a Recordset
- Database Cursors
- Previous Record and Next Record Server Behaviors
Selectively Showing Regions
- Drilling Down with Master/Detail Pages
- Inserting a Record
- Inserting a New Director
- Inserting a New Movie/Populating a SELECT List
Client-Side Form Validations
- What is JavaScript?
- What are form validations?
- Dreamweaver: Behaviors, Events and Actions
- Implementing a Form Validation
Updating Records
- Updating a Director’s Information
Deleting Records
- Multi-Table Queries
- Listing All Movies with Directors
Using Stored Procedures and Views
- What are Views?
- What are Stored Procedures?
- Advantages of Stored Procedures
- Using a View in Dreamweaver MX
Password Protection
- Password-Protecting Your Pages
- XML and Dreamweaver MX
- Web Services in Dreamweaver MX
- Creating an ODBC DSN Outside Dreamweaver MX
- Dreamweaver MX Extensions
- Sending Email with the CDO Mail Extension
|
