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

Basic knowledge of mathematics and biology.

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 Clinical Data

• What are clinical data?
• Importance of clinical data
• Sources of clinical data
• Ethical and legal issues related to the use of clinical data

2. Principles of Database Management Systems

• Introduction to database systems
• Data models and database design
• Relational database systems
• SQL and database querying

3. Database Design

• Requirements gathering and specification
• Conceptual, logical, and physical database design
• Data normalization and denormalization
• Indexing and query optimization

4. Implementation and Maintenance of Databases

• Implementation and testing
• Data validation and quality control
• Backup and recovery
• Database security and access control

5. Data Extraction and Analysis

• Data extraction and transformation
• Data analysis and visualization
• Statistical analysis
• Machine learning techniques

NAO

• Miniati, R., Iadanza, E., & Dori, F. (2016). Clinical engineering: From devices to systems. Amsterdam [etc.]: Academic Press.
• Saltzman, W. (2009). Biomedical engineering: Bridging medicine and technology. Cambridge [etc.]: Cambridge University Press.
• Rob, P., & Coronel, C. (2009). Database systems: Design, implementation, and management (8th ed.). Australia [etc.]: Thomson Course Technology.
• Najarian, K., & Splinter, R. (2006). Biomedical signal and image processing. Boca Raton [etc.]: Taylor & Francis.
• Enderle, J. D., Blanchard, S. M., & Bronzino, J. D. (2005). Introduction to biomedical engineering (2nd ed.). Amsterdam [etc.]: Elsevier.