Databases and Information Analysis

Year
0
Academic year
2020-2021
Code
02007957
Subject Area
Biomedical Engineering
Language of Instruction
Portuguese
Other Languages of Instruction
English
Mode of Delivery
Face-to-face
Duration
SEMESTRIAL
ECTS Credits
6.0
Type
Elective
Level
2nd Cycle Studies - Mestrado

Recommended Prerequisites

Basic programming.

Teaching Methods

Exposure of subjects and questions in the theoretical class

Practical exploration in lab classes, using exercises with solutions.

Projects and their accompaniment.

Learning Outcomes

This course is primarily a basic course in the construction and use of databases. Databases are an essential component of computer systems. In addition to the fundamentals of relational databases, including relational model, relational operations, SQL language, it is intended to operationalize these concepts through the analysis, design and practical construction of databases.

Today, knowledge is also an asset to organizations. The ability to save, manage, and analyze data to gain insight is essential. It is also the objective of this curricular unit to assign competences to students in the area of information analysis. It is intended to learn how to deal with any amount of data by organizing and analyzing this data using forms of programming.

Work Placement(s)

No

Syllabus

* Databases

Entity-relationship and relational models

Designing databases

SQL

Using and programming over SQL databases

Using and programming over NoSQL databases

* Data analysis

Multi-dimensional data, processing

Summarizing, statistics, aggregations, charts, visualization

Using classification, clustering, regression and other forms of analisys.

Assessment Methods

Assessment
Project: 40.0%
Exam: 60.0%

Bibliography

Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom, Database Systems: The Complete Book, Prentice Hall, 2001
R. Ramakrishnan, Johannes Gehrke, Database Management Systems, McGraw Hill, 2002

Professor notes on analysing and visualizing data

Python programming manuals

Alex Berson, Stephen J. Smith, Data Warehousing, Data Mining, and OLAP, Computing Mcgraw-Hill, 1997