CIS 251 - Structured Query Language (SQL)

5.0 Credits
Covers topics in Structure Query Language (SQL) including statements such as select, update, insert, delete and create. Emphasis on the ability to extract, update and maintain databases using MySQL and Workbench.
Prerequisite CIS 250 with a minimum grade of 2.5 or instructor permission.
Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

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