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
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 Examination | 70 |
| Other Assessment(s) | 30 |