2020-2021 Catalog and Student Handbook 
    
    Apr 23, 2021  
2020-2021 Catalog and Student Handbook
Add to Portfolio (opens a new window)

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
  1. Categorize the responsibilities of a database administrator.
  2. Describe the architecture of a database.
  3. Plan for the installation of a database by following manufacturer’s procedures.
  4. Create databases to meet client requirements.
  5. Manage database instances and storage structures .
  6. Summarize the steps required for administering user accounts.
  7. Analyze database statistics and transactions logs in order to assure that the database is optimized and current.
  8. Devise a backup and recovery plan to protect organizational databases from data loss.

Prerequisite: CIT 180  or Instructor approval



Add to Portfolio (opens a new window)