Chabot CollegeDecember 1998

Removed Fall 2006

Course Outline for Computer Science 40A

INTRODUCTION TO THE ORACLE DATABASE

Catalog Description:

40A – Introduction to the Oracle Database2 units

A survey of the features available in the Oracle database. An introduction to the use of Structured Query Language (SQL *Plus) to create, select, modify and update Oracle database records. Topics include relational database structure, data normalization, duties of the Database Administrator (DBA), Oracle Forms, Oracle Reports, the Loader, an introduction to PL/SQL, and data warehousing. Prerequisite: Computer Science 10, 14, 17 or equivalent. 1.5 hours lecture, 1.5 hours laboratory.

Prerequisite Skills:

Upon entry into this course the student is expected to:

  1. be familiar with the Microsoft Windows environment: be able to run windows applications and load/save data to diskettes and hard-drives;
  2. have a basic working knowledge of a major programming language.

Expected Outcome for Students:

Upon completion of the course, the student should:

  1. know the features available in the Oracle database;
  2. know the role of the Database Administrator (DBA);
  3. be familiar with relational database structure;
  4. know the process of data normalization;
  5. be familiar with database objects such as Tables, Views and Indexes;
  6. be able to use the basics of SQL;
  7. be familiar with SQL *Plus and PL/SQL in Oracle;
  8. know how Oracle Forms, Reports and the Loader work;
  9. be familiar with the data warehouse features of Oracle.

Course Content:

  1. The Oracle database
  2. Oracle features
  3. Relational database structure
  4. Data normalization
  5. Database objects: Tables, Views and Indexes

Chabot College

Course Outline for Computer Science 40APage 2

September 1999

Course Content: (cont'd.)

  1. Database administration
  2. The Service Manager
  3. Export and Import
  4. Backup and Recovery
  5. Database tuning
  6. Structured Query Language
  7. SQL basics
  8. SQL*Plus in Oracle
  9. PL/SQL in Oracle
  10. Oracle Forms and Reports
  11. Data warehouses
  12. Purpose
  13. Data Structure
  14. Oracle Loader

Methods of Presentation:

  1. Lecture, discussion and classroom demonstrations.
  2. Student use of appropriate computer laboratory.

Methods of Evaluating Student Progress:

  1. Exams which, according to instructor preference, may include quizzes, midterms and a required final examination. Each instructor may choose their own examination modality but is expected to test during the term. All instructors are expected to write tests which relate to the lecture/discussion/assignments//textbook being presented in the course.
  2. Students will be asked to write and implement various and multiple assigned programs and other assignments that utilize all topics included above in the course of study.
  3. Grading based upon a combination of exam scores and assignments.

Textbook(s) (Typical):

Oracle8, A Beginner’s Guide, Abbey and Corey, Oracle Press. 1998

Special Student Materials:

Computer use fee paid at the time of registration

A. Oliver

E:/CAS/CS40A.Jan00