CITC 2340 Advanced Database Concepts & Programming

3 Credit Hour(s)

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:

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

Prerequisite(s): CITC 1301 and CITC 1303
This course is not designed for transfer to four-year universities. Students should check course recommendations with the college or university to which they intend to transfer for a baccalaureate degree. The receiving institution always makes the final decision about transferability of credits.