Database Programming

CIT 30400/ 3 Cr.

This course explores the concepts and skills required for advanced database programming and their implementation using programmatic extensions to Structured Query language (SQL).  Topics include advanced data manipulation, stored procedures, triggers, and query optimization. Concepts will apply to any modern distributed database management system.

• Available Online: Yes
• Credit by Exam: No
• Laptop Required: Yes

Prerequisites/Co-requisites:

Software

• Oracle SQL Developer

Outcomes

Course Outcomes (What are these?)

• Understand database design issues (CIT c)
• Write complex SQL queries (CIT a)
• Use advanced DML and DDL statements (CIT i)
• Explain what PL/SQL is and why it is needed (CIT i)
• Create PL/SQL blocks (CIT c)
• Use a variety of variable types to handle data in a block (CIT c)
• Conditionally process statements using control structures (CIT c)
• Manage errors with exception handlers (CIT c)
• Create and use procedures and functions (CIT c)
• Bundle programs units with packages (CIT c)
• Develop database triggers (CIT c)
• Identify and manage program unit dependencies (CIT i)
• Use object relational features (CIT i)
• Perform basic statement tuning (CIT m)

CIT Student Outcomes (What are these?)

(a) An ability to apply knowledge of computing and mathematics appropriate to the program’s student outcomes and to the discipline.

(c) An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.

(i) An ability to use current techniques, skills, and tools necessary for computing practice.

(m) An understanding of best practices and standards and their application.

Topics

• Database Design & Complex Queries
• SQL Functions
• Advanced DML and DDL
• PL/SQL Basics
• Exception Handling
• Stored Procedures & Functions
• PL/SQL Packages
• Program Unit Dependencies
• Database Triggers
• Large objects and object relational features
• Performance Tuning