University of Galway

Course Module Information

Course Modules

15 months long | Credits:

This course examines key tasks and functions required of a database administrator in a production environment. Students create, start-up, and manage a database. In addition, students create tables and indexes, implement data security, data integrity measures, and grant access privileges to individual database users.

Learning Outcomes
  1. Diagram and explain the architecture of the Oracle 12c database, installation options and the Optimal Flexible Architecture
  2. Examine and utilize DBA tools, specifically the Oracle Enterprise Management console and the Database Grid Control; and evaluate the background processes that perform the database maintenance operations
  3. Compare and contrast data dictionary views (V$ views) that monitor databases structures, user activities, and real-time performance
  4. Select and apply SOL to create, modify, or remove redo log files, control files, datafiles and database-generated diagnostic files
  5. Assess the function and operation of the Oracle physical and logical structures
  6. Create, modify, and drop Oracle tablespaces, and create provisioning for undo and temp data
  7. Evaluate and choose storage concepts and settings
  8. Evaluate and explain advanced table management concepts
  9. Evaluate and apply index management in the Oracle 12c database
  10. Design user security and resource control for the database including object privileges and storage quotas
  11. Evaluate and select appropriate database roles, privileges and profiles
  12. Differentiate and apply performance monitoring and automation concepts
  13. Design and evaluate proactive maintenance steps for the database
  14. Create and evaluate advanced data types for database applications
  15. Compare and contrast user-managed backups with Oracle’s RMAN backup and recovery tool
Assessments
  • Department-based Assessment (100%)
Teachers
The above information outlines module CT615: "Database Administration" and is valid from 2014 onwards.
Note: Module offerings and details may be subject to change.