Using Databases on the Web

Accelerated Technical Training

Overview

Do you have (or plan to build) a database? Do you want your users to access it with their web browsers? Are you building a new application? Need to breathe new life into a legacy application? If so, this course is for you.

Modernize your user interface! Make it accessible and easy and it will be popular and successful. The techniques presented in this course enable you to do all this without being bound to a platform (works with PCs and with Unix) or to a database (works with Oracle, Informix, Sybase, MS Access, MySQL, etc.)

This course presents tools and techniques for Perl programmers and webmasters to build CGI scripts that do lookups and updates on databases.

Duration

1 days

Courseware

Format

  • emphasis on practical skills
  • hands-on
  • instructor-led
  • classroom-based
  • printed materials
  • on-screen (web) materials

Audience

  • technical staff
  • programmers
  • webmasters
  • application developers
  • Prerequisites

    Check the ones your background satisfies:
    Basic Perl programming techniques: variables, control of flow (loops, branches), input/output, functions (subroutines)
    Writing and running scripts
    Regular expressions
    Record- and field-oriented data processing
    Use of a text editor (any editor available in the classroom is ok; Notepad on NT, vi on Unix, etc.)
    Invoking commands at the command-line prompt
    Command-line options and arguments
    Navigating the filesystem
    Basic notions of i/o in Unix and/or NT: standard in/out/error
    Creating and managing files
    Writing web pages: basic HTML
    Databases: basic SQL
    If you checked 8 or more, you're well-equipped to take this class.

    Contents

    Chapter 1: The Big Picture: Strategies for Web-Enabling Your Database

    Chapter 2: Connecting to Your Database

    Chapter 3: Handling Errors

    Chapter 4: Adding Rows to Database Tables from Web Forms

    Chapter 5: Building Dynamic Forms from Database Data

    Chapter 6: Updating Database Records from Forms

    Chapter 7: Generating Reports on Web Pages

    Chapter 8: Conclusion

    Appendix A: Common Administrative Tasks

    Objectives

    Upon completion of this course, you will be able to:

    Setup

    Delivery of this class requires:
    • classroom
    • Unix or NT
    • a PC or workstation for the instructor
    • a projector for the instructor's computer screen
    • a PC or workstation for each student
    • connection to the Internet
    • a web server (so students can create and run their own CGI programs)
    • Perl version 5.004 or newer, including the CGI extension
    • a database server (MySQL, Oracle, Access, or perhaps others) with privilege to create and destroy databases
    • ODBC (required on NT only)
    • the Perl DBD::MySQL, DBD::oracle, or DBD::ODBC module
    • the Perl DBI module
    • Detailed system configuration instructions are available at http://www.keller.com/curric/dbweb-setup.html
    • We can assist with the classroom setup.
    Write to us! webmaster@keller.com
    http://www.dan-keller.com/training/curric/xml-versions/dbweb.html
    Updated Wednesday, 31-Oct-2001 13:18:40 MST

    Copyright © DKTS
    Dan Keller Technical Services
    4500 19th St., San Francisco
    California, USA 94114
    voice: 415 / 861-4500