For the latest COVID-19 information and news from Centennial College, please visit Together Again Fall 2021.

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.