Degree in Health Engineering La Salle Campus Barcelona

Degree in Health Engineering

Lead the technological advances that will define the medicine of the future.

Databases

Description
This subject covers everything related to the management and storage of structured data. It includes everything from how a database is designed through its implementation and use to filter and/or order and/or store information optimally, emphasizing applications for health engineering.
Type Subject
Tercer - Obligatoria
Semester
First
Course
3
Credits
6.00
Previous Knowledge

There are no prerequisites.

Objectives

Students acquire the knowledge and develop the skills indicated below:
1. Necessary concepts for the design and administration of relational databases are obtained.
2. Learn to design a database using different models.
3. Learn how to implement a database.
4. Know how to save and how to extract information from a database.
5. Know the tools to perform advanced queries and operations.
6. Know the Organic Law on Data Protection at the level of databases.

Contents

1. Introduction to Databases.
2. Conceptual model.
3. Relational model.
4. Physical model.
5. Advanced SQL.
6. Data control language.
7. Stored procedures .
8. Triggers and events.
9. NoSQL Systems.
10. Security and SQL Injection

Methodology

The subject bases learning on the following teaching methodologies:
- Theoretical classes.
- Problem classes and exercises.
- Laboratory practices.
- Flipped classroom .
-Peer instruction .

Evaluation

See electronic folder of the subject.

Evaluation Criteria

See electronic folder of the subject.

Basic Bibliography

See electronic folder of the subject.

Additional Material

See electronic folder of the subject.