Universidad de Jaén

Menú local

Syllabus 2019-20 - 13312016 - Database management and administration (Gestión y administración de bases de datos)

Caption
  • Level 1: Tutorial support sessions, materials and exams in this language
  • Level 2: Tutorial support sessions, materials, exams and seminars in this language
  • Level 3: Tutorial support sessions, materials, exams, seminars and regular lectures in this language
DEGREE: Grado en Ingeniería informática
FACULTY: SCHOOL OF ENGINEERING OF JAÉN
ACADEMIC YEAR: 2019-20
COURSE: Database management and administration
SYLLABUS
1. COURSE BASIC INFORMATION
NAME: Database management and administration
CODE: 13312016 ACADEMIC YEAR: 2019-20
LANGUAGE: English LEVEL: 3
ECTS CREDITS: 6.0 YEAR: 3 SEMESTER: PC
2. LECTURER BASIC INFORMATION
NAME: MARTÍNEZ SANTIAGO, FERNANDO JAVIER
DEPARTMENT: U118 - INFORMÁTICA
FIELD OF STUDY: 570 - LENGUAJES Y SISTEMAS INFORMÁTICOS
OFFICE NO.: A3 - 110 E-MAIL: dofer@ujaen.es P: 953212888
WEBSITE: sinai.ujaen.es
ORCID: https://orcid.org/0000-0002-1480-1752
LANGUAGE: - LEVEL: 3
3. CONTENT DESCRIPTION

1. Server-side databases programming 

1.1. Basics of programming client / server

1.2. Scheduling constraints defining tables

1.3. Generating sequential numbers

1.4. Procedural extensions to SQL

1.5. Cursors

1.6. Stored Procedures

1.7. Triggers

1.8. Exception handling

1.9. The data dictionary

 

2. Management Database

2.1. The database administrator (DBA)

2.2. DBA functions

2. 3. Relational DBMS architecture

2.4. Management Tools

 

3. Database Security

3.1. Objectives and requirements

3.2. User Identification

3.3. Privilege Management

3. 4. Allocation and control of system resources

3.5. SQL Security

3.6. Views

 

4. Transaction Management

4.1. Concept of transaction and states

4.2. Storage Operations

4.3. Crash recovery based on log

4.4. Crash recovery in commercial DBMS

4. 5. Backups

 

PRACTICES

 

Practice 1. Client Programming: JDBC and Data Sources

   1.1  Introduction to JDBC

   1.2 Manipulación basic data withJDBC

  1.3 Introduction to Java Data Sources

Practice 2. Stored Procedures

           2.1.Defining blocks in PL / SQL

           2.2.Declaration of constants and variables

           2.3.Control Structures

            2.4.Declaration and use of cursors

            2.5.Using SELECT within a block

            2.6.Declaration and use of stored procedures and functions

 

Practice 3. Triggers and privileges

3.1. Declaration and use of triggers

3.2. Managing security roles and privileges

 

4. Practice Management databases

4.1 Installing DB

4.2 Data Distribution

4.3 Space Management

4.4 Definition and user access

4.5 Data Recovery 

4.5 Configuring the Database

5. DDBB optimization

5.1 DDBB Physical model

5.2 Query optimization

4. COURSE DESCRIPTION AND TEACHING METHODOLOGY

1. Lectures (theoretical-Lectures) (large group) Description:Presentation in the classroom of concepts of matter usingparticipatory methodology expository lectures and media. Evaluationand review of acquired skills. Purpose: To transmit the contents ofthe subject motivating students to reflection, facilitating thediscovery of relationships between different concepts and trainthem critical thinking

2. Practical activities (laboratory practicals) (small group)Description: Activities through which aims to show the students howto act on the application of the knowledge acquired Purpose:Development in students of instrumental skills The matter.

3. Seminars (small group) Description: organizational mode ofteaching and learning processes which deal in depth with a relatedsubject matter. It incorporates inquiry-based activities,discussion, reflection and exchange. Purpose: Development instudents of cognitive and procedural skills of matter.

4. No-class individual activities (Studio and self-employment)Description: 1) Activities (guided and unguided) proposed by theteacher through which individually and delves into specific aspectsof the subject enabling the student to move in acquisition ofcertain knowledge and procedures matter, 2) individualized study ofthe contents of the subject 3) evaluation activities (reports,surveys, etc) Purpose: To promote the student's ability toself-regulate their learning, planning it, by designing, evaluatingand adapting it to their particular conditions and interests.

5. No-class activities in group (Study and work in group)Description: Activities (guided and unguided) proposed by theteacher through which as a group and delves into specific aspectsof the subject allowing students to move in acquisition of certainknowledge and procedures matter. Purpose: To encourage students inthe generation and exchange of ideas, identification and analysisof different views on a topic, generalization or transfer ofknowledge and critical assessment of it.

Students with special educational needs should contact the Student Attention Service (Servicio de Atención y Ayudas al Estudiante) in order to receive the appropriate academic support

5. ASSESSMENT METHODOLOGY

-Theory and practice exam (5 points each) It is mandatory to achieve a minimum score of 4 out of 10 on the theory and practice exam.

The following aspects will be considered for the benefit of the student, up to a maximum of two additional points on the score obtained from the sum of the theory and practice examination

  • Participation in theory classes
  • Exercises at the end of each theme
  • Realization of practice scripts
  • Accomplishment of some work related to the subject and its presentation in class.

6. BOOKLIST
MAIN BOOKLIST:
  • Fundamentals of database systems. Edition: 6th ed. Author: Elmasri, Ramez. Publisher: Harlow : Pearson, cop. 2014  (Library)
  • Database: system concepts. Edition: 6th ed.. Author: Silberschatz, Abraham. Publisher: New York : McGraw-Hill, c2011  (Library)