Databases and Information Analysis
0
2020-2021
02007957
Biomedical Engineering
Portuguese
English
Face-to-face
SEMESTRIAL
6.0
Compulsory
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)
NoSyllabus
* 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.
Head Lecturer(s)
Pedro Nuno San-Bento Furtado
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