CIS 251 - Structured Query Language (SQL)

5.0 Credits
Covers topics in Structure Query Language (SQL) including statements such as select, update, insert, delete, create. Emphasis on the ability to extract, update and maintain databases using SQL. Prerequisite: CIS 250 with a minimum grade of 2.5 or equivalent.

Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Explain what SQL is. [REASON]
Identify the major data types. [REASON]
Describe why SQL is such a powerful tool. [COMMUNICATE]
Create relational databases using SQL. [REASON]
Perform basic database maintenance and administration such as: insert, update and delete data, create, drop and modify tables. [REASON]
Create various types of select statements including: table, multi-table and joins, and be proficient with functions and expressions. [REASON]
Explain the significance of and create indexes. [REASON]