SkillsCourses

Clinical Databases

2 Modules

1 Hour

EQF-Level: 5

About

Learning Outcomes

Modules

Back to BeWell

About the course

Target group

Physicians, Technicians

Key words

, , ,

Course introduction

The aim of this course is to improve skill and competences of medical professionals in clinical digital data management. Today almost all clinical activities generate data stored in hospital computer systems. There is an important need, by these professionals, to better know how clinical data are stored and how it can be retrieved retrieved. This knowledge is fundamental to plan data extraction from memory storage, data analysis and knowledge generation that can be obtained from clinical data routinely generated and stored in clinical data storage systems. The aim of this module is to provide the instruments for understanding the most popular system for data storage and the related strategies to perform queries to access data clinical databases and to analyze clinical data. In the course examples on the use of database management systems is provided. This knowledge can directly or indirectly improve routine clinical work, since data analysis is the basis for taking decisions on a routine base. The knowledge on the management of clinical data may improve the clinical outcome and the efficacy of clinical activities, as well as reduce clinical costs. 

Details to know

Downloadable certificate

Share your certificate on Linkedin

Assessment

5 Quizzes

Taught in English

Only available in English

Learning outcomes

After successfully completing this Course, the learner will be to 

  • Know the structure of a data set used to store clinical data 
  • Know the structure of a table, record and field in database 
  • Know what a relational database is 
  • Know which is the software most frequently used to store/extract clinical data 
  • Know how to install and use a database management software on a PC 

After successfully completing this Course, the learner will be able to 

  • Visualize a data set or table of a relational data base 
  • Put in relation data from different table in a database 
  • Select data from a database 
  • Select data from different tables in a relational database 
  • Export data from a database to a spread sheet 
  • Analyse data extracted from a clinical database 

More detailed Learning Outcomes can be found in module introductions.

Clinical Databases 1

This module enhances medical professionals’ skills in clinical digital data management, focusing on retrieving, accessing, and extracting relevant data from healthcare databases. It equips them with tools to analyze and navigate clinical data, improving their ability to use it effectively for patient care and healthcare administration.

Lessons

Module Introduction 1. Introduction 2. Clinical Databases 3. Database Management Systems 4. Database queries 1

Clinical Databases 2

The second module teaches practical skills for inspecting and extracting data from large clinical databases. Trainees will learn to navigate datasets, use SQL for querying, and extract data for analysis in spreadsheet tools like Excel, enabling them to assess data quality and relevance effectively.

Lessons

Module Introduction 1. Database queries 2 2. Data extraction Course Evaluation

Back to top

Co-funded by the Erasmus+ programme of the European Union under Grant Agreement number 101056563.

Co-funded by the European Union. Views and opinions expressed are however those of the author(s) only and do not necessarily reflect those of the European Union or EACEA. Neither the European Union nor the granting authority can be held responsible for them.