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.
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.
|09:00-09:30||Registration and coffee|
|09:30-10:30||Session 1: Introduction||Spiros Denaxas|
|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|
|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|
Session 6: Relational database modelling
Session 7: Practical on Session 6
||Spiros Denaxas, Arturo Gonzalez-Izquierdo, Kenan Direk, Václav Papez|
Summary and Q&A session
Dr Spiros Denaxas
- Dr Arturo Gonzalez-Izquierdo (Lead tutor)
Arturo has a background in Statistics and came to the UK to specialise in the areas of Epidemiology and Public Health (MSc) and Biostatistics (PhD).
In the course of his PhD at Imperial College London and work at UCL over the last nine years, Arturo has gained expertise in studies related to the epidemiology of disease, the identification of patient populations and definition of patient classifications, and the understanding of healthcare utilisation and provision, with particular emphasis on the curation and analysis of large collections of data generated during the delivery of healthcare at national levels.
- Dr Spiros Denaxas
Spiros is a Senior Lecturer in Biomedical Informatics based in the Farr Institute London.
His research focuses on Electronic Health Record (EHR) phenotyping methods for translational research. He also manages CALIBER, a linked EHR data warehouse of 2 million adults in the UK.
- Dr Kenan Direk
Kenan currently researches subsequent events in patients with coronary heart disease through large-scale linked health record data.
He also contributes to international efforts in the genetic epidemiology of coronary heart disease.
- Mr Václav Papez
Václav has a background in computer science and software engineering. He is a PhD candidate involved in research into data modelling in the electroencephalography domain with a neuroinformatics research group at the University of West Bohemia, Czech Republic.
Recently, he joined the DataLab group at the UCL Institute of Health Informatics as a research associate, where his current research is focused on the computable representation of EHR-driven phenotypes.