Most College offices will close at 4 pm on Thursday, April 18. There will be no classes and office services on Good Friday, April 19. Regular classes and office services will return on Monday, April 22.

Advanced Database Concepts

Course Code COMP-214
Lecture hours per week 2
Lab hours per week 2
Course Availability: Open
Description: This course is intended to expand student’s knowledge of business database systems.  The course starts with introducing students to the steps required to install an Oracle 10g database and developer system.  Then, it expands on the students’ knowledge of SQL by introducing more complex syntax than that covered in the first database course, as well introducing Oracle Form Builder and Report Builder utilities to create applications.  Topics covered include SQL functions to manipulate numbers, dates, and character strings, grouping, conversion and transformation functions, advanced queries, advanced data and table manipulation commands, basic oracle security, PL/SQL triggers, functions, procedures, and packages, an introduction to Oracle Form Builder, and an introduction to Oracle report builder.