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.
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.