-
Courses
Courses
Choosing a course is one of the most important decisions you'll ever make! View our courses and see what our students and lecturers have to say about the courses you are interested in at the links below.
-
University Life
University Life
Each year more than 4,000 choose University of Galway as their University of choice. Find out what life at University of Galway is all about here.
-
About University of Galway
About University of Galway
Since 1845, University of Galway has been sharing the highest quality teaching and research with Ireland and the world. Find out what makes our University so special – from our distinguished history to the latest news and campus developments.
-
Colleges & Schools
Colleges & Schools
University of Galway has earned international recognition as a research-led university with a commitment to top quality teaching across a range of key areas of expertise.
-
Research & Innovation
Research & Innovation
University of Galway’s vibrant research community take on some of the most pressing challenges of our times.
-
Business & Industry
Guiding Breakthrough Research at University of Galway
We explore and facilitate commercial opportunities for the research community at University of Galway, as well as facilitating industry partnership.
-
Alumni & Friends
Alumni & Friends
There are 128,000 University of Galway alumni worldwide. Stay connected to your alumni community! Join our social networks and update your details online.
-
Community Engagement
Community Engagement
At University of Galway, we believe that the best learning takes place when you apply what you learn in a real world context. That's why many of our courses include work placements or community projects.
Header & Footer
University of Galway
Course Module Information
Course Modules
CT615: Database Administration
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
- Diagram and explain the architecture of the Oracle 12c database, installation options and the Optimal Flexible Architecture
- 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
- Compare and contrast data dictionary views (V$ views) that monitor databases structures, user activities, and real-time performance
- Select and apply SOL to create, modify, or remove redo log files, control files, datafiles and database-generated diagnostic files
- Assess the function and operation of the Oracle physical and logical structures
- Create, modify, and drop Oracle tablespaces, and create provisioning for undo and temp data
- Evaluate and choose storage concepts and settings
- Evaluate and explain advanced table management concepts
- Evaluate and apply index management in the Oracle 12c database
- Design user security and resource control for the database including object privileges and storage quotas
- Evaluate and select appropriate database roles, privileges and profiles
- Differentiate and apply performance monitoring and automation concepts
- Design and evaluate proactive maintenance steps for the database
- Create and evaluate advanced data types for database applications
- Compare and contrast user-managed backups with Oracle’s RMAN backup and recovery tool
Assessments
- Department-based Assessment (100%)
Teachers
- AISLING MONAHAN:
Research Profile |
Email
- MAJELLA O'DEA:
Research Profile |
Email
Note: Module offerings and details may be subject to change.