Department of Computer Science
Syllabus/Course Requirements
Fall 2007 - CSCI 679-DBA Workshop I
Course Number: CSCI 679
Course Title: Oracle 10g - Database Administration Workshop I -
architecture, networking and intro to backup and recovery
Course Times and Locations:
- Wednesday
4 - 6 pm - Lecture in OCNL 340
- Wednesday
7 – 7:30 pm - Lab in OCNL 340 ,
more lab hours to be added….
Instructor:
Dr. Melody Stapleton
Instructor's Office Hours: TuTh 11- noon and 2 - 3 pm and Wed 3 - 4 pm in OCNL 208
Faculty Phone: (530)898-5617, message (530)898-6442
Email: mjstapleton@csuchico.edu
Teaching Assistants (TAs):
· Ishwari Athanikar with email address dba1.fall2007@gmail.com
Textbooks: Dr. Stapleton will provide the
course manuals.
- Mandatory
Text: Oracle Course Manuals for Oracle 10g - DBA Workshop I
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 2007 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 or 570 as a prerequisite. If you have not had this
prerequisite, you need to drop the course and enroll in 470 or 570. You
will be required to sign an affidavit that you have taken the prerequisite.
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
20%
- Final
Quiz 35%
First Assignment: Read the Introduction and Lesson 1 and 2 from your Oracle
10g - DBA Workshop I Course Manual.