CISP 352 Intermediate SQL
Hours: 54 hours LEC
Advisory: CISP 351
This course builds upon the Introduction to Relational Databases and SQL course with more in-depth SQL constructs common to most commercial database products and extensions to the SQL language. Topics include: complex joins including inner and outer joins, correlated subqueries, complex table definition, table and column constraints, Union, Intersection, Minus, triggers, procedures and packages.
Student Learning Outcomes
Upon completion of this course, the student will be able to:
SLO# 1: Design, implement, and demonstrate an understanding of SQL constructs to include data definition language, data manipulation language, and data query language