Dreamweaver Dynamic & SQL

Total time
Logo Mullan Training

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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 dyn…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, Adobe (Macromedia) Dreamweaver, PL/SQL, Programming (general), and IT Security.

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
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.