California State University, Chico
Department of Computer Science
Syllabus/Course Requirements
Fall 2006 - CSCI 679
Course Number: CSCI 679
Course Title: Oracle 10g - Database Administration Workshop I - architecture, networking and intro to backup and recovery
Course Times and Locations:
Instructor: Dr. Melody Stapleton
Instructor's Office Hours: TuTh 2 - 3 pm and Wed 1 - 2 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 provide the course manuals.
Course Description: Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This course is a first step towards success as an Oracle professional, designed to give a firm foundation in basic database administration. In this class, students learn how to install Oracle components as well as create and maintain an Oracle database. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Powerful new Oracle tools are featured throughout the course. The lesson topics are reinforced with structured hands-on practices. This course is made possible via the Oracle Academic Initiative – a partnership between higher education and Oracle Corporation - and is designed to prepare the student for the corresponding Oracle Certified Associate exam. If you are unsure if you meet the prerequisite for the course, please contact Dr. Stapleton at mjstapleton@csuchico.edu.
Course Goals: Students will understand the architecture of an Oracle 10g 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 Oracle 10g - DBA Workshop I
Course Notes: In Oracle Course Manuals
Web Page: www.ecst.csuchico.edu/~melody/ (take the link to the Fall 2006 course CSCI 679: Oracle 10g - DBA Workshop I )
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 470 as a prerequisite. If you have not had this prerequisite, you need to drop the course and enroll in 470. 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 the Introduction and Lesson 1 and 2 from your Oracle 10g - DBA Workshop I Course Manual. Complete Exercise 1 of your Oracle Course Manuals.