Title

CPTR2240 - Database Administration

Description

Description

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.
API ID

Credits

3 (2/1/0)

Prerequisites

OR

Pre/Corequisites

Competencies

  1. Practice installation, configuration and management of a database management system.
  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 database modeling.
  6. Evaluate current vendor DBMS offerings.
  7. Compare and contrast current technologies of a relational database, 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

Degrees that use this course

Computer Programming
Degree:
Associate of Applied Science (AAS)
This program provides the programming skills needed in computer application development, database management, computer systems and data...
Location:
Moorhead Campus
Online
Credits:
60
Cybersecurity
Degree:
Associate of Applied Science (AAS)
This program provides the skills to support and maintain information technology (IT) systems. These skills include overall computer...
Location:
Moorhead Campus
Online
Credits:
60
Cybersecurity
Degree:
Certificate
This certificate is designed for individuals looking to add technical skills in IT security. A person earning this certificate will develop...
Location:
Moorhead Campus
Online
Credits:
30
Information Technology
Degree:
Associate of Applied Science (AAS)
This school-to-work degree focuses on customer service and user support, with an emphasis on technical skills, including desktop and network...
Location:
Online
Credits:
60