Aug 17, 2019  
2018-2019 Undergraduate Catalog 
    
2018-2019 Undergraduate Catalog [ARCHIVED CATALOG]

[Add to Portfolio]

IT 469 - Enterprise Database Systems: SQL


Description:
Students will learn to write SQL statements, basic database administration, and report writing skills. Course will be offered every year. Course will not have an established scheduling pattern.

Prerequisites:
Prerequisite: IT 468.

Credits: (4)

Learner Outcomes:
Upon successful completion of this course, the student will be able to:

  • Manipulate a database on paper prior to working in SQL
  • Examine concepts and terminology associated with relational databases.
  • Use SQL to query a database, discussing the use of simple and compound conditions; computed columns; the SQL operators BETWEEN, LIKE, and IN; SQL functions; nesting queries; grouping data; and retrieving columns with null values.
  • Use queries to join multiple tables, discussing the SQL operators IN and EXIST, SQL set operations, and the use of the ALL and ANY operators.
  • Apply specific SQL commands, including COMMIT, ROLLBACK, UPDATE, INSERT, and DELETE commands to update table data.
  • Use procedural code to write stored programs, including the use of transactions and locking.
Learner Outcomes Approval Date:
2/15/18



[Add to Portfolio]