Oracle8 Architecture

How to Create a Database

Running SQL*Plus

Running SQL*Loader

Basics of Security: Users, Passwords,
Profiles, and Roles

Views, Indexes, and Synonyms

Auditing, Backup and Recovery

Server Manager and the Initialization Parameter file

Typically Computer Science and Information Systems students are required to take a database systems class. However, there may not be time or opportunity to learn database administration within the degree program. The Personal Oracle8 tutorial will provide the individual hands on experience with the database on his or her personal computer without depending upon company training, a college class or a manual. The tutorial can also be integrated into the usual required database course as an advanced topic.

Personal Oracle8 is appropriate to database administrator instruction because its features are essentially the same as Oracle8 Universal Server. The main difference is Personal Oracle8 only allows one-user-at-a-time access, while Oracle8 Universal Server is intended for multiple simultaneous users. Therefore, the skills learned using Personal Oracle8 can be scaled up and transferred to a company environment where Oracle8 Universal Server is used. The goal of the tutorial is to offer the individual practice using database administration skills in a safe, isolated environment, where other networks and system performance are unaffected.

This tutorial builds on work completed by another student. The previously developed tutorial is web-based and focuses on Structured Query Language (SQL). SQL is the language used to interface with all databases, as well as an important language for a database administrator to utilize. Therefore, the Personal Oracle8 web-based tutorial will be an important contribution to a library of on-line database tutorials developed by students.

Trademarked names appear throughout this web site. Rather than insert the trademark symbol with each reference to the trademark, I state that I am only using the trademarks for non-profit educational purposes, to benefit the owner of the trademark, and with no intention of infringing upon that trademark.