Home         Resumé         Interests         Courses         Projects        


CIS 251 - Structured Query Language (SQL)

Fall, 2013 - 5.0 Credits

Course Overview:

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.

Course Objectives:

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. .
  6. Perform basic database maintenance and administration such as: insert, update and delete data, create, drop and modify tables.
  7. Create various types of select statements including: table, multi-table and joins, and be proficient with functions and expressions.
  8. Explain the significance of and create indexes.