This site uses cookies

Some of these cookies are essential, while others help us to improve your experience by providing insights into how the site is being used.

For more detailed information please check our Cookie notice

Necessary cookies

Necessary cookies enable core functionality. This website cannot function properly without these cookies.

Cookies that measure website use

If you provide permission, we will use Google Analytics to measure how you use the website so we can improve it based on our understanding of user needs. Google Analytics sets cookies that store anonymised information about how you got to the site, the pages you visit, how long you spend on each page and what you click on while you’re visiting the site.

UK Data Service Logo

SQL Database Management Software

30 Jan 2018 12:00 am
Training
Data skills
Other

Event 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

 

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

 

Learning Outcomes

By the end of the course participants will:

  • understand the relational data model, data types and basic data modeling techniques
  • learn how to pre-format and load their data in a database system
  • learn how to create simple and complex queries using SQL

Presenters

Dr Spiros Denaxas, Dr Arturo Gonzalez-Izquierdo

More information regarding our ADRC-England courses can be found here. 

Podcast for some of our previous courses can be found here.

Event resources

Book a place here