2017-2018 Academic Catalog 
    
    Apr 25, 2024  
2017-2018 Academic Catalog [ARCHIVED CATALOG]

Add to Personal Catalog (opens a new window)

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:

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



Add to Personal Catalog (opens a new window)