Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Dreamweaver MX 2004 Building Database-driven Websites
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
  • Building a Simple 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

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy
Copyright © SB