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

Anticipated Course Offering Terms and Locations: