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 two-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.

Planned Timetable

Day 1

Time Session Title Led by
09:00-09:30 Registration and coffee  
09:30-10:30 Session 1: Introduction  Dr Spiros Denaxas
10:30-10:45 Coffee  
10:45-11:45 Session 2: Relational database modelling Dr Václav Papez
11:45-13:00 Session 3: Practical on previous session Dr Václav Papez,
Dr Spiros Denaxas,
Dr Arturo Gonzalez-Izquierdo
13:00-13:30 Lunch  
13:30-14:00 Session 4: Setting up a relational database Dr Václav Papez,
Dr Arturo Gonzalez-Izquierdo
14:00-14:30 Session 5: Practical on previous session Dr Václav Papez,
Dr Spiros Denaxas,
Dr Arturo Gonzalez-Izquierdo
14:30-14:45 Coffee
 
14:45-15:15 Session 6: Administration Dr Václav Papez,
Dr Arturo Gonzalez-Izquierdo
15:15-16:05 Session 7: Practical on previous session Dr Václav Papez
Dr Spiros Denaxas
Dr Arturo Gonzalez-Izquierdo
16:05-16:30 Summary and Q&A session All

Day 2

Time Session Title Led by
09:30-11:30 Session 8: Basic SQL Dr Arturo Gonzalez-Izquierdo
11:30-12:30 Session 9: Practical on previous session Dr Spiros Denaxas,
Dr Arturo Gonzalez-Izquierdo,
Dr Václav Papez
12:30-13:30 Lunch  
13:30-14:00 Session 10: Intermediate SQL Dr Arturo Gonzalez-Izquierdo
14:00-15:00 Session 11: Practical on previous session Dr Spiros Denaxas,
Dr Arturo Gonzalez-Izquierdo,
Dr Václav Papez
15:00-15:15 Coffee  
15:15-16:50 Session 12: Practical on previous session Dr Spiros Denaxas,
Dr Arturo Gonzalez-Izquierdo,
Dr Václav Papez
16:50-17:00 Summary and Q&A session All

Course Team

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