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

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