1. Perl setup:

  This course requires:
    Perl 5.005+
    Several Perl Modules that may not be installed by default.

  Run:

    sh checkmods.sh

  This will check the Perl version, and for the existence of various
  modules.  If a module isn't found, install it before starting class.
  Note that you need only the DBD module for the DBMS you will use for
  class.  For example, if you will use MySQL for the DBI/DBD chapter
  examples and exercises, then you need the DBD::mysql installed, but
  not DBD::Oracle.

2. RDBMS setup:

  The DBI/DBD chapters require that a Relational Database Management System
  (RDBMS) be installed and set up for student use.  Possible solutions
  include Oracle or MySQL.  Oracle is widely used.  MySQL is a standard
  option on Linux.  Only one is required for class.
  
  Oracle setup:
  - Each student needs an Oracle account, with the sample tables loaded.
    The accompanying script, create_oracle_user.sql, contains the syntax
    to create the account.  The script will DROP and then CREATE the Oracle
    account.  The script must be run by the Oracle SYSTEM (or other DBA)
    account.  You must pass the student account name on the command line:

    sqlplus sys/syspassword as sysdba @create_oracle_user.sql ADVPRL
    sqlplus sys/syspassword as sysdba @create_oracle_user.sql STUDENT1
    sqlplus sys/syspassword as sysdba @create_oracle_user.sql STUDENT2
    ...

  - To load the data, connect to Oracle as the student account, and run
    the provided load script for oracle, emps.oracle.sql:

    sqlplus advprl/advprl @emps.oracle

  - The accompanying script, adduser.oracle.sh, performs the steps above
    to create a new account:

    sh adduser.oracle.sh advprl

  MySQL setup:

  - If each student is working on their own individual Linux host, then
    they can each use the 'test' database that comes with mysql.

    1. Make sure mysql is running.  As root:
       chkconfig mysqld on
       /etc/init.d/mysqld start
       exit

    2. Load the data.  As the student Linux login:

       mysql test < emps.mysql.sql

