Training Resources
Accessibility

Web Development

Adobe / Macromedia Web
Programming

Visual Studio 2005 (.NET 2.0):
VB.NET Application Development
ADO.NET Data
Programming in VB
C#.NET Application Development
ADO.NET Data
Programming in C#
Visual Studio 2008 (.NET 3.5):
VB.NET Application Development
C#.NET Application Development
What's New in VS2008
(2-day courses):
Databases

Professional Courses

Project Management
with
Microsoft Project
Managing Enterprise Projects
Using Project Server
Adobe

Microsoft SharePoint

Technical

Geographic (GIS)

ESRI ArcGIS 9.2:
ESRI ArcGIS 9.3:
Microsoft Office

Training Resources
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.
Course Topics:
(for a full detailed outline, visit our PDF link above)
Introducing Dreamweaver
- What is Macromedia Dreamweaver?
- The role of middleware technologies
- Choosing among ASP, ASP.NET, JSP, PHP, and ColdFusion
Introducing the Dreamweaver Interface
- The Dreamweaver interface
- Defining a site in Dreamweaver
- Starting a site
Building Forms with Dreamweaver
- Key considerations in designing your form
- Building a simple form
- Processing form results
Session Variables
- Embedded scripts within ASP, ASP.NET and JSP
- Storing values in the session object
- Remembering visitors’ names w/session variables
An Overview of SQL
- Data types in SQL
- Creating a table in SQL
- Retrieving info from the database via SELECT
- Editing records in the database via UPDATE
- Removing records from the database via DELETE
Defining a Database Connection
Defining a Recordset
- Creating a Recordset in Dreamweaver
- Advanced Recordset interface
Server Behaviors
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?
- Behaviors, events and actions
- Implementing a form validation
Updating or Deleting Records
Multi-Table Queries
Using Stored Procedures and Views
- What are views?
- What are stored procedures?
- Advantages of stored procedures
- Using a view in Dreamweaver
Password Protection
XML and Dreamweaver
Web Services in Dreamweaver
Creating ODBC DSN Outside Dreamweaver
Dreamweaver MX Extensions
- Sending Email with the CDO Mail Extension
