Universidad de Jaén

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 with JDBC

  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

Data Recovery 4.5

4.5 Configuring the Database

1. Lectures (theoretical-Lectures) (large group) Description: Presentation in the classroom of concepts of matter using participatory methodology expository lectures and media. Evaluation and review of acquired skills. Purpose: To transmit the contents of the subject motivating students to reflection, facilitating the discovery of relationships between different concepts and train them critical thinking

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

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

4. No-class individual activities (Studio and self-employment) Description: 1) Activities (guided and unguided) proposed by the teacher through which individually and delves into specific aspects of the subject enabling the student to move in acquisition of certain knowledge and procedures matter, 2) individualized study of the contents of the subject 3) evaluation activities (reports, surveys, etc) Purpose: To promote the student's ability to self-regulate their learning, planning it, by designing, evaluating and 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 the teacher through which as a group and delves into specific aspects of the subject allowing students to move in acquisition of certain knowledge and procedures matter. Purpose: To encourage students in the generation and exchange of ideas, identification and analysis of different views on a topic, generalization or transfer of knowledge 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

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

-Part Daily attendance = percentage of lectures to which we have 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 a student chosen at random will be asked to resolve it. . Each exercise involves 0.5 points well resolved, and poorly resolved -0.5 points (always bounded the final note of this section to the interval between 0 and 1 point

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

 

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