California State University, Chico
Department of Computer Science
Syllabus/Course Requirements
Spring 2005 - CSCI 276
Course Number: CSCI 276
Course Title: Advanced Databases: Oracle 10g - SQL Programming
Course Times and Locations: TR 1230PM-0145PM MLIB 031
TR 0500PM-0550PM OCNL 241
Instructor: Dr. Melody Stapleton
Teaching Assistants (TAs) :
Instructor's Office Hours: Tu Th 11-noon and Wed 3-5 pm in OCNL 208
Faculty Phone: (530) 898-5617 , message 898-6442, fax 898-5995
Instructor Email: mjstapleton@csuchico.edu
Course Prerequisite: The prerequisite/corequisite is either CSCI 273 or equivalent or experience with relational databases, including design, transactions, concurrency and SQL.
Textbooks:
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. 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 Oracle Course Manuals and complete the bulk of the lab exercises from these manuals.
Course Goals: Students are expected to become proficient at SQL programming as a result of a solid effort in this course.
Web Page: www.ecst.csuchico.edu/~melody/ look for Spring 2005 entry on CSCI 276 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 273 as a prerequisite. If you have not had this prerequisite, you need to drop the course and enroll in 273. 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 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.