ITM 620 Database Management and Programming

This course will focus on relational database administration, as well as the use of Structured Query Language (SQL) and its object-oriented extensions—stored procedures and functions. Students will use a modern relational database management system (DBMS) to learn database administration, including the creation and updating of objects in databases. Specifically, students will learn to write procedural logic, such as data validation, using conditional and iterative controls, error handling, and store them in a central location. In addition, database security issues, such as access control, will be discussed.

Credits

Prerequisite

CYB 601 or ITM 505. Can be waived if the student has completed a database or programming course within the past 7 years with a grade of "B" or higher; or passed Oracle Database SQL Certified Associate Exam.

Offered

summer