|
Dreamweaver Databases
Outline
Aims of the Two-Day Course
This course has been designed to give delegates an understanding of
the full database capabilities of Dreamweaver and to give them the skills
needed to create database driven Web sites. The course is suitable for
Web designers and developers interested in adding database connectivity,
dynamic content and e-commerce features to their web site. The course
is 100% hands-on, with exercises to help the trainees practice the new
skills they learn.
Course Content
- Dynamic web sites
- Dynamic web site basics
- Choosing a server model
- Redefining a site for dynamic development
- Windows running IIS or PWS locally
- Defining a dynamic site in Dreamweaver
- Building a simple, dynamic application
- Creating the input page
- Creating the output page
- Passing data between pages
- Understanding the HTTP Protocol
- Retrieving data with QueryStrings
- Sending data with Hyperlinks
- Setting and retrieving Cookies
- Sending email from a web form
- What you will learn
- Introducing SMTP email service
- Configuring your system to send SMTP email messages
- Configuring IIS to send email (ASP)
- Writing the code to send a message
- Understanding objects, methods, and properties
- Creating the web form
- Emailing dynamic form values
- Client-side form validation
- Building a price calculator
- What you will learn
- Creating the pages
- Building the form
- Collecting, processing, and displaying the data
- Adding server side form validation
- Creating the conditional region
- Creating and applying a custom CSS class
- Databases on the web
- What you will learn
- A crash course on databases
- Introducing database objects
- Understanding relationships
- Databases on the web
- Touring the database
- Connecting to a database
- Creating Recordsets and displaying database information
- Completing the price calculator
- What you will learn
- Dynamically populated drop down menus
- Creating filtered Recordsets
- Revising the calculation script with live data
- Documenting your code with comments
|
- Filtering and displaying data
- What you will learn
- Preparing the input page
- Generating URLs dynamically
- Preparing the output page
- Populating page layouts dynamically
- Adding dynamic images and formatting the population number
- Looking up foreign table data with SQL
- Building descriptions
- What you will learn
- Planning the application
- Creating Eecordsets with joins
- Building the descriptions
- Inserting the images and alt attributes
- Implementing Recordset paging
- Passing data to other applications
- Building search interfaces
- What you will learn
- Preparing the search page and creating the search all link
- Searching by region: building the interfaces
- Revising the query and commenting code for testing and debugging
- Suppressing the navigation bar
- Searching by country: filtering by form variable
- Switching SQL statements according to environmental variables
- Authenticating users
- What you will learn
- User authentication as a web application
- Building the registration pages
- Building the log-in page
- Restricting access to pages
- Managing content with forms
- What you will learn
- Creating the admin section
- Two approaches to formatting content stored in a database
- Creating the form interface
- Using session variables and hidden field to track users
- Inserting the record
- Building update pages
- What you will learn
- Preparing the pages
- Planning for the master detail pages
- Making the detail page updateable
|
Course Duration
Twelve hours (9.30am to 12.30pm and 1.30pm to 4.30pm on both days)
Prices
|
