SQL Database Management Software (join a waiting list)

Description:

Course number: ADRCE-training035 Denaxas 

NOTE: THIS COURSE IS NOW FULLY BOOKED AND THE ON-LINE BOOKING SYSTEM HAS BEEN CLOSED. YOU CAN JOIN OUR WAITING LIST.

Summary of Course:

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 contemproary 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

Course Contents:

• Introduction to course and main objectives
• Introduction to contemporary relational database management systems (RDBMS),    main components of architecture
• Critical appraisal for RDBMS’s, comparison with traditional file-based approaches
• Relational modelling and algebra, conceptual database design

• Main RDBMS data types, choosing the right data type for the right field
• Data definition SQL: create, describe, select...
• Simple SELECT queries across single tables, SORT, GROUP
• Basic error checking

• Multi-table queries
• Creating custom reports
• Combining results (UNION, INTERSECT)
• UPDATE
• Subqueries
• INDEX

• Entities
• Attributes
• Relationships

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

Computer Software and Computer workshops:

This is a computer laboratory based course

Presenters:

Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo, Harry Boutselakis, Dr Kenan Direk

Target Audience:

Epidemiologists, medical statisticians and other researchers working with electronic health records data

Pre-requisites:

Some experience of working in a statistical package. Participants will have to sign confidentiality and data use agreements at the start of the course.

Provisional Programme

Time                  Title of session:                                                      

09:00-09:30         Registration and coffee

09:30-10:30         Session #1: Introduction                                    

Coffee       

10:45-11:30         Session #2: Basic SQL                                           

11:30-12:30         Session #3: Practical on previous session    

Lunch         

13:30-14:00         Session #4: Intermediate SQL                          

14:00-15:00         Session #5: Practical on previous session    

Coffee       

15:15-16:00         Session #6: Relational database modelling 

16:00-16:50         Session #7: Practical on previous session    

16:50-17:00         Summary and Q&A session              

Course Materials:

Participants will receive written course notes.

Podcast

Podcasts for some of our previous courses can be found at https://adrn.ac.uk/about/network/england/training-podcasts/

--

Our courses are very popular and are often oversubscribed. If you cannot attend a course you have registered for, it is essential to kindly notify us a minimum of 30 days in advance so that your place can be released for another attendee. Details of our cancellation policy are here: http://store.southampton.ac.uk/help/?HelpID=1 . Please see our full course list here: http://store.southampton.ac.uk/browse/product.asp?compid=1&modid=5&catid=113.

Cost:

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.

Website and registration:

Region:

Greater London

Keywords:

Data Management , SQL, RDBMS data types, SELECT, SORT Group, UPDATE, INDEX, Relational Database Modelling

Related publications and presentations from our eprints archive:

Data Management

Back to the training database