ASERT LOGO Advanced Software Engineering, Research and Training
Leading-Edge Courseware, Highly-Skilled Experienced Instructors

IW223: DATABASE-DRIVEN WEBSITES USING DREAMWEAVER MX 2004 (2 DAYS)

Course Overview

This course is designed for anyone who needs to develop dynamic data-driven web pages without writing the underlying program code.

Audience

This course is aimed specifically at:

  • Traditional application developers who want to build web-based applications
  • Static html content creators with some programming experience who want to be able to build web applications with more dynamic content
  • Webmasters, Web server administrators, System administrators who need to administer systems which connect to backend databases

Pre-Requisites

Attendees must have a basic understanding of the Internet, be familiar with using browsers and having a working knowledge of HTML. Some programming experience (C, Java, C# or as a minimum JavaScript) is required to appreciate the programming examples, and a familiarity with SQL basics will be beneficial. Exposure to the basic features of Dreamweaver MX 2004 is desirable. See ASERT's Introductory Dreamweaver MX 2004 if you need to brush up in this area.

Course Objectives

After the course, attendees will be able to create dynamic data-driven web content including searches and queries with a database.

Course Topics

  • The Role of Middleware Technologies in E-Commerce and Web Applications
  • Choosing among ASP, ASP.NET, JSP, PHP, and ColdFusion
  • Adding Server-Side objects and using Session Variables
  • How Scripts are Embedded within ASP, ASP.NET and JSP
  • Basic configuration: configuration files and options
  • Formatted Data and Web Pages
  • Interacting with Server-side applications using Forms
  • Database Concept Review (if required)
  • SQL Review (if required)
  • Connecting to an existing database
  • Using Recordsets
  • Server Behaviors
  • Paging and Database Cursors
  • Selectively Showing Regions
  • Master/Detail Pages
  • Inserting Records
  • Client-Side Form Validations
  • Server-Side Form Validations
  • Updating and Deleting Records
  • Multi-Table Queries
  • Using Stored Procedures and Views
  • Building Search Pages
  • Password Protection and Security
  • XML and Dreamweaver MX
  • Web Services in Dreamweaver MX