CRC19: Courses

CISP 352 Intermediate SQL

Units: 3

Hours: 54 hours LEC

Prerequisite: None.

Advisory: CISP 351

Transferable: CSU

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