California State University, Chico

 

Department of Computer Science

 

 

Syllabus/Course Requirements

 

 

Fall 2004 - CSCI 379

 

 

Course Number: CSCI 379

Course Title: Enterprise DBA Part 1A: Oracle Database Architecture and Administration featuring Oracle 9i

Course Times and Locations: 

Instructor: Dr. Melody Stapleton

Instructor's Office Hours: TuTh 11 am - noon  and Wed 10-11 am and 3-5 pm in OCNL 208

Faculty Phone: (530)898-5617 , message (530)898-6442

Email: mjstapleton@csuchico.edu

Teaching Assistants (TAs):  

Textbooks: Dr. Stapleton will give you access to the 2 pdf files for this course.

Course Description: This course will cover the basic principles and techniques of Database Administration using the Oracle 9i DBMS.  We will cover all 20 lessons in the Oracle Course Manuals and complete the bulk of the lab exercises from these manuals.   We will also cover some  Oracle Network Administration Topics, and some Tuning and Recovery topics.

Course Goals: Students will understand the architecture of an Oracle DBMS and how to perform the basic duties of DBA.  Students who perform well in this course by comprehending the lectures, scoring well on quizzes and completing all laboratory exercises have a strong chance of passing the Certification Exam for Enterprise DBA- Part 1A: Architecture and Administration.

Course Notes: In Oracle Course Manuals

Web Page: www.ecst.csuchico.edu/~melody/ (take the link to the Fall 2004 course CSCI 379: Enterprise DBA Part 1A: Oracle Architecture and Administration featuring Oracle 9i materials)

Mandatory Attendance Policy for On-Campus Students:  This course is in high demand from your fellow students.  Only serious students who plan to attend each class should take this course.  Otherwise, you should drop the course and make room for other, serious students who desire to take this course.  It is mandatory that you attend both the lectures and labs for this course.  You can be dropped from the course for non-attendance.  Each unexcused absence will result in a half letter grade reduction for your overall grade for the course.  Thus, if you miss class once, you will receive at maximum a grade of "A-".  If you miss the course twice, you will receive grade, at maximum of "B+".  If you are ill, you must notify Dr. Stapleton via email right away.   If you are ill for more than one class in a row, you must provide a Doctor's excuse.  You may be excused for family emergencies.  Non-attendance due to workload in this course or other courses is not acceptable as an excuse.   A seating chart will be made and your attendance will be noted daily.  There are many more students that desire this course than can fit in the classroom, so your seat in this course is quite valuable.

Note:  Are you sure you are taking the right course?  This course assumes some maturity in database management systems in understanding good relational database design (ER and Object Modeling, normalization).  It is mandatory that you have had the equivalent of 273 as a prerequisite.  If you have not had this prerequisite, you need to drop the course and enroll in 273.  You will be required to sign an affidavit that you have taken the prerequisite.

Plagiarism/Cheating Policy:  Anyone who as determined by the Instructor/TA has copied any part of another students work will automatically receive a grade of "F" for the course.  Anyone cheating on an exam, as determined by the TA or instructor will receive a grade of "F" for the course.   Any student altering the answers on an exam after it has been graded will receive an "F" for the course.  Anyone signing the attendance sheet for a student not in the course will receive an "F" for the course.  Anyone passing information on any exam to another student will receive a grade of "F" for the course.

Course Assignments:

There will be lab exercises assigned from the Oracle Course Manuals.  Students will need to demonstrate completion of these exercises by a means to be determined by your instructor and TA.

Policy on Turning in Lab and Homework Assignments:   Due dates are firm.  No late assignments will be accepted unless serious illness or other excused absences merit allowances in the judgment of the instructor.

Grade Evaluation Procedures:  Students will be graded based on their performance in the following course components -

First Assignment: Read Lesson 1 and 2 from your Enterprise DBA- Part 1A: Architecture and Administration Course Manual.  Complete Exercise 1 of Volume 2 of your Oracle Course Manuals.