XClose

Farr Institute London Short Courses

Home
Menu

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
16:00-16:50
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