CS 276 Database Systems II

Introduces the fundamentals of the programming procedural language extension to Standard Query Language. Areas of concentration include: structures, Boolean logic, stored procedures, functions and packages, blocks and nested blocks, triggers and error checking. Students will design and construct a database, then write programs in the procedural code to manipulate the data in an efficient, results oriented manner.


Credits

4

Prerequisite

Prerequisite: CS 275 Database Systems: SQL and Oracle with a grade of C or better.

Offered

Offered Spring only

Notes

Lower Division Transfer (LDT) Course

General Education Requirements

AGS Math/Science,

Outcomes

Upon successful completion of this course, students will be able to:
Manipulate database tables using program units. Identify and use appropriate programming constructs to fulfill application logic requirements. Write program units that include procedures, functions, triggers, packages and error trapping facilities. Identify and use user-defined classes and objects.