Module Overview

Enterprise Database Systems

This module provides the student with and understanding of the role of a generic large client/server Enterprise Database System implementation, using a specific implementation (Oracle11g), the role of Enterprise Manager tools, in maintaining and supporting a large Database and of database programming languages in software development environment using SQL, PL/SQL and the tool SQL Developer

Module Code

DATA 2001

ECTS Credits


*Curricular information is subject to change

Enterprise Database System Fundamentals

The Client/Server Database environment – Oracle 11g - 22c

The design and architecture of large database installations

The tools available to manage large databases – management, recovery

Database objects – tables, indexes, constraints, sequences, triggers, stored procedures, functions, views and exception/error handling and testing of results

The role of Data Administration and Database Administration in the Enterprise

The role of the Data Dictionary

Transaction Management and concurrency control

Web/Server Database environment

Database Backup and Recovery

Database as a Service – Cloud hosting solutions and options

The impact of Social, Mobile, Big Data, Cloud and the Internet of Things in data creation

Privacy, Ethics and Security

The delivery of this course will be a combination of lectures and computer laboratory based work. The lecture/laboratory work will consist of 4 hours per week instructor-led learning with practical implementation.  This will be supplemented by further unsupervised laboratory course work by the student to incorporate learning and assessment preparation

Module Content & Assessment
Assessment Breakdown %
Formal Examination70
Other Assessment(s)30