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