Databases and Information Analysis

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.

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