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)
Competencies
- Practice installation, configuration and management of a database management system.
- Apply and practice knowledge of importing and restoring data into a DBMS.
- Apply and practice knowledge of exporting and backing up data from a DBMS.
- Construct a database using object-oriented modeling.
- Learn and demonstrate entity-relationship database modeling.
- Evaluate current vendor DBMS offerings.
- Compare and contrast current technologies of a relational database, object-oriented DB, NoSQL and flat file.
- Understand, differentiate and demonstrate database replication and mirroring.
- Employ appropriate tools to ensure health of DBMS.
- Define database normalization.
- Apply database optimization methods.
- Communicate database designs and changes to appropriate stakeholders.
Degrees that use this course
Degrees that use this course
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
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
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
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