Teaching Responsibility

LJMU Schools involved in Delivery:

LJMU Partner Taught

Learning Methods

Lecture
Practical

Module Offerings

5502CSMM-APR-PAR
5502CSMM-JAN-PAR
5502CSMM-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 & 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

Technology
Report