CISP 352
Intermediate SQL
3 Units
Prerequisite: None.
Advisory: CISP 351
Course Transferable to CSU
Hours: 54 hours LEC
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.