Base Knowledge
Students should master the concepts of relational databases (SQL Language, ER Models, and Transactions).
It is recommended the completion of the following course:
– Databases.
Teaching Methodologies
The following teaching methodologies are used in this course:
1 – Expository method: explanatory method where theoretical foundations and concept are presented by the teacher and discussed with the class, followed by demonstrative examples;
2 – Experimental method: active method where the student develops knowledge through problem solving and the development of individual laboratory projects or group dynamics, being the predominant method.
Each class will consist of two moments:
1 – Introductory presentation: At the beginning of the class, the teacher exposes and discusses the new contents under study with the students;
2 – Practical application: After the introductory presentation, students develop work assignments and programming projects, individually and together, for the practical application of new concepts, independently and under the guidance of the teacher.
Learning Results
It is expected that at the end of the curricular unit the student will be able to:
1. Identify the physical aspects of databases and acquire skills for their administration;
2. Identify and apply data exploration and data analysis techniques;
3. Design and develop approaches to data transformation and analysis;
4. Program a database server using the PL/SQL language.
Program
- DBMS architecture
- PL/SQL (Data Types, Structures, Exceptions, Cursors, Triggers, Procedures, Functions and Views)
- Database project development
- Data Storage and Physical Parameters
- Query optimization and Indexing
- Database administration and security concepts
- Introduction to Data Analysis (OLAP, ROLAP and MOLAP; Data Warehousing; Multidimensional Databases; ETL Process; Data Preparation; Data Mining Concepts)
Curricular Unit Teachers
Gonçalo Miguel Santos MarquesGrading Methods
1 - Periodic Evaluation:
a) practical assignments (50%);
b) an individual written test (50%)
2 - Exam Evaluation:
a) an individual written test (75%)
b) practical assignments (25%)
General Rules:
There is a minimum 45% value for each evaluation element in all evaluation periods.
The practical assignments are followed by an oral presentation to the discipline's teacher for individual validation, defense, and discussion of the options implemented.
Each evaluation period is independent of the remaining evaluation periods, presenting specific assignments, distinct from the remaining evaluation periods.
The practical assignments must be carried out exclusively during the teaching period. Failure to obtain a minimum score of 45% in practical group assignments will result in the student not being admitted to the Evaluation by Exam, with the consequent failure of the curricular unit.
Internship(s)
NAO
Bibliography
Caldeira, C. (2012). Data warehousing – Conceitos e modelos. Edições Silabo.
Coronel, C. & Morris, S. (2019) Database Systems: Design, Implementation, and Management (13th ed.)., Cengage Learning.
Gama, J., Lorena, C., Faceli, K., Oliveira, M., & Carvalho, A. (2017). Extracção de conhecimento de dados: Data mining (3th ed.). Edições Sílabo.
Garcia-Molina, H. (2014). Database systems: The complete book. Prentice Hall.
Han, J., Kamber, M., & Pei, J. (2011). Data mining: Concepts and techniques (3th ed.). Morgan Kaufmann.
Kimball, R., & Ross., M. (2013). The data warehouse toolkit: The complete guide to dimensional modeling. J. Wiley & Sons.
Santos, M., & Ramos, I. (2017). Business intelligence: Da informação ao conhecimento (3th ed.). FCA.
Silberschatz, A., Korth, H. F., & Sudarshan, S. (2019). Database System Concepts (7th ed.). McGraw-Hill.
Witten, I., & Frank, E. (2016). Data mining: Practical machine learning tools and techniques (4th ed.). Morgan Kaufman.