IS 252 Advanced SQLQuery Design with Oracle & SQL Server

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.

Credits

3 credits

Prerequisite

A grade of C or better in IS 240

Offered

Spring