Oracle SQL and PL/SQL   [Archived Catalog]
2012-2013 Catalog [Aug. 2012-Aug. 2013]
   

CTS 2440 - Oracle SQL and PL/SQL


This course is designed to familiarize individuals with modern database technologies using the SQL relational database language. A series of database application projects using Oracle software is designed to build familiarity with E-R database modeling, database creation, database maintenance, and database optimization. Database architectures including the client/ server model and distributed database model are presented. The objective is to build a working knowledge and hands-on familiarity with SQL and PL/SQL in the Oracle environment.
Degrees Offered: A.S.

Credit Hours:4. 
Contact Hours: 3 lecture hours; 1 laboratory hour.
Student Advising Notes – Suggested courses: COP 1000 or programming experience, and CGS 1100 or database experience.