Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Online

Module Offerings

5502COMECA-SEP-PAR

Aims

To implement relational database designs using a Relational Database Management System (RDBMS) To employ database connectivity technologies in developing data driven applications. To investigate the administration of a RDBMS. To critically evaluate and implement alternative / non-relational database designs using NoSQL.

Learning Outcomes

1.
Implement relational database designs.
2.
Develop data driven applications.
3.
Critically evaluate the advantages and disadvantages of NoSQL.
4.
Implement alternative / non-relational database designs.

Module Content

Outline Syllabus:Introducing RDBMS SQL -Components & DDL (for Tables) -DML (for SELECT) -DML (for JOINS & INSERT - UPDATE - DELETE) -Views & Indices (DDL & DML) -SPROCs & Triggers (DDL & DML) Connectivity -Client Server vs Embedded DBs -Connectivity APIs Administration of RDBMS -Security & Permissions -Replicating Data -Optimizing Queries NoSQL -Key-Value & Document Store
Additional Information:The module begins by exploring the operation of database systems through a scrutiny of modern RDBMS (Relational Database Management Systems), the SQL (Structured Query Language) and database connectivity APIs (Application Programming Interfaces). The module continues by exploring some of the managerial considerations of large-scale RDBMS. The module concludes by exploring the operation of emerging NoSQL (Not Only SQL) database systems. This module thusly represents the logical follow-on to NQF4's Data Modelling module.

Assessments

Portfolio
Technology