California State University, Chico
Department of Computer Science

Syllabus/Course Requirements

Fall 2006 - CSCI 570

Course Number: CSCI 570 (replaces old course number CSCI 276)

Course Title: Advanced Databases: Oracle 10g - SQL and PL/SQL  Programming

Course Times and Locations:    

• Lecture     Wednesday 11- noon in OCNL 241
• Lecture      Thursday 11- 12:15 pm in Ocnl 239
• Lab           Monday  11 - noon in  OCNL 241

Instructor: Dr. Melody Stapleton

Teaching Assistants (TAs) :  

• Mrunal Shah with email mrunalhshah@gmail.com

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 898-6442, fax 898-5995

Instructor Email: mjstapleton@csuchico.edu or melodystapleton@digitalpath.net if you need to send large files or attachments.

Course Prerequisite: The prerequisite/corequisite is either CSCI 470 (formerly CSCI 273) or equivalent or experience with relational databases, including design, transactions, concurrency and SQL.

Textbooks:

• Mandatory Texts: Oracle Course Manuals for "Oracle 10g - Introduction to SQL Programming as well as the course manuals for PL/SQL Programming"
• List of Oracle Course Manuals and printing costs:
  • 10g SQL Fun 1 student guide vol 1    $14.08
  • 10g SQL Fun 1 student guide vol 2    $9.33
  • 10g SQL Fun 1 student guide vol 3    $2.41
  • 10g SQL fundamentals II vol 1           $14.32
  • 10g SQL fundamentals II additional practices    $1.05 (if ordered with another manual)
  • PL SQL Fundamentals vol 1        $15.05
  • PL SQL Fundamentals vol 2        $1.35  (if ordered with another manual)
  • Develop PL SQL Program Units vol 1    $15.44
  • Develop PL SQL Program Units vol 2    $8.85
  • Prices quoted are for back to back copies.  Materials will be collated, stapled, and hole punched (3 holes)
  • All of the manuals can be purchased at University Printing Services located in Siskiyou Hall, Room 118 Click here for the campus map
• Optional Texts: There are many good Oracle SQL and PL/SQL Programming books available from Oracle Press and other publishers  

Course Description :This course introduces Oracle Database 10g technology and relational database concepts and the powerful SQL programming language. The course covers the essential SQL skills of querying the database and the meta-data in the data dictionary along with creating database objects.  In addition, the course also delves into advanced querying as well as reporting techniques, data warehousing concepts and manipulating large data sets in different time zones. Students will learn how to search for data using advanced correlated sub-queries and employ SQL functions to generate and retrieve customized data.  Students will run data manipulation statements (DML) to update data in the Oracle Database 10g.  They will also learn to control user access and manage schema objects.  PL/SQL, Oracle's proprietary procedural programming language, will also be covered.  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.  We will cover all 23 lessons in the SQL Oracle Course Manuals and many of the lessons in the PL/SQL manuals and complete the bulk of the lab exercises from these manuals.

Course Goals: Students are expected to become proficient at SQL programming and introductory PL/SQL programming as a result of a solid effort in this course.

Web Page: www.ecst.csuchico.edu/~melody/  look for Fall 2006 entry on CSCI 570 and go to course home page.

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 570 (formerly 273) as a prerequisite.  If you have not had this prerequisite, you need to drop the course and enroll in 570.  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.  In all cases, you must notify the instructor prior to the actual absence from class via email.

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

• Lab Exercises/Assignments/Attendance(on-campus)         40%
• Midterm Exam                                                                     25%
• Final Exam                                                                           35%

First Assignment: Read Lesson 1 and 2 from your Oracle 10g: Introduction to SQL Programming Course Manual, Volume 1.  Complete Exercise 1 of your Course Manual with the due date as given by the instructor.