Oct 03, 2022  
Course/Program Inventory 
Course/Program Inventory

CITC 2346 - Database PL/SQL Procedural Programming

Credit hours: 3

Course Description:
An continuation of the study of Microsoft SQL Server or Oracle relational database concepts and the 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.