Mar 29, 2024  
Course/Program Inventory 
    
Course/Program Inventory

CITC 2342 - Database Programming II



Credit hours: 3

Course Description:
An introduction to the Microsoft SQL Server or Oracle relational database concepts plus the powerful SQL and Transact-SQL or PL/SQL programming language. Topics include relational database architecture, database design techniques, simple and complex query skills, creating views, creating and tuning indexes, building transactions and triggers, creating stored procedures, functions, triggers, and cursors.

Student Learning Outcomes:
Students will be able to:

  1. Perform procedures necessary to display knowledge of object-oriented database design concepts, principles, and processes.
  2. Execute processes necessary to display knowledge of the language statements required for developing and implementing typical database solutions using triggers, functions, cursors and other database objects.
  3. Demonstrate use of generally accepted coding standards and syntax used in the implementation of commands.
  4. Demonstrate knowledge of relational database design concepts, principles, and processes.
  5. Design and implement SQL language statements required for developing and implementing typical database solutions.