CIS 2515

Database Design and Management with Oracle SQL

4 Credits

Prerequisites: CIS 1200 or consent of instructor.

This course will focus on design and management of database environments using Oracle SQL and associated Oracle technologies. Topics include enterprise information resource planning and object-oriented and entity-relationship data modeling methodologies, normalization and the relational model, logical and physical database design, and implementation, population and processing of a relational database for data access, report generation, database definition, data manipulation, and access control. Oracle-specific materials used in this course are designed to prepare students for an Oracle Database SQL exam which is the first exam required to become an Oracle Certified Associate or Oracle Certified Professional. Students will be required to complete computer-based assignments inside and outside of class. Course/lab fees