Oct 22, 2020
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.
Upon successful completion of this course, the student will be able to:
Learner Outcomes Approval Date:
- 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.
Add to Portfolio (opens a new window)