INSTRUCTOR: Rodd Bullard

Phone – 515.202.0959

e-mail – rebullard@dmacc.edu

Web site – http://www.dmacc.edu/instructors/rebullard

DAY / TIME: Monday / 6:00 - 10:00 PM

CLASSROOM : Building 8 / Room 1

TEXTBOOK: Oracle 9i: SQL with an Introduction to PL/SQL

Lannes L. Morris-Murphy

ISBN 0-619-21284-5

PREREQUISITES: CIS303 – Introduction to Databases

COURSE DESCRIPTION:

This course is an introduction to SQL as a database programming language to those already familiar with basic relational database concepts. Students will write executable SQL statements to create and maintain database objects. Data definition (DDL), data manipulation (DML), and data control (DCL) will be covered. It uses Oracle Academic Initiative materials and is intended to help students prepare for the Oracle Certification exam (1Z0-007).

COURSE FORMAT:

Students will be expected to read the chapter(s) in their textbook prior to the discussion of them in class.

In addition to the lectures, quizzes, assignments and lab exams will be utilized to develop your database programming skills.

EVALUATION:

Assignments (12*) 10 Points/each

Quizzes (11*) 10 Points/each

Lab Skills Exams (3) 50 Points/each

* - The best 20 scores between assignments and quizzes will be used.

Due dates, quiz dates, exam dates, etc. will be posted on the Schedule. The Schedule is a link on my Web site. There are no make-up provisions for missed quizzes / exams.

GRADING:

Your total points will be divided by the maximum possible points. The resulting percentage translates to the following letter grade:

90.0% - 100%	A
80.0% - 89.9%	B
70.0% - 79.9%	C
60.0% - 69.9%	D
Below 60.0%	F

EXTRA CREDIT:

There are no opportunities to earn extra credit points at this time.

ATTENDANCE:

Attendance is expected and recommended. There is a direct correlation between good attendance and good grades.

Due to financial aid reporting requirements, attendance will be recorded at the start of class.

If you are absent from class, it is your responsibility to get class notes and announcements from other students.

Please feel no obligation to explain the reasons for your classroom absences.

CHEATING/PLAGIARISM:

Cheating constitutes academic misconduct. Please see me if you are tempted to engage in that behavior so that we can discuss other options.

SPECIAL NEEDS:

It is the policy of DMACC to accommodate students with disabilities. Any student with a documented disability who requires reasonable accommodation should contact the Special Needs Coordinator at (515) 964-6850 voice or (515) 964-6810 tty.

MISCELLANEOUS:

The use of cell phones/pagers in the classroom or lab is inappropriate. Please turn your cell phones off or set to vibrate when in the classroom. If you need to take a call, please leave the classroom.

DISCLAIMER:

This syllabus is subject to change as based on what is deemed necessary to meet the needs and particular circumstances of the class.