Building on the learning from the introductory database module, this module introduces learners to more advanced database topics such as SQL, Advanced SQL, Query Optimization, Transaction Management, Distributed Databases and Web technology.
Structured Query Language:-
Introduction to SQL Evolution of SQL Writing SQL Commands Data Definition Language Data Manipulation Language
Advanced SQL:- SQL Access Control Views Integrity Enhancement Features of SQL Advanced Data Definition,
Query Optimisation:- DBMS File Management Internal DBMS Tuning Query Optimisation using SQL
Transaction Management:- Transaction Support Concurrency Control Database Recovery Transaction Management using SQL
Distributed Databases:- Concepts Overview of Networking DDBMS Characteristics Distributed Processing Vs. Parallel Processing
Functions and Architecture of a DDBMS
Transparencies in a DDBMS Distributed
Relational Database Design Types of DDBMS
The module is delivered through a combination of lectures, and the tutor leads IT labs. Additionally, various e-learning aids are used.
-
Lectures: Cover fundamental database concepts and theories.
-
Hands-on Exercises: Reinforce lecture material with individual or group work.
-
Group Project: A collaborative database development project.
-
Online Resources: Provide additional learning materials and support.
-
Assessments: Evaluate understanding with quizzes, tests, and assignments.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |