CIT 183 - Database Administration

Credits: 3

Description
An introduction to the primary responsibilities of a database administrator. Learn to install a DBMS, such as SQL Server or Oracle; to manage database objects to monitor performance; to manage data storage; to oversee database security and user access; to ensure database connectivity; and to plan for backup and recovery.

Student Learning Outcomes

Categorize the responsibilities of a database administrator.
Describe the architecture of a database.
Plan for the installation of a database by following manufacturer’s procedures.
Create databases to meet client requirements.
Manage database instances and storage structures.
Summarize the steps required for administering user accounts.
Analyze database statistics and transactions logs in order to assure that the database is optimized and current.
Devise a backup and recovery plan to protect organizational databases from data loss.

Prerequisite: CIT 180 or Instructor approval
Corequisite: None

Graded: Letter Grade