Advanced Database Concepts
| Course Code | COMP-214 |
|---|---|
| Lecture hours per week | 2 |
| Lab hours per week | 2 |
| Course Availability | Open |
| Description | This course expands students’ knowledge of database systems by developing advanced skills in Oracle database programming, database administration concepts, MongoDB-based NoSQL data management, and AI-ready data systems. Students work with Oracle Database to write advanced SQL queries, manage database objects, apply security and access-control concepts, and develop server-side database programs using procedural database programming techniques such as blocks, cursors, exception handling, procedures, functions, packages, and triggers. The course also introduces MongoDB concepts, including document-based data modelling, CRUD operations, aggregation, and data analysis pipelines. Students examine emerging database practices for AI applications, including vector data, embeddings, similarity search, and the role of relational, multi-model, and dedicated vector databases in managing structured and unstructured data. Students use AI-assisted development practices to support query design, debugging, code explanation, documentation, database programming, and validation while maintaining accuracy, security, privacy, and professional judgment. Through hands-on labs, assignments, and a database backend project for a business application, students develop practical skills for building reliable, scalable, and intelligent data-driven software systems. |