Dec 03, 2022
CIS 262 Database Administration Backup and Recovery (5 credits)
Prerequisite CIS 260 and CIS 261 , each with 2.0 or above, or instructor permission.
This course addresses the key tasks and functions required of a database administrator in a production environment. Students will gain experience creating and implementing a database, managing data, expanding the size of the database, implementing basic security and data integrity measures, and granting data access privileges to individual users.
1. Analyze, design, and create relational databases using current relational database management system software.
2. Determine client and server-side configurations necessary for installing a database.
3. Create, startup, and shutdown an operational database.
4. Manage database files.
5. Diagnose and troubleshoot database problems.
6. Identify network problems that affect the database.
7. Monitor databases for performance and availability.
8. Manage users, privileges, and resources.
9. Identify network security risks related to the database.
10. Discuss issues involved in developing an effective backup and recovery strategy.
11. Use appropriate restore and recovery methods and operations to resolve database failure.
12. Apply different recovery techniques.
13. Use Data Definition Language (DDL) to create or modify database objects.
14. Use Data Control Language (DCL) to create roles and permissions and control access.
Add to Portfolio (opens a new window)