CS 271 - 400                    MONTGOMERY COLLEGE                       Summer II  2004

Computer Science, Rockville

Oracle Programming

Tentative Schedule

 

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-7934      email:grigoriy.grinberg@montgomerycollege.edu

                               

#

Date

Ch

Topics

1.    

07/13

1

Introduction to PL/SQL

2.    

07/15

2

Handling Data in PL/SQL blocks

3.    

07/20

3

PL/SQL Processing

4.    

07/22

4

Procedures

5.    

07/22

5

Functions

6.    

07/27

6

PL/SQL Packages

7.    

07/27

 

Midterm Exam

8.    

07/29

6

PL/SQL Packages

9.    

08/03

7

Program Unit Dependencies

10. 

08/05

8

Database Triggers

11. 

08/10

9

Oracle-Supplied Packages

12. 

08/12

 

Final Exam

 

 

Program Assignments

Nr.

Exercises (tentative)

Due

H1

Chapter1, Hands-On Assignments 1- 4

 

H2

Chapter2, Hands-On Assignments 1- 2

 

H3

Chapter2, Hands-On Assignments 3,4,5

 

H3

Chapter3, Hands-On Assignments 6- 8

 

H4

Chapter4, Hands-On Assignments 1- 9

 

H5

Chapter5, Hands-On Assignments 1-4

 

H6

Chapter6, Hands-On Assignments 1 -6

 

H7

Chapter7, Hands-On Assignments 1- 6

 

H8

Chapter8, Hands-On Assignments 1- 6