CS276                                                     MONTGOMERY COLLEGE                              Spring 2006

Computer Science, Rockville

Advanced Oracle Using Java

 

SYLLABUS

 

36232  

CS 

276 

400 

3.00  

ADV ORACLE PROG/JAVA

Rockville 

 

Jan 23, 2006 

May 21, 2006 

W

06:30 pm - 09:10 pm 

HU 

325 

 

Instructor(s): Grigoriy A. Grinberg 

 

Phone: (240) 567-7161          email: grigoriy.grinberg@montgomerycollege.edu

Office MT 408

Office Hours by appointment:           Monday  5:20pm –6:20pm

                                                                Wednesday 5:20pm –6:20pm

                                                                 Wednesday 9:10pm – 10:10pm

                                               

 

I.                    General Course Information:

Course Title:  Advanced Oracle                                 Credit Hours: 3


Prerequisite:  CS271 and Java programming language.

 

II.        MC Catalog Course Description:  Covers the design and development of advanced programs using joins and subqueries to update a created Oracle database.  Backup and recovery techniques will be covered, including data integrity techniques.  Building database-enabled Web applications for the Internet using Java.

 

This course emphasizes the development of Oracle database applications using Java and JDBC.  Will include how to create and deploy Web and database applications using Oracle Jdeveloper.

3 semester hours

 

Specific Outcomes

 

Upon completion of this course, students will be able to:

 

  • Implement database access from Java
    • Java Stored Procedures
    • JDBC Programming
    • Basic SQLJ Programming
  • Building reusable components
    • JavaBeans  and using it with Oracle
    • Using Enterprise JavaBeans
    • Using Business Components for Java (BC4J)
  • Deploy Java in a Web environment
    • Covers the technologies for employing Java in a Web environment to produce dynamic Web Content with Java. Specifically Java servlets and Java Server Pages(JSP)

 

Teaching Methodologies

Instruction in CS276 is via lecture, discussion with major enhancement from visual aids, and programming assignments.  Oracle is available for use in the classroom.

 

 

V.        Texts [and Supplies]

Oracle 9i JDeveloper  Handbook

            ISBN:  00722223847

 

Oracle9i JDBC Programming

            ISBN: 0-07-222254-9

             

Oracle and Java Development

            Bulusu Lakshman

            ISBN:  0672321173

 

VI.       Lab Facilities/Media Resources:  JDeveloper and Oracle 9i are available for use                   in the classroom and some labs.

 

VII.     Grading

            Students are evaluated using a combination of tests and programming

            assignments:

            MidTerm Exam: 25%

            Final Exam:        25%

            Projects:              50%           

 

  Course Grade

     A = 90 - 100                       B = 80 - 89                  C = 70 - 79

                 D = 60 -   69                       F = <60

   

Make-up Policy - Will be dealt with on an individual basis.  Serious illnesses will be considered when accompanied by a doctor's note.  Every effort should be made to contact the instructor prior to absence when a test is scheduled to be given. 

 

Late Policy - Students are expected to arrive in class on time.  Excessive lateness may result in unexcused absence.

 

Audit Policy - (As recorded in Student Handbook)

            Instructor approval is required to enroll in a class for audit.  Students may register  

for credit and change to audit during the first week of class without paying a $10.00 change of schedule fee.  The last day a student may officially change course enrollment from credit to audit is equivalent to 20 percent of the total duration of the course.  A change of schedule form is used if the instructor's signature is obtained after the initial

 registration.

               

VI.       Classroom Policies

 

A.                 Attendance (and Withdrawal from Class) See Student Handbook.

Students are expected to attend all class sessions. Attendance sheets must be signed during every class session.  Students are expected to be signed in and be in their seats when class begins. Please call or email your instructor if you are going to be late or absent.

  In the case of absence, it is the students’ responsibility to confer with the instructor about whether the absence is excusable and to make up the work.  When a student's absences have exceeded the number of class sessions per week or a number specified by the instructor, the instructor may drop the student from the class following an additional absence or may assign the grade of "F" for the course.

 

             Academic Honesty (The following examples of academic dishonesty are strictly

                                                prohibited.)

·        Cheating on examinations: copying another's work or allowing your work to be copied; using unauthorized notes; taking another's exam or having another person take your exam.           

·        Plagiarism:  Presenting the work of another as your own in a paper, exam, or other assignment.  Explicit acknowledgment (meaning footnotes or endnotes) must be given for the use of another person's ideas or language.  Be sure to ask the instructor if there is a question about how to acknowledge sources properly.  A student cannot be too careful where plagiarism is concerned.

