Next Virtual Open Day — 2 December 2026 · 12:00 GMT · Register →
Module · Elective/Data Science & Econometrics

SQL-NoSQL

Students examine the differences between SQL and NoSQL approaches and learn the principles of data modelling, normalisation, indexing and database management. Practical work introduces widely used relational databases, including MySQL and PostgreSQL, alongside MongoDB as a non-relational database.

Delivery

Live online lectures and tutorials, conducted at scheduled times and recorded for review.

Study Hours

Approximately 100 hours of study, of which 15 are contact hours and 85 are private study.

Software Used

MySQL, PostgreSQL, MongoDB

Credits

10 CATS credits

Module Lead
Woody Pan

Woody Pan

Programme Faculty

Key Outcomes

  • —Design and manage databases
  • —Write SQL for MySQL and PostgreSQL
  • —Work with MongoDB and non-relational data
  • —Apply data modelling, normalisation and indexing
  • —Choose an appropriate database architecture for a project

Lecture Programme

  1. WK 01

    Introduction and basic concepts

    • ·Database systems and terminology
    • ·Relational and non-relational approaches
  2. WK 02

    Relational algebra and SQL

    • ·Algebraic query language
    • ·Core SQL operations
  3. WK 03

    Database design

    • ·Data modelling
    • ·Normalisation
    • ·Indexing
  4. WK 04

    SQL database management

    • ·Working with MySQL and PostgreSQL
    • ·Managing relational data
  5. WK 05

    NoSQL and non-relational databases

    • ·Document-oriented data
    • ·Working with MongoDB
    • ·Choosing an appropriate database architecture

Assessment

Online coursework submission with support from the module lecturer and tutor.

Build your qualification

Take SQL-NoSQL as a standalone module, or as part of a buildable MSc.

Apply NowSee full programme