cpt260syll

St. Charles Community College
CPT 260 Oracle Programming Mrs. Heckel
Tech 105 A	sheckel@stchas.edu	636.922.8568
www.stchas.edu/faculty/sheckel

General Course Information

CATALOG DESCRIPTION: This course provides In-depth coverage of Oracle's current Programming Language/Structured Query Language (PL/SQL), bringing all benefits and capabilities of a high-level programming language to the database environment.

Credit Hours: 3

Text: (required) Morrison, Morrison & Conrad

Guide to Oracle 10g
Course Technology, Boston, MA; 2006

Time of Class: Spring 2008 Sec. 80 Thursday 7:00-9:50 pm

Course Objectives:

recognize basic relational database design
build PL/SQL programs in the Oracle database environment
generate forms and reports in the Oracle database environment
integrate a database with an application program

Students with special needs:

We all have various channels through which we learn best. SCC has an Office of Accessibility Services that guides, counsels, and assists students with disabilities. It is located in Room 133 of the Student Center. It is your responsibility (as the student) to discuss with the instructor during the first week of class anything needed to help you succeed. If you have special needs, please call Pam Bova (636.922.8247) in the Office of Accessibility Services so that your eligibility for services can be determined.

SCC also offers mental health counseling. If you need help with depression, anger, domestic violence, stress, addiction, eating disorder, or anxiety, please contact Mary Hall at 636.288.6533. Her office is located at ADM 1204.

What the teacher expects from each student

Attendance Policy: Each student is expected to attend all classes. The fact that some of the course includes hands-on activity makes attendance at class even more important. If absence is unavoidable, the student is expected to have the textbook material read and any class assignments completed before returning to the next schedule class. Failure to do this will cause the inability to keep up with the class material being discussed.

DO NOT call or e-mail the teacher to find out what we covered in a class that you missed. This information should be obtained from the course timetable and/or a classmate.

Course Requirements

Read the text as assigned before the class time table (at end of syllabus)
Complete and turn in on time all assignments
Attend lectures and participate in class discussion.
Bring to each class;

a writing instrument, preferably a pencil
paper for notes
your textbook

What the student can expect from the teacher

Office Hours:

Tuesday/Thursday 11:30-1:00 pm
Thursday 4:00-7:00 pm

Also available by appointment

Returning assignments/tests to the student: Every effort will be made for all assignments to be returned to all students within one week of the test date or assignment’s due date.

Grading Scale:

A	93-100	Homework	30%
B	85-92	Exams *	30%
C	75-84	In-class Assignments*	30%
D	65-74	Final Exam	10%
F	below 65%

*the lowest grade will not be calculated

All written work

Worksheets / Individual and Group Exercises

Homework

Homework will be the 10 Multiple Choice Questions at the back of each chapter (chapters 3-9 have Parts A, B, and some C, each with its own Multiple Choice Questions....be sure to do them ALL), and will be due the week after we start to cover the chapter. You will lose 5 points for each class that the homework is late.

Exams

Most weeks, the class will begin with an objective exam (true/false, multiple choice) on the previous week's topics. These exams cannot be made up, but missing one will not affect your grade (because the lowest grade is thrown out anyway).

In-Class Assignments

Most weeks will include a hands-on assignment using Oracle. These assignments cannot be made up, but missing one will not affect your grade (because the lowest grade is thrown out anyway).

Final Exam

The Final Exam will be partially objective (true/false, multiple choice) and partially hands-on.

Withdrawal dates and related policies

Last day to change from credit to audit or audit to credit	Feb 15
Last day to drop and receive a "W"	Apr 4
Last day to apply for August 2008 graduation	Jun 13

Tentative Time Table

Wed	Chapter	Topic	Test
1/24	Introduction to the Course
1/31	1	Client/Server Databases
2/7	1
2/14	2	Creating and Modifying Database Tables	1
2/21	3	Using SQL to Insert, Update, Delete and View Data	2
2/28	4	PL/SQL	3
3/6	4
3/13		catch-up day
3/20	No Classes--Spring Break
3/27	5	Forms Builder	4
4/3	6	Custom Forms	5
4/10	7	Database Reports	6
4/17	8	Integrated Database Application	7
4/24	9	Advanced SQL and PL/SQL Topics	8
5/1	10	Advanced Forms Builder Topics	9
5/8	11	Oracle Database Administration	10
5/15	Final Exam: 7:00-9:00 pm