|
ITUL420.1
|
Design conceptual data models using ER diagrams for real-world scenarios like banking, university, or library management systems. |
| ITUL420.2 |
Implement relational databases by executing Data Definition (DDL) and Data Manipulation (DML) commands with appropriate integrity constraints. |
| ITUL420.3 |
Formulate complex database queries involving joins, nested queries, set operations, and aggregate functions to retrieve meaningful information. |
| ITUL420.4 |
Develop procedural database logic using PL/SQL blocks, including triggers, stored procedures, and functions for transaction-based applications. |
| ITUL420.5 |
Evaluate emerging database technologies and security vulnerabilities through NoSQL case studies and SQL injection analysis. |
