Jul 17, 2024  
2020-2021 Undergraduate Catalog 
2020-2021 Undergraduate Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

IT 469 - Enterprise Database Systems: SQL

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.

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:

Anticipated Course Offering Terms and Locations:

Add to Portfolio (opens a new window)