Database Management and Administration

Module summary

Module code: COMP1638
Level: 6
Credits: 15
School: Liberal Arts and Sciences
Department: Computing and Mathematical Sci.
Module Coordinator(s): Tatiana Simmonds

Specification

Pre and co requisites

Basic knowledge of SQL and relational databases

Aims

To introduce more advanced database concepts and provide the necessary knowledge and practical skills of creating and maintaining the database including database users, objects and data. This course also teaches how to protect the database and how to identify and solve various database problems.

Learning outcomes

On successful completion of this course a student will be able to:
1 Critically evaluate the concepts and tools of the database management systems.
2 Demonstrate substantial ability to design, build and manage various database structures based on the specified business requirements.
3 Identify crucial database security issues and demonstrate ability to solve them in the timely manner.
4 Develop critical awareness of issues relating to database management and practical skills to solve common database management problems

Indicative content

Exploring the database architecture; Creating the database; Managing the database instance; Managing database storage structures; Managing transactional processing and locking mechanism; Database security; Monitoring the database and using the advisors; Backup and recovery concepts; Investigating, reporting, and resolving problems.