IT 118 - Intermediate Database Management SystemsSemester Hours: 3 Periodically
A practical course covering the concepts of relational database management systems (RDBMS), Structured Query Language (SQL), and PL/SQL. Topics include conceptual design, relational systems design, normalization and denormalization processes and Structured Query Language and its components such as data manipulation commands. Other topics covered are advanced queries, joins, outer joins, subqueries, group functions, formatting query results, triggers, and stored procedures. Special emphasis on data security, data integrity, query optimizations, and database administration.
Prerequisite(s)/Course Notes: IT 117 ; junior class standing or above.
View Course Offering(s):
Summer I 2025
Summer II 2025
Summer III 2025
Fall 2025
Add to Personal Catalog (opens a new window)
|