Bases de Dados II

Knowledge equivalent to that acquired in the Databases 1 course unit.

Theoretical classes: Exposition of theoretical concepts, accompanied by practical examples.

Practical classes: Hands-on exercises in an Oracle SQL Developer environment, with provided exercise sheets.
Phased development and support for the practical project.

Upon completion of the course unit, students should be able to:

Develop robust PL/SQL applications for server-side data processing.
Understand and apply database tuning and optimization techniques.
Plan and execute critical administration operations, such as backup and recovery.
Model and implement complex and efficient relational schemas.
Critically analyze data management solutions and justify technical decisions.

1. Introduction and Review of concepts;

2. PL/SQL Programming: Cursors, Exceptions, Procedures, Functions, Triggers, Packages;

3. Architecture of an Oracle DBMS;

4. Management of Physical Parameters and Storage Structures;

5. Data Partitioning Strategies;

6. Data Backup and Recovery Operations;

Assessment in this course unit is continuous, consisting of two assessment elements with the following weightings:

Theoretical Tests (60%): Two written tests will be held, each with a weighting of 6 values (for a total of 12 values).

Practical Project (40%): A practical group project (composed of 2 or 3 members) is developed, with a weighting of 8 values.

NAO