Checking date: 10/05/2024


Course: 2024/2025

Database and Datawarehouse
(18851)
Master in Financial Sector Technologies: FinTech (Plan: 461 - Estudio: 313)
EPI


Coordinating teacher: CALLE GOMEZ, FRANCISCO JAVIER

Department assigned to the subject: Computer Science and Engineering Department

Type: Additional training
ECTS Credits: 3.0 ECTS

Course:
Semester:




Requirements (Subjects that are assumed to be known)
Programming basic skills
Objectives
+ Understand the fundamentals of transactional databases + Understand the management of information in relational databases + Understand the fundamentals of Data Warehouses + Ability to implement simple relational databases + Ability to develop queries on relational databases + Acquire basics of SQL
Skills and learning outcomes
Description of contents: programme
Transactional databases - Design and implementation of relational databases - Information management in a relational database DataWarehousing - Data Warehouse: definition and characteristics - Loading data into a Datawarehouse - 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 50
  • % of continuous assessment (assigments, laboratory, practicals...) 50

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.