ITEC 2122 - Advanced SQL

4 Credit(s) 3 credits lecture/1 credit lab

This course builds upon concepts introduced in the prerequisite course. It teaches students techniques to develop and optimize complex queries which can involve joins and subqueries nested at many levels. Advanced Structured Query Language (SQL) commands will be utilized, including more SQL syntax used to manipulate and prepare data for use. Students will also learn to create user-defined functions and stored procedures.

Course Prerequisite(s): ITEC 2121 or ITEC 2120