CS271                                                     MONTGOMERY COLLEGE                              Summer 2004

Computer Science, Rockville

Oracle Programming

 

SYLLABUS

 

12621  

CS 

271 

400 

3.00  

ORACLE PROGRAMMING 

Rockville 

 

Jul 13, 2004 

Aug 12, 2004 

TR 

06:00 pm - 09:55 pm 

HU 

319 

 

Instructor(s): Grigoriy A. Grinberg 

 

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

 

Office Hours by appointment:           Tuesday  5:10pm –6:00pm

                                                               

Course Description

                This course covers the design and development of advanced database programs using joins and

                subqueries to update a created Oracle database.  Provides a hands-on experience using   

                PL/SQL.  Backup and recovery techniques are covered, including data    integrity techniques.

Course Objectives

                Upon the successful completion of this course, the student will

                a.             know the basic concepts in designing and developing of advanced database programs

                                using SQL;

                b.             know the backup and recovery techniques;

                c.             be able to write, debug, and document programs using PL/SQL.

Instructional Materials

Oracle 9i Developer: PL/SQL Programming, by: Joan Casteel, Thomson/Course Technology,

ISBN 0-619-15909-X

Teaching Strategies

                The course will be conducted with lectures based on the text, and hands-on applications concepts. 

                The professor will provide additional course-work if and when necessary.

Course Outline

                                               

Ø       Introduction to PL/SQL

Ø       PL/SQL Basics

Ø       Records and Tables

Ø       SQL within PL/SQL

Ø       Built-in SQL Functions

Ø       Cursors 

Ø       Procedures

Ø       Functions

Ø       Error Handling

Ø       Packages                                              

Ø       Triggers

Ø       Synonym

Ø       Sequence

Ø        DBMS_OUTPUT

Course Requirements

                1.             Mid - Term examination

                2.             Final examination                                

                3.             Completion of all written and oral assignments

                4.             Active class participation

                5.             Regular class attendance

Evaluation Methods

                Final Grade:                                                          

                Mid -Term Examination                                       30 percent

                Final Examination                                 30 percent

                Quizzes                                                                  10 percent

Assignments                                                        25 percent

                Class Participation &

Attendance                                           05 percent

                Grading Scale:    

                90 - 100                                                                   A

                80 - 89                                                                     B

                70 - 79                                                                     C

                60 - 69                                                                     D

                Below 60                                                                F

Bibliography:

                Abbey, Michael & Corey, Michael.  Oracle, A Beginners Guide.

                                Osborne McGraw - Hill

               

                Fuerstein, Steven .  Oracle PL/SQL.  O'Reilly & Assoc., Inc.

               

                Lockman, David.  Developing Personal Oracle 8 Applications.

                                Sams Publishing.

 

General Class Policies

·                No food or drink is permitted in any Montgomery College classroom at any time.

·                You are responsible for all work missed, and for meeting assignment due dates when absent.

Please call or email your instructor if you are going to be late or absent.

·                You are strongly encouraged to contact your instructor at home by phone or e-mail if you are

having difficulties,  or have any questions about assignments.

·               All assignments are expected to be the result of your own efforts, not the collaboration with others.

Plagiarism or turning in an assignment, which is essentially identical to that of another student, will result in a zero for that assignment, with no opportunity to make up the grade.

 

Disability Support Services

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 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, which is located at 122CB.