Home » Training Courses » Web Design Training » Databases with Dreamweaver Training

Databases with Dreamweaver Training

• Book this course
• Email to a friend
• Download PDF

This Advanced Dreamweaver with Databases training course covers the database functionality in Dreamweaver, providing the delegates with the knowledge they need to be able to create websites with dynamically created content.

Dreamweaver with Databases Training Course Objectives

After attending this Dreamweaver course, you will be able to:

• Set up the Dreamweaver environment
• Set up a database connection
• Publish dynamically generated content
• Understand server behaviours
• Build and navigate a multiple-row recordset
• Build a Master/Detail pair
• Build a search form with dynamic SQL
• Populate and maintain a database using live objects
• Set up password protection and security systems
• Manage user sessions

Dreamweaver With Databases Course Content

Server models supported – ASP3 (VBScript), ASP.NET, ColdFusion MX, PHP4 or PHP5
Database Management Systems Supported – MS Access 2000, MySQL

Dreamweaver Training Course Overview

• Understand course objectives
• Understand course pre-requisites

Dreamweaver environment

• Advantages of dynamic web applications
• Application server environments
• Create and manage a dynamic site

Dynamically generated content

• Connect to database (ODBC connections in Windows)
• Describe basic SQL statements and build SQL queries
• Add a recordset to a page
• Insert data on a web page
• Add live data elements to a page
• Build a dynamic page that displays catalogue information

Understanding Server Behaviours

• Explain the recordset server behaviour
• Create and use a server behaviour to include a file
• Download new server behaviours

Building and Navigating a Multiple-row Result list

• Create repeat regions
• Build a navigation bar
• Build a navigation status bar

Building a Master/Detail Interface using URL parameters

• Create links between pages in your application
• Use URL parameters to build a Master/Detail pair
• Use the Go to Detail Page Server Behaviour
• Use a query string to filter a recordset
• Use the Go to Related Page Server Behaviour to provide a ‘back button’ facility

Building a Search Page with Dynamic SQL

• Build a simple search form
• Add a SQL variable in the Recordset dialogue box
• Create a multi-parameter search form
• Add a static option to a list element
• Write a SQL statement using wildcards
• Create a recordset from more than one table

Maintaining data

• Use the Insert Record Server Behaviour
• Create an update page
• Use form validation behaviours

Setting up Password Protection and Security

• Describe the need for site security
• Password protect your site
• Restrict access to site resources based on user identification
• Create a self-registration system for your site

Managing Sessions

• Understand Session Management
• Add a variable to the session object
• Manually write server-side code to access session variables

Databases with Dreamweaver Training Course Prerequisites

Delegates on this Dreamweaver training course must have completed the Dreamweaver training course or have equivalent knowledge.

Read the full Databases with Dreamweaver Training Course Outline

For full course content and pre-requisites download the Databases with Dreamweaver Training Course PDF

Share This