Databases and Information Analysis
2nd Cycle Studies - Mestrado
Exposure of subjects and questions in the theoretical class
Practical exploration in lab classes, using exercises with solutions.
Projects and their accompaniment.
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.
Entity-relationship and relational models
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.
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