Feb 01, 2023  
Course/Program Inventory 
Course/Program Inventory

CITC 2340 - Advanced Database Concepts & Programming

Credit hours: 3

Course Description:
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, security awareness, and performance tuning.

Student Learning Outcomes:
Students will be able to:

  1. Demonstrate effective use of documentation, tutorials, and on-line resources.
  2. Demonstrate effective application of all major SQL statements.
  3. Apply object security concepts to specify and implement role and user privileges.
  4. Create, debug and integrate stored procedures, functions, and triggers in a database system.
  5. Use a graphical user interface to create and manage a relational database.