ECTS credits ECTS credits: 4.5
ECTS Hours Rules/Memories Student's work ECTS: 74.2 Hours of tutorials: 2.25 Expository Class: 18 Interactive Classroom: 18 Total: 112.45
Use languages Spanish, Galician
Type: Ordinary Degree Subject RD 1393/2007 - 822/2021
Center Higher Technical Engineering School
Call: First Semester
Teaching: Sin Docencia (En Extinción)
Enrolment: No Matriculable (Sólo Alumnado Repetidor)
The objective of this course is to teach the students the common tasks performed by the administrators of a Database Management System (DBMS). Specific objectives are to guarantee operations and availability of data, to manage security and data integrity, and to improve the overall performance of the system.
Contribution to obtain and develop the following competences of the Degree in Computer Engineering of the USC (CG6, CG8, CG9, CG10, TR1, TR2, TR3, RI5, RI7, RI12, RI13, TI5 and TI7)
Within the module of Information Systems, this course develops the following competences: to manage database systems using SQL, to develop applications using databases, to learn the fundamentals of managing DBMS, to install and configure DBMSs, to know how to manage database security and recovery, and to be able to adjust and monitor a DBMS.
Part 1. Introduction
a. DBMS installation
b. Selection and Configuration
c. DBA tools
Part 2. Performance
a. Managing data storage structures
b. BMS monitoring and performance tuning
Part 3. Security
a. Managing security and database integrity
b. Encryption
c. Privileges, users and roles.
Part 4. Backups
a. Backup policy
b. Data Recovery
c. Disaster prevention
Basic:
Mullins, Craig S. Database Administration: The Complete Guide to DBA Practices and Procedures. 2ª Edición, Estados Unidos: Addison-Wesley, 2012. ISBN: 978-03-2182-294-9.
Elmasri, Ramez, Navathe, Shamkant B. Fundamentos de Sistemas de Bases de Datos. 5ª Edición, Madrid: Addison-Wesley, 2008. ISBN 978-84-7829-085-7.
ORACLE, Database Administrator’s Guide (11g Release 2). Disponible online en https://docs.oracle.com
PostgreSQL 9.6.3 Documentation. Disponible online en https://www.postgresql.org
Complementary:
Connolly, Thomas M., Begg Carolyn E. Sistemas de bases de datos : un enfoque práctico para diseño, implementación y gestión. 4ª Edición, Madrid: Pearson, Addison-Wesley, 2005. ISBN 84-7829-075-3.
Students will acquire advanced knownledge needed to efficiently operate a DBMS. They will learn how to install and configure a DBMS, will improve the skills required to manage and maintain a database, will significantly enhance their abilities to manage security and data recovery, and will effectively tune the database performance and extend the monitoring capabilities.
This course will allow to achieve and develop the following competences of the Degree in Computer Engineering of the USC: CG6, CG8, CG9, CG10, TR1, TR2, TR3, RI5, RI7, RI12, RI13, TI5 and TI7.
Within the Information Systems module, the course develops the following competences: to manage DBMSs with SQL, to develop applications accessing databases, to learn how to manage DBMSs, to install and configure a DBMS, to perform security and recovery tasks on DBMSs and DBMS' tuning and monitoring.
This course combines advanced database administration theory with practical hand-ons training. The latter will be done either individually or in small groups. PBL (Problem-based Learning) and CBL (Case-based Learning) methodologies will be applied during this stage, with the objective of developing transversal competences (instrumental, personal and systemic).
Lecture classes will allow to develop the following competences: CG8, CG9, CG10, TR1, TR3, RI7, RI12, RI13, TI5 and TI7.
Practical assignments will allow to work the following competences: CG6, CG9, CG10, TR1, TR2, TR3, RI5, RI7, RI12, RI13, TI5 e TI7.
Two types of assessments: student's performance will be evaluated by continuous assessment throughout the semester and a final exam. Students must pass both components to pass the course.
A final exam will account for 30% of the course grade and will provide information about the level of achievement of competences CG8, CG9, CG10, TR1, TR3, RI7, RI12, RI13, TI5 and TI7.
Practical assigments will account for 70% of the course grade and will allow to assess the various levels of achievement of the various types of competences: CG6, CG9 and CG10 (generic); TR1, TR2 and TR3 (transversal), RI5,RI7, RI12 and RI13 (computer science), and TI5 and TI7 (information tecnologies).
Only students who presented the practical component during the semester the course is taught will be able to pass the course during the extraordinary July assessment period.
The condition of submission for assessment will be given to any student who either submit a minimum of 40% of the practical work or take any of the exams.
Marks will not be kept among assessment periods of different courses. Consequently, repeaters will be evaluated similarly to first time enrolled students.
Each hour of class time approximately will require 1.5 hours of personal work.
Bases de Datos I and Bases de Datos II
Joaquín Ángel Triñanes Fernández
- Department
- Electronics and Computing
- Area
- Languages and Computer Systems
- Phone
- 881816001
- joaquin.trinanes [at] usc.es
- Category
- Professor: Temporary PhD professor
| 01.24.2023 16:00-20:45 | Grupo de examen | rest room / dining room |
| 06.20.2023 16:00-20:45 | Grupo de examen | rest room / dining room |