IS 252 Advanced SQL Query Design with Oracle & SQL Server

3 credits

Develops proficiency in effective database and query design. Students will learn the underlying concepts of complex SQL Queries, the key to writing serviceable code, the normalization of data to minimize duplication and errors, the design of stored procedures and triggers to improve system performance, optimization techniques using cursors and join statements, transaction control, techniques for securing data, and tools for testing data integrity. Students will design a multi-table, normalized, relational business database and advanced SQL queries.

Prerequisite(s): IS 240.