Dreamweaver CS5 CS6 CC - Create Websites Connected to Databases - Dynamic SQL

Adobe Dreamweaver - Building Dynamic Sites - Training Course

This course requires a basic understanding of database struture and a good knowledge of DreamWeaver CS5 CS6 CC (at least to our Dreamweaver Intro level):

Course Content CS5 CS6 CC

Dreamweaver environment

• Advantages of dynamic web applications
• Application server environments
• Create and manage a dynamic site

Dynamically generated content

• Connect to database (ODBC connections in Windows 2000)
• Describe basic SQL statements and build SQL queries
• Add a recordset to a page
• Insert data on a web page
• Add live data elements to a page
• Build a dynamic page that displays catalogue information

Understanding Server Behaviours

• Explain the recordset server behaviour
• Create and use a server behaviour to include a file
• Download new server behaviours

Building and Navigating a Multiple-row Result list

• Create repeat regions
• Build a navigation bar
• Build a navigation status bar

Building a Master/Detail Interface using URL parameters

• Create links between pages in your application
• Use URL parameters to build a Master/Detail pair
• Use the Go to Detail Page Server Behaviour
• Use a query string to filter a recordset
• Use the Go to Related Page Server Behaviour to provide a 'back button' facility

Building a Search Page with Dynamic SQL

• Build a simple search form
• Add a SQL variable in the Recordset dialogue box
• Create a multi-parameter search form
• Add a static option to a list element
• Write a SQL statement using wildcards
• Create a recordset from more than one table

Maintaining data

• Use the Record Server Behaviour
• Create an update page
• Use form validation behaviours

Setting up Password Protection and Security

• Describe the need for site security
• Password protect your site
• Restrict access to site resources based on user identification
• Create a self-registration system for your site

Managing Sessions

• Understand Session Management
• Add a variable to the session object
• Manually write server-side code to access session variables