Syllabus for CIS50

Oracle and SQL - CIS50

Professor: Priscilla Grocer

Office: K-112

Course Description (from catalog):

This course is an introduction to the Oracle database. The student will learn to work with Oracle and the structured query language SQL as they design, manipulate and access the database. In addition, the concepts and design of relational databases will be analyzed and implemented.

Course Objectives:

The primary objective of this course is to teach the student to work with Oracle both in the development of the database and the use of SQL and PL/SQL. At the completion of this course, the following objectives should have been accomplished:

To understand the concepts and design of a relational database
To understand the concepts of object orientation of a relational database management system
Given a set of data and an analysis of the needs, to design a normalized relational database to handle the data
To understand and learn how to work with an Oracle database
To understand the structured query language SQL and be able to use it in conjunction with Oracle database
To understand Procedural Language SQL (PL/SQL) as implement by Oracle and be able to use it in conjunction with an Oracle database

Texts: There is no required text for this course. The course notes are available at the course Web site. If the student wants Oracle software for use on a home computer I would suggest downloading from education.oracle.com -they have version 8i available. In the past, the following book has included software, but I am not sure it still does.

Modern Database Management fifth edition
McFadden, Hoffer, and Prescott
Addison-Wesley, 1999
ISBN 0-8053-605409
Remember that you can use version 7.3, 8 or 8i.

Material to be Covered: The order in the syllabus does not necessary reflect the order that will used in the course. Please use the weekly schedule sheet to follow the assigned topics.

Introduction/concepts
1. Relational database
2. Normalization
3. Entity Relationship model
4. Object orientation
5. Introduction to Oracle
6. Introduction to SQL
SQL statements in Oracle
1. Basic SQL statements
  1. Selecting
  2. Arithmetic expressions
  3. Concatenating
2. Introduction to SQL
3. Limiting and Sorting data
4. Functions
5. Using multiple tables
6. Grouping functions
7. Simple subqueries
8. Multiple column subqueries
Additional features
1. Output
2. Updating - add, changes and deletions
3. Manipulating data
4. Creating and maintaining tables
5. Keys
6. Views
7. Database objects and indexing
More advanced features of Oracle and SQL
1. Controlling access
2. PL/SQL structure
3. Variables
4. Writing executable code
5. SQL and PL/SQL
6. Control structures
  1. If
  2. For loop
  3. While loop
7. Composite data types
8. Working with cursors
9. Exceptions
10. Procedures and functions

Requirements:

Requirements and Grading: The student will be expected to complete all assigned work. In addition there will be a final exam.
A schedule of assignments, projects, exams, quizzes etc. will be posted on the Web site. Students should check on a regular basis.
Grading percents are:

80% Homework, programs, code and quizzes
10% Class participation, responsibility about work, keeping up to date, quality of work, adding extras that are above and beyond, showing initiative, figuring out problems etc.
10% Final

Evaluation:Assignments, programs and exams are graded using either number grades or letter grades based on the following (A=90-100, B=80-89, C=70-79, D=60-69, F=below 60). The student's grade for the course will use the same scale and will be based on the percentages explained in the grading section. Plus and minus grades will be given.
Many of the assignments in this class are open ended - the grading will be based on how well the project demonstrates mastery of the material. Students who do a minimum of work will be graded accordingly. Resubmission is allowed on open-ended projects to improve grades.
Note: Non open-ended assignments that are completed accurately, with no errors, according to the parameters of the assignment will be graded as A. To achieve an A+, students must have done sufficient extra work in design or implementation that makes the assignment standout. In doing assignments, students must do their own work. Relying too heavily on my examples or working too closely with someone else will be penalized.

Attendance:The student is allowed to cut six one hour classes.

Methodology: This course is offered as an in-class course or as a Distance Learning, Web based course. For in-class students, it is a traditional lecture based class with supplementary information available on the Web. Web based students will be relying on the information at the Web site for the information being presented in class. Web based students are invited to attend class at any time if they feel that hearing a lecture would be valuable. All students should read the assigned notes, study the presentations available and avail themselves of other resources in mastering the course material. In addition, students will be working independently on projects designed to give them additional computer skills and practical experience in analyzing and solving problems. When appropriate, exercises and problem solving techniques are used.
This SYLLABUS is not to be construed as a CONTRACT in any way, shape, manner or form. This SYLLABUS is a SUGGESTED course OUTLINE and will be GENERALLY followed, subject to change according to the INSTRUCTOR'S discretion and needs. Academic FLEXIBILITY is important!

Back to the Top
Return to home page
Return to previous page - CIS50