Checking date: 20/05/2022

Course: 2022/2023

Database and Datawarehouse
Study: Master in Computer Technologies Applied to the Financial Sector (313)


Department assigned to the subject: Department of Computer Science and Engineering

Type: Additional training
ECTS Credits: 3.0 ECTS


Requirements (Subjects that are assumed to be known)
Programming basic skills
+ Understand the fundamentals of transactional databases + Ability to implement simple relational databases + Understand the management of information in a relational database + Understand the fundamentals of Data Warehouses
Skills and learning outcomes
Description of contents: programme
Transactional databases - Design and implementation of relational databases - Information management in a relational database DataWarehouse - Data Warehouse: definition and characteristics - Analytical SQL
Learning activities and methodology
LEARNING ACTIVITIES AF1 Theoretical presentations through on-line synchronous teaching supported by electronic material, such as digital presentations [7 hours, 0% presential] AF2 E-learning activities [11.5 hours, 0% presential] AF3 Theoretical-practical classes through on-line synchronous teaching [3.5 hours, 0% presential] AF4 Laboratory practices [10 hours, 0% presential] AF5 Tutoring sessions [3.3 hours, 0% presential] AF7 Individual student work [40 hours, 0% presential] TEACHING METHODOLOGIES - MD1: Lectures in class (on line synchronous teaching) by the teacher with computer and audiovisual media support, in which the main concepts of the subject are developed and the bibliography is provided to complement the students' learning. - MD2: Critical reading of texts recommended by the lecturer: press papers, reports, manuals and / or academic papers, either for later discussion in class, or to expand and consolidate knowledge of the subject. - MD3: Resolution of practical cases, problems, etc.¿ raised by the teacher individually or in teams. - MD4: Presentation and discussion in class, under the moderation of the teacher, of topics related to the content of the subject, as well as practical cases. - MD5: Preparation of work and reports individually or in teams. - MD6: Specific e-learning activities, related to the semi-presential nature of the degree, including viewing of recorded content, self-correction activities, participation in forums, and any other online teaching mechanism.
Assessment System
  • % end-of-term-examination 40
  • % of continuous assessment (assigments, laboratory, practicals...) 60
Calendar of Continuous assessment
Basic Bibliography
  • Elmasri, R. y Navathe, S.. Fundamentals of Database Systems (7th ed.). Pearson Education. 2017
  • Silverschatz, A., Korth, H. F. y Sudarshan, S.. Database System Concepts, 7th ed . Mc-Graw Hill. 2019
Recursos electrónicosElectronic Resources *
(*) Access to some electronic resources may be restricted to members of the university community and require validation through Campus Global. If you try to connect from outside of the University you will need to set up a VPN

The course syllabus may change due academic events or other reasons.