Training

Dreamweaver UltraDev
Drumbeat 2000
Foxfire!
Training Overview

 

  

 

 


Introduction to Database Concepts for Web Site Developers

 

Introduction and Overview

  • What is a database?
  • What does "relational" mean?
  • What are tables, columns and rows?
  • How are databases designed?
  • What are keys, and how are they used?
  • What is "normalization"?
  • What kinds of relationships are there?
  • What are joins?
  • What are views?
  • What are look-up tables?
  • What are ASP and ADO?
  • What is ODBC?
  • How does one use ASP/ADO?

Build a database

  • Describe the business process
  • Identify the principal entities
  • Identify each entity's important attributes
  • Find each entity's primary key
  • Specify relationships among entities
  • Specify look-up entities
  • Chart the relationships in an ERD
  • Specify views
  • Specify business rules
  • Specify the physical database
  • Generate the database

Enterprise Databases

  • What is a client/server database?
  • What is 3-tier architecture?
  • What is n-tier architecture?
  • What are the most important enterprise issues?
  • How do we address these issues?
  • What is a DBA, and why does he hate me?
  • What is an object-relational database?
  • How is database performance tuned?

Communicating Effectively

  • What is SQL?
  • How is SQL supplemented?
  • What are database procedural languages?
  • What are stored procedures?
  • What are triggers?
  • How and why do we use stored procedures?
  • What is an API, and where does it come from?
  • What are indexes, and how are they used?
  • What is the execution plan?
  • How can it be managed?
  • What is optimization?

Conclusion

|Back to Class Description| |Calendar|

 

Mastering Drumbeat 2000 Fundamentals

 

Navigating the Drumbeat Interface

  • Understanding the components of the Drumbeat interface.
  • Describing the functions of the elements within the interface.

Pages, Templates and SmartElements

  • Using Asset Center to manage Media for your site.
  • Bringing Media into your Workspace.
  • Filtering Media.
  • Building a Home Page.
  • Previewing your site.
  • Modifying Attributes of SmartElements.
  • Setting up SmartElement
  • Point & Click Activations and Interactions.
  • Publishing and Browsing.
  • Establishing Hyperlinks between pages.
  • Creating Design Templates.
  • Creating and Using Styles.
  • Building the Browser List.

Framesets

  • Creating a Frameset.
  • Inserting a Page under a Frameset.
  • Creating Links between Frames.

Using Content Tables and Pagesets

  • Creating and Populating a Manual Content Table.
  • Setting Row and Column Properties.
  • Using Text in a Content Table.
  • Using Assets from a Content Table.
  • Creating a SmartElement Library Collection.
  • Editing a Content Table.
  • Referencing External Text files from a Content Table.
  • Creating CSV Content Tables.
  • Creating a Pageset from a Content Table.
  • Designing the Pageset Layout.
  • Adding a Column to the CSV Table and inserting it into the Pageset.
  • Replacing the Form Buttons.
  • Linking to Pagesets.

Creating Active Server Pages

  • Setting Up for Active Server Pages.
  • Creating a Web Directory.
  • Creating a Data Source Name (DSN).
  • Setting up Drumbeat for ASP.
  • Creating a Query.
  • Using DataForm Wizard.
  • Designing with DataForms.
  • Adding Links to Dataform Pages.
  • Customizing DataForm Pages.
  • Adding Radio Buttons to Update/Insert Pages.
  • Setting up the Tab Order.
  • Importing a New Contracts.

Review of Workshop II Starting Point

  • Setup your computer to create an ASP-based web site
  • Use a Starting Point
  • Use an existing database in Drumbeat application

Customizing Search Options

  • Run the DFW to search multiple fields
  • Constrain the search by allowing user choice of the search field
  • Provide a drop-down list of keywords to search
  • Allow user choice of search method
  • Handling exceptions with a redirect page

Using Multiple DataForm Objects

  • Create two different DataForm Recordsets.
  • Make the Results List of the second DataForm appear on the Detail page of the first.
  • Add interaction to filter data from one DataForm with related data from another DataForm

Add, Delete, and Modify

  • Create a new Data Form that will allow users to manipulate the database.
  • Set up pages to handle the three primary database manipulation functions: Adding Records, Deleting Records, and Revising Record.

Building Shopping Carts and Order Forms

  • Add an order handling and transaction component to your site.
  • Store the user's orders in a Shopping Cart.
  • Create a check-out page that will insert the orders into your database.
  • Generate a COM based email via ASP when order is submitted.

Password Controls and Random Images

  • Create a username/password control page.
  • Add password control to pages.
  • Create a random generation of special offers from the database
|Back to Class Description| |Calendar|