Apr 19, 2024  
Course/Program Inventory 
    
Catalog Navigation
  Catalog Home
  All Courses
  Community College Course Inventory
  Community College Common Course Libraries
  TCAT Course Inventory
  TCAT Program Inventory
  Articulation Agreements
  Tennessee Transfer Pathways
  TCAT to CC Articulation Brochure
HELP
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.