Introdução às Bases de Dados Clínicas

Basic knowledge of informatics

Theoretical Lectures: The theoretical lectures will be used to present the fundamental concepts related to clinical data and the principles of database management systems. They will be supported by audiovisual resources, presentations, and practical examples.

Laboratory Classes: The laboratory classes are of a practical nature and aim to allow students to apply the theoretical concepts learned in the theoretical lectures. They consist of practical exercises related to the design, implementation, and analysis of clinical databases.

By the end of this course, you should be able to:

• Understand concepts related to clinical data
• Explain the basic principles of database management systems
• Plan, implement, and maintain a clinical database
• Extract and analyze clinical data 
• Evaluate the quality and reliability of clinical data
• Be aware of ethical and legal issues related to the use of clinical data
• Present clinical data

1. Introduction to Databases

1.1 Concepts

1.2 Information Representation

1.3 Relational Model

1.4 Entity-Relationship Model

2. Domains and Relationships

2.1. Domains

2.2. Relations

2.3. Types of Relations

2.4. Relations and Predicates

3. Relational Data Integrity

3.1. Candidate Keys

3.2. Primary Keys and Alternate Keys

3.3. Foreign Keys

4. The SQL Language

4.1. Basic Concepts of SQL

4.2. Relational Algebra

4.3. SQL Functions

4.4. Sorting and Grouping

4.5. Subqueries

4.6. Table Management

4.7. Entity, Referential, and Field Integrity Constraints

4.8. Data Visualizations and Manipulation

5. The Clinical Process

6. GDPR in Healthcare

-

Practical Work to be carried out individually outside of class and with mandatory defense: 8 points with a minimum of 35% to be admitted to the exam;

Written Exam: 12 points, with a minimum of 35% to pass the course - only students who obtain at least 35% in the Practical Work will be admitted to the exam.

The practical work will consist of carrying out a practical assignment based on a statement provided by the professor, to be done individually, with the delivery and defense dates indicated on a form in the course's Moodle. Failure to submit the practical work within the deadline defined and indicated in Moodle, or failure to defend it, will result in a grade of 0% for that part of the assessment. There will only be one delivery date for the practical work, which is the one shown in Moodle; there will be no later dates for defense or later statements for the Practical Work.

NAO