Objectives
This Adobe certified course provides students with the knowledge and hands-on practice they need to build a dynamic data-driven web application with Dreamweaver. The course focuses on teaching the fundamentals of web programming languages and databases to build a dynamic, data-driven application using Dreamweaver, PHP and MySQL.
Pre-requisites
None other than basic IT competency.
Course includes
A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.
Course outline
Getting Started
- Overview of the web client-server relationship
- Understanding static vs. dynamic pages
- Introducing server-side scripting
- Installing and configuring a Web Server
- Setting up the Application Server
- Installing the database
- Testing the Web Server
- Developing with a remote vs. local server
- A brief introduction to server-side code
- Documenting your code with comments
Setting up a Site
- Defining a new dynamic site
- Specifying the server model
- Creating a new dynamic page
- Including common code with Server-Side Includes
Overview of Databases
- Types of databases: flat files, hierarchical, relational
- Advantages of Relational Databases
- Types of Relational Databases
- Records, Fields and Values
- Primary and Foreign Keys
- Using databases on the Web
- Connecting to databases
- Structured Query Language (SQL)
Using the Database Panel
- Creating a database connection
- Looking at the code Dreamweaver creates
- Using the Bindings panel to create a simple recordset
- Creating an advanced recordset using joins
Binding Data to a Page
- Binding Data to a page; Using Live Data View
- Formatting data using the Bindings panel
- Inserting a dynamic image
Customising Recordset Display
- Introducing Server Behaviours
- Showing rows in a recordset with Repeat Region
- Building recordset paging manually
- How to show or hide data conditionally
- Displaying Recordset Navigation Status
Introduction to SQL
- What is SQL? Using SQL in Dreamweaver
- Using the SELECT Statement
- Filtering a recordset with SQL
- Specifying a sort order with SQL
- Combining two or more tables
Passing data between pages
- Understanding the HTTP protocol
- Two methods for sending data: GET and POST
- Retrieving data with query strings/URL variables
- Retrieving data from hyperlinks
- Retrieving data from form variables
Creating a Search Interface
- Reviewing HTML Forms
- Creating dynamically populated drop-down menus
- Creating filtered recordsets
Creating Drill-Down Interfaces
- Planning an application
- Creating a drill-down interface
- Generating URLs dynamically
- Creating a master-detail page set
Inserting Data into a Table
- Creating a form and using the Insert Record Server Behaviour
- Validating form data using Behaviours
- Creating dynamic form elements
- Client-side form validation
Updating Records
- Creating an interface for updating data
- Displaying results in a table using the Dynamic Table Application Object
- Creating a pre-filled form for the row to update
- Using URL parameters / Record Update Form Application Object
- Manually creating a form and applying an Update Record Server Behaviour
Deleting Rows
- Understanding the delete process
- Creating a delete confirmation page
- Passing hidden data in a form
- Deleting a specific record
Authenticating Users
- Authenticating users with a web application
- Building the login page
- Restricting access to pages
- Applying different levels of access
Sending E-mail from a Web Form
- Overview of form mailing
- Code required to send an email
- Creating the Web form
- Using a secure email script
Using Dreamweaver with popular Content Management Systems
- Using Site-Specific Code Hints
- WordPress, Drupal and Joomla sites directly in the Dreamweaver Document window