Instructor Rahul Tikekar, http://www.sou.edu/cs/tikekar
Office CSC 222
Telephone 552-6975
Email TikekarR@sou.edu
Class Homepage http://www.sou.edu/cs/tikekar/CS462Winter08
Text Thomas Kyte
Expert Oracle Database Architecture: 9i and 10g Programming Techniques
and Solutions
APress
Prerequisites CS460 (Advanced Databases) or equivalent. This is a course that looks
exclusively at Oracle. Hence under exceptional circumstances, I can admit
people who have not taken CS460 but have very good experience with using Oracle.
Objectives This course is aimed at two
sets of people: those who wish to become Oracle DBAs,
and those who wish to prepare for the Oracle Certification exams. Oracle DBMS
is a complex software having a large share of the database industry. This class
is designed
·
To understand the fundamental concepts behind this software and to
study how Oracle works and manages data and files (theory)
·
To understand how to manage an Oracle database via hands-on exercises
(practice)
·
To use the DBA tools that it provides (tools)
Grading Assignments and Labs (25%):
lab work or research
Project
(15%): Details made available later
Quizzes
(30%): 3 quizzes
Quiz
1: Week 4 (Friday Feb 1)
Quiz
2: Week 6 (Friday Feb 15)
Quiz
3: Week 8 (Friday Feb 29)
Final
(30%): cumulative
Friday
March 21, 10:00 – 12:00 Noon
Late Work Late work will lose 1 point per day.
Other Visit the class homepage
regularly for informative links, extra copies of handouts, etc.
Unless otherwise stated all
assignments should be the result of individual effort.
Cheating on
any component of this course is not acceptable. The penalty can range from a
failing grade for the component to a failing grade for the course.
Attendance
is not mandatory. However, it is the student’s responsibility to find out and
understand the subject matter that was covered during an absence.
Graduate
students can expect to be graded more critically than undergrads. They will
also be assigned additional work.
Do not
submit work via email.
No late work
will be accepted after the final.
Week 1: Review Oracle; Installation (Notes)
Week 2: Oracle Instance and Processes
(Ch 1, 2, 4, 5)
Week 3: Tools; Creating and Managing an Instance and
Database (Ch 2, Notes)
Week 4: Data Dictionary, Standard Packages and SQL*Net (Notes)
Week 5: Control Files and Redo Log Files (Ch 3)
Week 6: Managing Tablespaces
and Data Files (Ch 3)
Week 7: Storage Structures and Relationships (Ch 3,
Notes)
Week 8: Managing Users (Notes)
Week 9: Rollback Segments (Ch 9)
Week 10: Other topics as needed and project
presentation
Assignment
Grading Criteria
All assignments are worth 5 points. Here is a table that describes the grading criteria.
|
6 |
Exceptional work; above and beyond call of duty. |
|
5 |
Everything described perfectly; Works great; Exemplary effort, including documentation. |
|
4 |
Described well but contains minor mistake(s) or at most half the requirements of assignment are not met. |
|
3 |
Described well but contains major mistake(s) or at least half the requirements of assignment are not met. |
|
2 |
What was turned in does not work well and all requirements of assignment are not met. |
|
1 |
Sloppy work; only ‘some’ effort was demonstrated. |
|
0 |
Not turned in or only token effort expended; plagiarized work. |
If you are
in need of support because of a documented disability (whether it be learning,
mobility, psychiatric, health-related, or sensory) you may be eligible for
academic or other accommodations through Disability Services for Students.
Contact
Director DSS by calling 541-552-6213; or schedule an appointment in person at
the
For Detailed Information: www.SOU.edu/Access/Dss