CMPSC245 — Oracle and SQL
3.0 HR. (OC) Prerequisite: CMPSC 140 with a grade of C or better or department approval. This course covers using the Oracle database and programming in the Structured Query Language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create blocks of application code that can be shared by multiple forms, reports, and data management applications. The student will learn how to write and apply triggers, procedures, and packages. Demonstrations and hands-on practice reinforce the fundamental concepts. Two lecture and two laboratory hours per week. (Formerly DATPR 129)