IDENTIFYING DATA 2015_16
Subject (*) ORACLE DATABASE Code 17224221
Study programme
Bachelor's Degree in Telematics engineering (2010)
 Cycle 1st
Descriptors Credits Type Year Period
3 Optional 2Q
Language
Català
Department Enginyeria Informàtica i Matemàtiques
Coordinator
PLANA GAVALDÀ, GABRIEL
 E-mail gabriel.plana@urv.cat
Lecturers
PLANA GAVALDÀ, GABRIEL
Web
General description and relevant information This subject improves the knowledgement learnt on the previous subject "Database" and focus specially on Optimization, development in PL/SQL and Administration of an Oracle database. This subject is teached in catalan.

Competences
Type A Code Competences Specific
 CM12 Have knowledge of and apply the characteristics, functions and structure of databases, for their appropriate use, and the design, analysis and implementation of applications based on them.
Type B Code Competences Transversal
Type C Code Competences Nuclear

Learning outcomes
Type A Code Learning outcomes
 CM12 Knows which specific aspects differentiate Oracle from other database management systems
Knows and understands the most important aspects of optimising a database.
Can apply the concepts of transactions and understands the problems that arise from not using them correctly.
Can apply PL/SQL language in situations that require it.
Knows the basic aspects of administering an Oracle database.
Type B Code Learning outcomes
Type C Code Learning outcomes

Contents
Topic Sub-topic
1. Introduction Presentation of the subject
Remembering of SQL
2. Oracle environment Introduction to the Oracle environment
SQL-Plus
SQL-Developer
3. Optimitation Introduction
Semantic, Syntactic and physical optimization
Access paths and índexes
4. Transactions Remembering of transaccions
The ACID concept
Isolation levels
Transaction Optimization
5. PL/SQL Triggers and sequences
Functions and Procedures
Packages
6. Administració Oracle Introduction
Security, users, schemas and privileges
Views and synonyms

Planning
Methodologies  ::  Tests
  Competences (*) Class hours
 Hours outside the classroom
 (**) Total hours
Introductory activities
2 4 6
Lecture
CM12
 10 10 20
Practicals using information and communication technologies (ICTs) in computer rooms
CM12
 12 8 20
ICT practicals
CM12
 1 10 11
Personal tuition
1 1 2
 
Objective short-answer tests
CM12
 4 12 16
 
(*) On e-learning, hours of virtual attendance of the teacher.
(**) The information in the planning table is for guidance only and does not take into account the heterogeneity of the students.

Methodologies
Methodologies
  Description
Introductory activities Objectives and motivation of the subject will be explained. Also some previous concepts will be reviewed.
Lecture Main concepts of this subject will be explained; theory concepts as well as some specific Oracle things.
Also, some examples will be shown to reinformce the theorical explanations.
Practicals using information and communication technologies (ICTs) in computer rooms Some practicum will be done using the Oracle environment, where students will be able also to practice the concepts learned.
ICT practicals Students will have to make a practicum during the course. This practicum will summarize the concepts of the subject.
Personal tuition Students will be able to send e-mails to the teacher with their doubts. Also, if necessary, students will be able to ask for personal twition asking for an appointment by e-mail.

Personalized attention
Description
Students will be able to ask questions by e-mail. In case the student needs personalized attention on the teacher office, it is necessary to arrange an appointment.

Assessment
Methodologies Competences Description Weight        
ICT practicals
CM12
 It will be necessary to make a practicum using Oracle. This practicum will summarize the concepts learnt during the course. 50%
Objective short-answer tests
CM12
 Two tests will be done during the course. Each test will have the same weight on marks. 50%
Others  

In some cases it will be possible to do some extra work in order to improve the marks.
 
Other comments and second exam session

Student will need a minimum of 5 marks on the tests to pass this subject.

Student will need a minimum of 4 marks on the practicum to pass this subject.

In case student don't get enaugh marks to pass, he will be able to go to second call just for the parts where he/she had failed.

Sources of information

Basic Jaume Sistac, Dolors Costal, , Tècniques avançades de bases de dades, última disponible, http://books.google.es/books/about/T%C3%A8cniques_
Jaume Sistac, Sistemes de gestió de bases de dades, última disponible, http://books.google.es/books?id=CD5kjkmprXYC&p

Complementary Michael McLaughlin, Oracle Database 11g PL/SQL Programming, Última disponible, Oracle PRess
Bob Bryla, Kevin Loney, Oracle Database 11g DBA Handbook, Última disponible, Oracle Press
Jason Price, Oracle Database 11g SQL, Última disponible, Oracle PRess

Recommendations


Subjects that it is recommended to have taken before
DATABASES/17234103
 
Other comments
Per tal de poder realitzar aquesta assignatura convé haver cursat prèviament l'assignatura de Bases de Dades.
(*)The teaching guide is the document in which the URV publishes the information about all its courses. It is a public document and cannot be modified. Only in exceptional cases can it be revised by the competent agent or duly revised so that it is in line with current legislation.