·        Other forms:  Several forms of dishonesty are specified in the Code of Conduct, including selling or purchasing exams, papers, or other assignments, and submitting or resubmitting the same paper for two different classes, without explicit authorization (As recorded in Student Handbook 2000-2002).

 

Classroom Conduct

The classroom is a place for learning.  Students are to behave in the appropriate manner demonstrating respect and attention to the instructor.  "If a student behaves disruptively       in the classroom after the instructor has explained the unacceptability of such conduct and the consequences that will result, the student may be asked to leave the room for the remainder of the class time."  (See Student Handbook under the heading “Classroom Behavior" for additional information.)

 

Please turn your cell phone and beepers to vibrate (or stun).

                 

Workstations are for use only for work required by this course. The playing of games or music is prohibited.  Use of e-mail and/or chat for any purpose other than course requirements is prohibited. 

 

Support Services

Computer Labs are available in the Humanities (3rd floor) and Computer Science (lower level) buildings.  Dates and times of Lab hours are posted on the Computer Science Department Web site and in both Lab locations for your convenience.

            Tutoring is also available.

 

           

Disability Support

·        Any student who may need an accommodation due to a disability, please make an

appointment to see me during my office hour.

·        A letter from Disability Support Services (R-CB122; G-SA175; or TP-ST120) authorizing your accommodations will be needed.

·        Any student who may need assistance in the event of an emergency evacuation must identify to the Disability Support Services Office;

·         Guidelines for emergency evacuations for individuals with disabilities are found at: www.montgomerycollege.edu/dss/tbl-cnt.htm. 

 

           

            Cancellation of Classes

 

As recorded in the Montgomery College Catalog, "If inclement weather forces the College or any campus or College facility to suspend classes or close, public service announcements will be provided to local radio and television stations as early as possible.  If you have checked several stations and have not heard an announcement," you may go to our Web site for closing information or call the College.

 

Emergency Evacuations

The Montgomery College Office of Safety and Security is committed to protecting the lives and health of the members of the College community. To this end, an “Emergency Response System” was developed and implemented to address emergency situations that may occur on each of the College’s three campuses, as well as its off-campus locations.  In the event of an emergency that may require an evacuation of a building or buildings, it is imperative that all members of the College community familiarize themselves with the location of exits within each of the buildings they may happen to be in during the course of any given day.  If a building is evacuated, members of the College community should proceed to an “Emergency Evacuation Assembly Area.”  The location of “Emergency Evacuation Assembly Areas” for each building are posted conspicuously beside all exits and other high-travel areas; please take just a few moments to read and note the location of the “Emergency Evacuation Assembly Area(s) for the building(s) which you may be in.  If you have any questions regarding the location of “Emergency Evacuation Assembly Areas” on this campus, or any other College location, contact the Campus Office of Safety and Security, or the Site Emergency Coordinator/Building Manager at an off-campus location.

 

 

 

Important dates

 

January 23

Classes begin.*

January 28

Assistance for Saturday students. Admissions and Records offices will be open various morning hours.

January 29

Last date to drop most classes with a refund. (based on 6 percent of scheduled class meetings.) Refund deadline information for individual classes is available in two places: online via MyMC, Quick-Links - Students, Register for Classes, View Drop Deadline Dates; or on the print Student Schedule/Bill available at Admissions and Records Office. Students who drop a class after the deadline will not receive a refund. Students who add a class after the deadline will be responsible for the additional tuition and fees. ** ^

January 30

Last day to register for classes that can be covered by a Pell Grant.

January 30

Change of Schedule fee begins; $10 fee

February 

February 2

Registration payment is due by this date in order to avoid a $50 Late Payment Fee.

February 3

$50 Late Payment Fee charged for registration not paid by this date.

February 12

Last date to drop most classes without a grade or change from credit to audit or audit to credit. Audit to credit and credit to audit changes require instructor’s signed approval. (Based on 20% of the total number of scheduled class meetings.) ** ^

March 

March 13-19

Midterm Exams.

March  20-26

Spring recess for students and faculty.
Most offices will close at 5 p.m. each day.

March 23-24

Spring break; College closed.

March 28

Midterm grades are due from faculty.

April  

April 1

To assure evaluation prior to the start of the summer sessions, official transcripts must be received in the Admissions, Records, and Registration Office by this date.

April 1

Last date to apply for summer graduation.

April 16

Last date to drop most classes with a grade of W. (Based on 73% of the total number of scheduled class meetings.) ** ^

May  

May  8-14

Final exams. Grades will be available online.

May 16

Final grades are due from faculty. (Graduates’ grades are due earlier.)