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