Dreamweaver: Dynamic Application Development Course
(4.75 out of 5) 21 Student Reviews
About the Course
During this 3 day course, participants will learn to build a dynamic web application using Dreamweaver CS6; with data transfer, email interactivity, forms, databases and drop-down menus. Other areas covered include filtering, recordsets, building search interfaces and authenticating users. The training exercises are conducted using a mock-website, so students finish the training with real world confidence.
Who should do this course?
This course is designed for anybody who wants to build database-driven website using PHP scripting language.
Prerequisites
Students should have already completed Dreamweaver: Website Development or have the equivalent experience. In addition, students must have a good understanding of HTML.
Course Details
$1485 incl GST
- Duration:3 Days
- Max. Class Size:10
- Avg. Class Size:5
-
Study Mode:
Classroom Online Live
- Level:Advanced
- CPD Hours:18 hours
- Course Times: Classroom: 9.00am - 5.00pm approx.(Local Time) Online Live: 9.00am - 5.00pm approx.(AEST or AEDT)
- Download Course PDF
Course Dates
Sydney Class Dates
Level 11, 32 Walker Street, North Sydney , NSW 2060
Classes scheduled on demand in Sydney
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Melbourne Class Dates
Level 12, 379 Collins Street, Melbourne , VIC 3000
Classes scheduled on demand in Melbourne
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Brisbane Class Dates
All courses facilitated in, Online Live format , QLD
Classes scheduled on demand in Brisbane
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Canberra Class Dates
All courses facilitated in, Online Live format , ACT
Classes scheduled on demand in Canberra
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Adelaide Class Dates
All courses facilitated in, Online Live format , SA
Classes scheduled on demand in Adelaide
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Perth Class Dates
All courses facilitated in, Online Live format , WA
Classes scheduled on demand in Perth
Please our waitlist and we'll notify you when a new class is scheduled or contact us to discuss your training needs.
Course Units
⊕ Expand full topic list
Unit 1: About Dynamic Websites
- Dynamic vs Static websites
- Understanding Application Servers
- Understanding Site Map
⊕ See more
Unit 2: Set Up a Local Development Environment
- Installing and configuring XAMPP
- Installing MySQL Workbench
- Installing Notepad++
- Setting up Dreamweaver for PHP development
- Set Dreamweaver preferences
- Define a Site in Dreamweaver
- Examine the current static site
- Replace ".html" extensions with ".php"
- Checking your PHP installation with phpinfo()
⊕ See more
Unit 3: Introduction to PHP
- PHP Syntax
- Functions
- Include Files
- Setting up the nav bar as an include file
- Variables
- Operators
- Arrays
- Discover Dynamically-Related Files
- Conditional Statements
- HTTP Request and Response
- Creating a test form page
- Capturing the form data with PHP variables
- Encoding a hyperlink with a query string
- Set up the footer as an include file
⊕ See more
Unit 4: Install and Configure a Contact Form
- Email header injection
- Install the GBCF-v3 Form Script
- Link the GBCF-v3 form page to contact.php
- Customise the form to match the site layout
- Test for header injection
⊕ See more
Unit 5: Create and Populate a MySQL Database
- Introduction to MySQL and phpMyAdmin
- Create a database
- MySQL field names and data types
- Create a database table
- Import data from an Excel document
- Create and import data into a tips table
- Set up MySQL user accounts
- Create additional database tables
- Import data into the new tables
⊕ See more
Unit 6: Displaying Content from the Database
- Creating Connections to the database
- Introduction to SQL (Structured Query Language)
- Run SQL queries in phpMyAdmin
- Run SQL queries in MySQL Workbench
- Creating a Recordset (SQL Query)
- Displaying dynamic content on a page
- Displaying a single tip on the home page
- Server Behaviors
- Displaying multiple tips on the home page
- Displaying lists
⊕ See more
Unit 7: Master & detail pages
- Creating a master list
- Displaying a dynamic image
- Adding a recordset navigation bar
- Displaying the recordset navigation status
- Linking the master & details pages
- Filter using the WHERE clause
- Creating a filtered recordset
- Populating the details page
- Joining database tables with the WHERE clause
- Joins in phpMyAdmin
- Formatting a number
- Creating an administrative template
⊕ See more
Unit 8: Inserting information into the database
- The SQL INSERT statement
- Creating an insert form
- Making the list menus dynamic
- Creating a dynamic list menu
- Creating an admin list page
- Inserting a new record
- Creating a insert form
- Storing text content in a database table
- Installing and configuring TinyMCE
- Creating and populating database tables
- Creating a page to list the site users
- Creating a page to register a new user
- Inserting a new user
⊕ See more
Unit 9: Registering and Authenticating Users
- Checking for existing usernames
- Creating login failed and welcome pages
- Completing the login page
- Creating a log out page
- PHP sessions
- Restricting Access to Page server behavior
- Greeting user by name on the welcome page
- Restricting access to admin pages
- Creating an administrator menu page
⊕ See more
Unit 10: Updating and Deleting Database Records
- Adding dynamic update and delete links
- The SQL UPDATE statement
- Creating an update form
- Updating an existing record
- The SQL DELETE statement
- Creating a delete page
- Deleting an existing product
- Modifying the list page
- Creating a update page
- Creating a delete page
⊕ See more
Unit 11: Searching the Database
- Creating a search page
- SQL queries using wildcards
- Displaying the search results
- Showing and hiding items based upon the data retrieved
- Showing a message when no records are found
- Hiding the Recordset Navigation Bar
- The SQL LIKE operator and Percent (%) wildcard
- Filtering using SQL variables
- Creating the joining & filtering SQL query
- Linking to the details page
- Creating a search page
- Creating a results page
⊕ See more
Unit 12: Performing Calculations
- Creating an advanced recordset
- Displaying details
- Adding a form for user to specify data
- Linking from the product-detail.php page
- Calculations with PHP
- Completing the cost estimator results page
⊕ See more
Related Courses
Student Reviews
Thoroughly enjoyed this course. Would like a similar course that outlines all the other administrative aspects of dynamic web sites
Everything has finally started to gel, so I am now looking forward to practicing what I have learnt.
Really great course. Taught me some great techniques that I will use in the real world. Thank you very much!
Jonathan is a wonderful trainer who ensures everyone gets what they came for and learns as much as possible in the given time. He has as a thorough knowledge of the subject and shares a wealth of experience through detailed examples and practical exercises, making the course a pleasure to attend.
very detailed course. It was great to get understanding of how everthing works together. Jonathan was patient and provided detailed answers to questions
This course was far more enjoyable than the introductory PHP module. It provides students with a better understanding of the potential power of both php and sql. Mark was great.... Good couple of days.
Again, I really enjoyed this course - as tired as I now am! I think Jonathon has really done a grea job with teaching this course and I have learnt a lot.
this course provided me with the skills needed to start adding dynamic elements rather than always building static pages. Jonathan was an excellent, calm, intelligent instructor
Very in depth and extremely useful. Mark did an excellent job of explaining details before we did hand on tasks.
Enquire Now
Fill in your details to have a training consultant contact you to discuss your training needs.
Note: Form fields marked with * are required.
