Navigation
- Courses
- About our Training
- FREE eLearning Videos
- Training Resources
- Custom Courses
- Which course is right for me?
Course cost
$ see timetable for pricing
Less with Packages
Duration
2 days
Registration Steps:
- 1.Choose your course,
- 2.Contact us for specials/availablility,
- 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:
Adobe Dreamweaver Level 3 - Database Integration Course
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)
- Commercial coursenotes with tutorials and exercises
- 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 topPackages
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
This course is not offered as part of any Special.
2012 Training Specials for Sydney, Brisbane, Melbourne, Canberra Centres
- Sydney Training Specials
-
Option 1 (SYDNEY):
-
Selected Level 1 courses $775
-
Selected Level 1 public courses in our Sydney Training Centre are now $775 (RRP $935) during the promotional period. The offer can't be taken with another offer or promotion.
-
Option 2 (SYDNEY):
-
Selected Level 2 courses $775
-
Selected Level 2 public courses in our Sydney Training Centre are now $775 (RRP $935) during the promotional period. The offer can't be taken with another offer or promotion.
-
Option 3 (SYDNEY):
-
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 Training Centre during the promotional period. The offer can't be taken with another offer or promotion and is a limited offer, 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 4 (SYDNEY):
-
Buy Acrobat Package for $775 (Package RRP normally $945)
-
The Acrobat Package (Acrobat for Business and Acrobat Advanced) public courses in our Sydney Training Centre is now $800 during the promotional period (Package RRP normally $945; note the 2 courses bought separetely are $945). The offer can't be taken with another offer or promotion and is limited.
-
- Brisbane Training Specials
-
Option 1 (BRISBANE):
-
Selected Level 1 courses $775
-
Selected Level 1 public courses in our Brisbane Training Centre are now $775 (RRP $935) during the promotional period. The offer can't be taken with another offer or promotion.
-
Option 2 (BRISBANE):
-
Selected Level 2 courses $775
-
Selected Level 2 public courses in our Brisbane Training Centre are now $775 (RRP $935) during the promotional period. The offer can't be taken with another offer or promotion.
-
Option 3 (BRISBANE):
-
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 Brisbane Training Centre during the promotional period. The offer can't be taken with another offer or promotion and is a limited offer, 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 4 (BRISBANE):
-
Buy Acrobat Package for $775 (Package RRP normally $945)
-
The Acrobat Package (Acrobat for Business and Acrobat Advanced) public courses in our Brisbane Training Centre is now $775 during the promotional period (Package RRP normally $945; note the 2 courses bought separetely are $945). The offer can't be taken with another offer or promotion and is limited.
-
- Melbourne Training Specials
-
Option 1 (MELBOURNE):
-
Selected Level 1 courses $775
-
Selected Level 1 public courses in our Melbourne Training Centres are now $775 (RRP $935) during the promotional period. The offer can't be taken with another offer or promotion.
-
Option 2 (MELBOURNE):
-
Selected Level 2 courses $775
-
Selected Level 2 public courses in our Melbourne Training Centres are now $775 (RRP $935) during the promotional period. The offer can't be taken with another offer or promotion.
-
Option 3 (MELBOURNE):
-
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 Melbourne Training Centre during the promotional period. The offer can't be taken with another offer or promotion and is a limited offer, 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 4 (MELBOURNE):
-
Buy Acrobat Package for $775 (Package RRP normally $945)
-
The Acrobat Package (Acrobat for Business and Acrobat Advanced) public courses in our Sydney-Brisbane-Melbourne Training Centres is now $775 during the promotional period (Package RRP normally $945; note the 2 courses bought separetely are $945). The offer can't be taken with another offer or promotion and is limited.
-
- Canberra Training Specials
-
Option 1 (CANBERRA):
-
Buy 2 * 2-day courses and get 10% OFF
-
Support your staff by upskilling them.
-
Alpha is offering a 10% discount to the person attending TWO 2-day public courses (at RRP pricing) in our Canberra Training Centre during the promotional period. The offer can't be taken with another offer or promotion and is a limited offer. Courses will be invoiced together (two 2-day courses, at RRP pricing, less 10%) and must be paid in full before course commencement to obtain free course. Register for TWO public 2-day courses to obtain the 10% discount.
-
Option 2 (CANBERRA):
-
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 Canberra Training Centre during the promotional period. The offer can't be taken with another offer or promotion and is a limited offer, 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.
-
eLearning DVD
When you attend any of the following scheduled courses, you will receive a FREE eLearning DVD:
- Acrobat for Business and Advanced
- PhotoShop Level 1, and Level 2
- Illustrator Level 1, and Level 2
- InDesign Level 1, and Level 2
- Dreamweaver Level 1, and Level 2
- Flash Level 1, and 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.
