Checking date: 20/05/2022


Course: 2022/2023

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


Coordinating teacher: CALLE GOMEZ, FRANCISCO JAVIER

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

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 + 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.