CPTR2240 - Database Administration

3 (2/1/0)
Students in this course will identify core database concepts and create database models. Installation, configuration and maintenance of a database management system (DBMS) will be covered. Students will analyze and administer a database's performance optimization. Additional topics will include user administration within the database, backup and restoration, and database normalization.
  1. Practice installation, configuration and management of a database management system (DBMS).
  2. Apply and practice knowledge of importing and restoring data into a DBMS.
  3. Apply and practice knowledge of exporting and backing up data from a DBMS.
  4. Construct a database using object-oriented modeling.
  5. Learn and demonstrate entity-relationship (ER) database modeling.
  6. Evaluate current vendor DBMS offerings.
  7. Compare and contrast current technologies of a relational database (DB), object-oriented DB, NoSQL and flat file.
  8. Understand, differentiate and demonstrate database replication and mirroring.
  9. Employ appropriate tools to ensure health of DBMS.
  10. Define database normalization.
  11. Apply database optimization methods.
  12. Communicate database designs and changes to appropriate stakeholders.
Degrees that use this course