INF6505   Database Design and Data Management (distance learning)   (15 credits)

Description

Effective data management is key to any organisation, particularly with the increasing availability of large and heterogeneous datasets (e.g. transactional, multimedia and geo-spatial data). A database is an organised collection of data, typically describing the activities of one or more organisations and a core component of modern information systems. A Database Management System (DBMS) is software designed to assist in maintaining and utilising large collections of data and becoming a necessity for all organisations. This module provides an introduction to the area of databases and database management, relational database design and a flavour of some advanced topics in current database research that deal with different kinds of data often found within an organisational context. Lectures are structured into three main areas: (1) an introduction to databases, (2) the process of designing relational databases, and (3) advanced topics (e.g. data warehouses and non-relational databases). The course includes a series of practical sessions aimed at providing you with the skills required to implement a database in Oracle and extract information using the Structured Query Language (SQL).

Reading List