Department of Computer Science
Syllabus/Course Requirements
CSCI 679
Oracle 10g - Database Administration Workshop II (including advanced backup and recovery, performance tuning and multilingual configuration)
Course Number: CSCI 679
Course Title: Oracle 10g - Database Administration Workshop I-
architecture, networking and intro to backup and recovery
Course Times and Locations:
- TuTh
5 - 6:15 pm - Lecture in OCNL 340
- TuTh
6:15 - 7:15pm - Lab in OCNL 340
Instructor:
Dr. Melody Stapleton
Instructor's Office Hours: TuTh 2:4:30 pm in OCNL 208
Faculty Phone: (530)898-5617, message (530)898-6442
Email: mjstapleton@csuchico.edu
Teaching Assistants (TA):
· Aaron Thomas with email address ferdinaaron@gmail.com
Textbooks: Dr. Stapleton will provide the
course manuals.
- Mandatory
Text: Oracle Course Manuals for Oracle 10g - DBA Workshop II
Course Description: Oracle DBAs manage the industry's most advanced information systems and command some of the highest salaries. This course is a valuable step towards success as an Oracle professional. The course will begin with a review of the basic Oracle Architecture. In this class, you'll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional 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 advanced backup and recovery with a variety of tools. They will also understand how to tune the performance of an Oracle 10g database and configure the database for multilingual applications. 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 OCP Certification Exam for Oracle 10g - DBA Workshop II
Course Notes: In Oracle Course Manuals
Web Page: www.ecst.csuchico.edu/~melody/ (take the link to the Spring 2008 course CSCI 679: Oracle 10g - DBA Workshop II)
Course Requirements: Regular attendance at BOTH the labs and lectures
is absolutely necessary to succeed in this course. Attendance is mandatory and will be taken at
both the lecture and the lab and your grade will be docked by one letter grade
for every 3 unexcused absences. If you
are going to be absent, email Dr. Stapleton in advance. Only illness or other serious criteria will
be excused absences. Being too busy with
workload or trying to meet a deadline in this or another course is an example
of an unexcused absence. You must learn
to balance your workload to succeed in this class.
Plagiarism/Cheating
Policy: Due to recent incidents I have developed a “NO TOLERANCE” policy
towards any form of academic dishonesty, plagiarism or cheating. Programming assignments and homework
assignments are to be an *individual* effort. 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 will receive a grade of "F" for the course.
Anyone who alters their exam answers after receiving the exam back will receive
a grade of "F" for the course. Anyone who submits work that is not
their own work and does not fully credit their source will receive a grade of
“F” for the course. Anyone who cheats in
this course will be reported to Student Judicial Affairs with the goal of
removal from this University and will not be accepted in any of my courses from
that point on.
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 -
- Lab Exercises/Assignments/Attendance(on-campus) 20%
- Pop Quizzes 20%
- Midterm Exam
25%
- Final
Quiz 35%
First Assignment: Read the Introduction and Lesson 1 and 2 from your Oracle
10g - DBA Workshop II Course Manual.