Teaching Responsibility
LJMU Schools involved in Delivery:
LJMU Partner Taught
Learning Methods
Lecture
Practical
Module Offerings
5502CSQR-SEP-PAR
Aims
To implement relational database designs using modern database management systems.
To utilize database connectivity technologies in developing data driven applications.
To introduce database administration tasks and the key concepts of data management, quality and security.
To investigate database systems in the context of business intelligence.
Learning Outcomes
1.
Implement relational database designs and query them using SQL.
2.
Develop data driven applications.
3.
Perform database administration tasks.
4.
Evaluate the role of database systems in supporting business intelligence.
Module Content
Outline Syllabus:DBMS Architecture
SQL
Components & DDL (for Tables)
DML (for basic SELECT)
DML (for JOINS & INSERT - UPDATE - DELETE)
Views & Indices (DDL & DML)
SPROCs & Triggers (DDL & DML)
Connectivity
Client Server vs Embedding DBs
Connectivity APIs
DBMS Administration
Security
Availability
Optimization
Business Intelligence
Alternate DBMS / Big Data
Additional Information:This module explores the implementation of database systems through an examination of modern database management systems, the SQL language and database connectivity APIs. The module continues by exploring the managerial considerations of large scale database systems as well as the emergent fields of business intelligence and data analytics.