Farr Institute London Short Courses


SQL for Biomedical Researchers

Databases are increasingly being used for the rapid querying and construction of complex datasets in health and social care. This one-day short course will introduce the theory behind the relational data model and enable participants to understand how data can be modelled and stored in a relational database and the different data types that are used.

Through practical-driven sessions, participants will learn how to model biomedical data in a contemporary relational database management system and how to craft simple and complex queries for analysing and transforming the data.

Learning Objectives

By the end of the course, participants will:

  • understand the relational data model, data types and basic data modelling techniques;
  • have learned how to pre-format and load their data in a database system;
  • have learned how to create simple and complex queries using SQL.

Outline Timetable

Time Activity Led by
09:00-09:30 Registration and coffee  
09:30-10:30 Session 1: Introduction Spiros Denaxas
10:30-10:45 Coffee  
10:45-11:30 Session 2: Basic SQL Arturo Gonzalez-Izquierdo
11:30-12:30 Session 3: Practical on Session 2 Spiros Denaxas, Arturo Gonzalez-Izquierdo, Kenan Direk, Václav Papez
12:30-13:30 Lunch  
13:30-14:00 Session 4: Relational database modelling Václav Papez
14:00-15:00 Session 5: Practical on Session 4 Spiros Denaxas, Arturo Gonzalez-Izquierdo, Kenan Direk, Václav Papez
15:00-15:15 Coffee  
15:15-16:00 Session 6: Relational database modelling
Arturo Gonzalez-Izquierdo
Session 7: Practical on Session 6
Spiros Denaxas, Arturo Gonzalez-Izquierdo, Kenan Direk, Václav Papez
 16:50-17:00 Summary and Q&A session
Dr Spiros Denaxas

Course Team

Dr Arturo Gonzalez-Izquierdo (Lead tutor)
Dr Spiros Denaxas
Dr Kenan Direk
Mr Václav Papez