CIA 3103 Database Design and Administration (2-2-3)

Apply data modelling, database design and database administration techniques on an RDBMS server. Learn how to use Structured Query Language (SQL) to define, manipulate, and administer data. Develop an understanding of the concept of database administration and define the duties and responsibilities of database administrators.

Prerequisites: CIS 1303

CIA 3313 Database Administration (2-2-3)

Building upon Database Systems, this course familiarizes students with different concepts of database administration including DBA Roles and responsibilities, tablespace and storage management, DB backup and recovery, security, audit, and SQL tuning. Throughout the course, a series of progressive assignments helps students gain hands-on experience about installation, administration, access control, audit, backup, and recovery to ensure organizational efficiency and continuity. Additional topics include schemas objects, locking, and concurrency.

Prerequisites: CIS 1303