Adobe Dreamweaver Level 3 - Database Integration

Summary

Course Aim:

The Dreamweaver Level 3 course is a comprehensive course that builds on the skills developed in the Dreamweaver Level 2 course and is aimed at advanced Dreamweaver users who want to set up and build a database-driven Website using PHP (a popular free scripting language) and MySQL (a popular free database engine). You will learn basic PHP scripting and MySQL commands, and how to integrate both into Dreamweaver to set up a dynamic, database-driven Website. Courseware supplied; commercial.

This is a specialised Dreamweaver course for connecting a website to a database for the maintenance of data.

Course Prerequisites:

The prerequisites for this course is that you have completed the Dreamweaver Level 2 course or have equivalent knowledge (or have a very good understanding of Dreamweaver, particularly CSS and HTML).

Course Duration:

Two days 9:00am – 4:30pm

Classroom courses include:

  • Adobe Certified instructors (with min 10 yrs experience)
  • Alpha prepared comprehensive coursenotes with tutorials and exercises (updated frequently to reflect industry trends)
  • Certificates
  • eLearning DVD Package (FREE at course registration where available, see our SPECIALS)
  • After course support, unlimited HELP DESK (via email, to reinforce the learning), helpdesk@alphacc.com.au
  • Training guarantee
  • FREE repeat of public course within 6 months (where required, and on same version), see terms & conditions

Content

Course Content

During this course you will learn about:

Topic 1 Introducing Newland Tours

  • Topic Objectives
  • Defining a Static Site
  • Formatting the Contact Us Page
  • Creating the Contact Us Page Assessing the Site: The Code
  • Assessing the Site: Business Processes
  • A Glimpse of the Future

Topic 2 Preparing the static HTML and CSS

  • Automating changes with find and replace
  • Redefining HTML elements with CSS
  • Creating a reusable template
  • Enhancing accessibility with invisible navigation

Topic 3 Dynamic Web Sites

  • Dynamic web site basics
  • Choosing a server model
  • Redefining the Newland Tours site for dynamic development
  • Developing with a local server
  • Setting up a local environment for IIS/ASP
  • Setting up a local environment for ColdFusion
  • Setting up a local environment for Apache/PHP
  • Developing with a remote server
  • Defining a dynamic site in Dreamweaver

Topic 4 Passing data between pages

  • Understanding the HTTP protocol
  • Retrieving data from the URL
  • Sending data with hyperlinks
  • Sending a receiving cookies

Topic 5 Sending email from a web form

  • Introducing SMTP Email Service
  • Configuring your system to send SMTP emails
  • Writing the Code to send a message
  • Understanding objects, methods, and properties
  • Creating the web form
  • Emailing dynamic form variables
  • Client-side form validation

Topic 6 Building a Tour Price Calculator

  • Building the form
  • Collecting, processing and displaying the data
  • Adding server-side form validation
  • Creating the conditional region
  • Creating and applying a custom CSS class

Topic 7 Databases on the Web

  • A crash course on databases
  • Introducing database objects
  • Understanding relationships
  • Databases on the web
  • Database security and the web
  • Installing and running MySQL
  • Touring the Newland database
  • Connecting to a database
  • Retrieving recordsets and displaying database information

Topic 8 Completing the Tour Price calculator

  • Dynamically populated drop-down menus
  • Creating filtered recordsets
  • Revising the calculation script with live data
  • Documenting your code with comments

Topic 9 Filtering and displaying data

  • Preparing the input page
  • Generating URLs dynamically
  • Preparing the output page
  • Populating page layouts dynamically
  • Adding dynamic images and formatting the population number
  • Looking up foreign table data with SQL

Topic 10 Building the Tour Descriptions

  • Planning the application
  • Creating the recordsets with Joins
  • Building the descriptions
  • Inserting the images with alt attributes
  • Implementing Recordset paging
  • Passing data to other applications

Appendix A: Index

Back to top

Packages

Packages Available

We offer various packages, designed for users who want to upgrade their skills across a range of Adobe applications.

This course is not currently available as part of a package. Please click the specials link above to see if specials are currently available for this course.

Visit our packages page for more information

Specials

The DW L3 course is not offered as part of a special.

2010 Training Special for Sydney-Brisbane-Melbourne-Canberra Centres

Option 1 (SYD-BRIS-MELB):

Selected Level 1 courses $800 from 27/04/2010

Selected Level 1 public courses in our Sydney-Brisbane-Melbourne Training Centres are now $800 (RRP $935) during the promotional period. The offer can’t be taken with another offer or promotion.

Option 2 (SYD-BRIS-MELB-CANB):

Buy 2 * 2-day courses and get a 1-day course FREE

Support your staff by upskilling them.

Alpha is offering a FREE 1-day course to the person attending TWO 2-day public courses (at RRP pricing) in our Sydney-Brisbane-Melbourne-Canberra Training Centres during the promotional period. The offer can’t be taken with another offer or promotion and will be limited to specific 1-day courses. Courses will be invoiced together (two 2-day courses, at RRP pricing, plus 1-day free course) and must be paid in full before course commencement to obtain free course. Register for TWO public 2-day courses to obtain the FREE 1-day course.

Option 3 (SYD-BRIS-MELB):

Buy 2 * 2-day courses and get 15% OFF both courses

Support your staff by upskilling them.

Alpha is offering a 15% discount OFF to the person attending TWO 2-day public courses (at RRP pricing) in our Sydney-Brisbane-Melbourne Training Centre during the promotional period. The offer can’t be taken with another offer or promotion. Courses will be invoiced together (two 2-day courses to one attendee, at RRP pricing, less 15% OFF) and must be paid in full before course commencement to obtain free course. Register for TWO public 2-day courses to obtain the 15% discount off.

Option 4 (SYD-BRIS-MELB):

Buy Acrobat Package for $800 (Package RRP normally $850) from 27/04/2010

The Acrobat Package (Acrobat for Business and Acrobat Advanced) public courses in our Sydney-Brisbane-Melbourne Training Centres is now $800 during the promotional period (Package RRP normally $850; note the 2 courses bought separetely are $945). The offer can’t be taken with another offer or promotion and is limited.

 

eLearning DVD

When you attend the any of the following scheduled courses, you will receive a FREE eLearning DVD:

  • Acrobat for Business
  • PhotoShop Level 1
  • Illustrator Level 1
  • InDesign Level 1
  • Dreamweaver Level 1
  • Flash Level 1
  • Acrobat Advanced
  • PhotoShop Level 2
  • Illustrator Level 2
  • InDesign Level 2
  • Dreamweaver Level 2
  • Flash Level 2

Specials are subject to our terms and conditions

Gift Vouchers

When you give an Alpha Computer Consultants Gift voucher, you let people choose their own reward from the entire list of courses and consulting we provide. It is much more effective than other incentive schemes as they can choose which courses they want to benefit from.

As part of our new launch of these gift vouchers, when you purchase 2 or more vouchers you will go into the running to win a corporate pack, which includes a Free 1 day public course of your choice, an eLearning CD Package ( where applicable) and a bottle of wine.

Course cost

$CALL

Less with Packages

Duration

2 days

Registration Steps:

  1. 1.Choose your course,
  2. 2.Contact us for specials/availablility,
  3. 3.Return to this site and register online using the BUY link in your city timetable or call us.

Register now to ensure a place:

Buy Sydney

Buy Melbourne

Buy Canberra

Buy Brisbane

Adobe and Enfocus software for sale. Visit our store.