CPTR2240 - Database Administration
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.
- Practice installation, configuration and management of a database management system (DBMS).
- 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 (ER) database modeling.
- Evaluate current vendor DBMS offerings.
- Compare and contrast current technologies of a relational database (DB), 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
Associate of Applied Science (AAS)