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
• Creaing 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
• Editing WordPress, Drupal and Joomla sites directly in the Dreamweaver Document window
