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 business databases using relational database management systems and NoSQL technologies. Students learn how to install, configure and work with database server and development environments, while extending their SQL skills beyond the first database course. Topics include advanced SQL queries, data and table manipulation, database security fundamentals, triggers, functions, stored procedures, packages, MongoDB CRUD operations and the MongoDB Aggregation Framework. Students apply these concepts in a project that involves designing and developing the database back end for a “commercial”-style web application. |