This event has passed.

SQL for Biomedical Researchers

Name: SQL for Biomedical Researchers
Start: 2019-11-05T00:00:00+00:00
End: 2019-11-06T23:59:59+00:00

5th November 2019 - 6th November 2019

SQL for Biomedical Researchers
Course Code	HUB-17-18/19-P-R
Organised by	NCRM, University of Southampton
Presenter	Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo and Dr Vaclav Papez
Date	05/11/2019 – 06/11/2019
Venue	UCL Institute of Health Informatics, Health Data Research UK, 222 Euston Road, London
Map	View in Google Maps (NW1 2DA)
Contact	Jacqui Thorp NCRM Training and Capacity Building Co-ordinator Tel: 02380 594069 Email: [email protected]
Description	Database systems are increasingly being used for working with medical data and enable the rapid querying of complex data in health and social care. This short course will introduce the theory behind the relational data model and enable participants to gain an understanding on how data can be modelled and stored in a relational database system and what different data types are used. Through a series of practical-driven sessions using real-life data, students will learn how to load existing data in a contemporary relational database management system and how to craft simple and complex queries for analysing the data. By the end of the course, students will be able to load, format and export data in a format suitable for analysis by common statistical packages. The course covers: Introduction to relational database management systems (RDBMS) Relational database modelling, conceptual database design The case of electronic health records Setting up a relational database Database administration Database querying: Basic SQL Intermediate SQL By the end of the course participants will: Understand the relational data model, data types and basic data modelling techniques Learn how to pre-format, load and setup their data in a database system Learn how to create simple and complex queries using SQL This course is suitable for Epidemiologists, medical statisticians and other researchers working with electronic health records data.
Level	Entry (no or almost no prior knowledge)
Cost	The fee per teaching day is: • £30 per day for UK/EU registered students • £60 per day for staff at UK/EU academic institutions, UK/EU Research Councils researchers, UK/EU public sector staff and staff at UK/EU registered charity organisations and recognised UK/EU research institutions. • £220 per day for all other participants All fees include event materials, lunch, morning and afternoon tea. They do not include travel and accommodation costs. A full refund is available two weeks prior to the course, NO refunds are available after this date.
Website and registration	http://go.soton.ac.uk/aei
Region	Greater London
Keywords	Data Management , SQL , , Database Modelling , , Electronic Health Records , , Relational databases , , Data Curation
Related publications and presentations	Data Management

Details

Start:: 5th November 2019
End:: 6th November 2019