| Educational guide School of Engineering |
english |
| Bachelor's Degree in Telematics engineering (2010) |
 Subjects |
| ORACLE DATABASE |
| Contents |
| IDENTIFYING DATA | 2015_16 |
| Subject | ORACLE DATABASE | Code | 17224221 | |||||
| Study programme |
|
Cycle | 1st | |||||
| Descriptors | Credits | Type | Year | Period | ||||
| 3 | Optional | 2Q |
||||||
| Competences | Learning outcomes | Contents |
| Planning | Methodologies | Personalized attention |
| Assessment | Sources of information | Recommendations |
| 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 |
