Skip Navigation
Centennial College logo
  • Visit Us
  • Donate
  • Quick Links
  • Start Here
    Information For:
    • Future Students
    • New Students
    • Current Students
    • Part-time Students
    • International Students
    • Faculty and Staff
    • Parents and Supporters
    • Alumni
    • Transfer Student
    • Micro-Credentials Students
    • Partner with Centennial
  • Programs
  • Admissions
  • Financial Aid
  • International Education
  • Student Life
  • About
  • Apply Now
  • Donate
  • Apply Now

Advanced Database Concepts

Course CodeCOMP-214
Lecture hours per week2
Lab hours per week2
Course AvailabilityOpen
Description

This course is intended to expand the student’s knowledge of business databases using data RDBMS and NoSQL driven systems. The course introduces students to the steps required to install and configure a database server and development system. Then, it expands the students’ knowledge of SQL by introducing more complex syntax than that covered in the first database course. Topics covered include advanced SQL queries, PLSQL, advanced data and table manipulation commands, basic security, triggers, functions, procedures, and packages, NoSQL document management, CRUD operations and data queries, indexing and aggregation techniques. The course will include a project to develop the database back-end for a “commercial” web application.

Centennial College logo
Image about Canada's Top 502022 top employer Centennial College logo
  • Programs
  • Admissions
  • Student Life
  • Financial Aid
  • About Centennial
  • Careers
  • myCentennial
  • Centennial Luminate
  • Library and Learning
  • Parents and Supporters
  • Partner with Centennial
  • Faculty and Staff
  • Media Room
  • Accessibility
  • Legal
  • Site Map
  • Contact Us
  • 416-289-5000
© 2025 Centennial College. All Rights Reserved.