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 | Tutor |
---|---|---|
09:00-09:30 | Registration and coffee | Dr Spiros Denaxas |
09:30-10:30 | Introduction | Dr Spiros Denaxas |
10:30-10:45 | Coffee | |
10:45-11:45 | Relational database modelling | Dr Vaclav Papez |
11:45-13:00 | Practical on previous session | Dr Vaclav Papez, Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo |
13:00-13:30 | Lunch | |
13:30-14:00 | Setting up a relational database | Dr Vaclav Papez/ Dr Arturo Gonzalez-Izquierdo |
14:00-14:30 | Practical on previous session | Dr Vaclav Papez, Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo |
14:30-14:45 | Coffee | |
14:45-15:15 | Administration | Dr Vaclav Papez/ Dr Arturo Gonzalez-Izquierdo |
15:15-16:05 | Practical on previous session | Dr Vaclav Papez, Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo |
16:05-16:30 | Summary and Q&A session | All |
Day 2
Time | Session | Tutor |
---|---|---|
9:30-10:30 | Basic SQL | Dr Arturo Gonzalez-Izquierdo |
11:30-12:30 | Practical on previous session | Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo, Dr Vaclav Papez |
12:30-13:30 | Lunch | |
13:30-14:00 | Intermediate SQL | Dr Arturo Gonzalez-Izquierdo |
14:00-15:00 | Practical on previous session | Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo, Dr Vaclav Papez |
15:00-15:15 | Coffee | |
15:15-16:50 | Practical on previous session | Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo, Dr Vaclav Papez |
16:50-17:00 | Summary and Q&A session | All |
Course Team
- 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 Associate Professor in Biomedical Informatics at the Institute of Health Informatics.
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 Vaclav Papez
- Václav has a background in computer science and software engineering. His PhD involved research into data modelling in the electroencephalography domain with a neuroinformatics research group at the University of West Bohemia, Czech Republic.
He recently 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.