Universidad de Jaén

Menú local

Syllabus 2018-19 - 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: 2018-19
SYLLABUS
1. COURSE BASIC INFORMATION
NAME: Database management and administration
CODE: 13312016 ACADEMIC YEAR: 2018-19
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
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

mandatory requirement is achieve a minimum score of 4 in the examination of the theory and practice exam.

-Part Daily attendance = percentage over 10 random  lectures to which the student attended. -The Scripts are delivered by way of exercises, be eligible if you attend class practices and the script is delivered in the set time. In case of failure to attend class practices will be necessary to make a defense of the script.

- The exercises will be held at the end of each topic and astudent chosen at random will be asked to resolve it. . Each exercise involves 0.1 points well resolved up to 0.5 points maximum


The grading system is expressed by numerical rating inaccordance with the provisions of art. D 5 R. 1125/2003, of 5September, by which the European credit system and the gradingsystem in the university degrees of official and valid in thecountry is established.

 

Passing both parts, theoretical and practical, are required to have successfully assimilated the learning outcomes 13 and 14

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)