CITC 2344 - Database SQL Programming
Credit hours: 3
A comprehensive study of SQL using an industry established relational database management system such as Microsoft SQL Server or Oracle RDBMS.
Topics will include database design, creation and management, advanced queries, stored procedures and functions, triggers, user defined functions, security awareness in an optimistic and pessimistic contingency DML data control, and performance tuning issues.
Student Learning Outcomes:
Students will be able to:
- Demonstrate effective use of documentation, tutorials, and on-line resources for data modeling tools to express conceptual/physical designs and data organizations including replication, partitioning and data linkage.
- Demonstrate effective application of all major SQL statements and views.
- Apply object security concepts to specify and implement roles, user, views and object privileges.
- Create, debug and integrate stored procedures, user defined functions, and triggers in a database system.
- Explore the contention control capabilities of a database’s abort/recovery and roll-back operations.