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.
Target Audience:-
Course suitable for Epidemiologists, medical statisticians and other researchers working with electronic health records data.
Prerequisites:-
Some experience of working in a statistical package. Participants will have to sign confidentiality and data use agreements at the start of the course.
Course Code ADRCE-training035 Denaxas
Course Date 28th June 2017
Places Available 10
Course Leader Dr Spiros Denaxas
Course Description
Course Contents:
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.
By the end of the course, participants will
a) understand the relational data model, data types and basic data modeling techniques
b) learn how to pre-format and load their data in a database system
c) learn how to create simple and complex queries using SQL
Further information can be found at:-
http://www.ncrm.ac.uk/training/show.php?article=6971
Course Fee:
The fee per day is:
1.£30 - For UK registered postgraduate students
2.£60 - For staff at UK academic institutions, Research Council UK funded researchers, UK public sector staff and staff at UK registered charity organisations
3.Free place for ADRC/ADRN/ADS staff
4.£220 - For all other participants
All fees include event materials, lunch, morning and afternoon tea. They do not include travel and accommodation costs.
Course places are limited and registration by 20th June 2017 is strongly recommended.
Location
Farr Institute
LocationFarr InstituteVenue Details
Farr Institute
222 Euston Road
London
NW1 2DA
Contact Information
email: ADRCE@soton.ac.uk