Advanced Database Systems

Master's programme(s):
MSc in Data Science, MSc in Information and Communication Technology (ICT) Systems
Course code(s):

DSC05, ISC09

Instructors:
Christos Tjortjis, Christos Berberidis
Course type:

Compulsory, Compulsory

Semester:

1, 1

Learning outcomes:

On completing the course, the student will be able to:

  • Develop the logical model of a relational database.
  • Use essential SQL tools to program DB systems.
  • Understand advanced concepts of DB management.
  • Organize, store and process data efficiently, using contemporary technologies such as Data Warehouses.
  • Understand and apply various emerging technologies, including Data Mining, OLAP, and Information Retrieval.
  • Understand and utilise knowledge extracted from data.
General competences:
  • Search for, analysis and synthesis of data and information, with the use of the necessary technology
  • Decision Making
  • Teamwork
  • Production of free, creative, and inductive thinking
Syllabus:

The course introduces fundamental concepts and tools related to Advanced Database Systems.

  • ER model, relational model
  • SQL
  • Indexing
  • Hashing
  • Data warehousing and OLAP
  • Data Mining
  • Information Retrieval
Full course outline (PDF):
PDF