ITEC 4212 - Intermediate Database Design

This course continues the study of relational databases adding these topics: relational algebra, set-theoretic operations, and relational operations. The course contains a complete description of the SQL select syntax, sub-selects, SQL unions and divisions. The database description features of SQL are covered and handling of null values is discussed. The discussion of multi-user databases is expanded. Student teams create a database using SQL.

Prerequisite/Corequisite:
Prerequisite: ITEC 3211 with a grade of C or higher

Hours:
3