Bases de Dados II

NA

In this curricular unit, the following teaching methodologies are used:

1 – Expository method: explanatory method where theoretical foundations and concept are presented by the teacher and discussed with the class, followed by demonstrative examples;

2 – Experimental method: active method where the student develops knowledge through problem solving and the development of individual laboratory projects or in group dynamics.

It is expected that at the end of the course the student will be able to:

1. Understand the physical aspects of databases and acquire skills for their administration;

2. Understand and apply data exploration and analysis techniques;

3. Design and develop approaches for data transformation and analysis;

4. Programming in a database server using PL/SQL language.

1. Physical Aspects of Databases (Structure of a DBMS; Physical parameters; Indexing; Clusters; Hashing; Table and index partitioning; Partitioning methods and keys; Management of table partitions and Sub-Partitioning);

2. Introduction to Data Analysis (OLAP, ROLAP AND MOLAP; Data Warehousing; Multidimensional Databases; ETL Process; Data Preparation; Data Mining Concepts);

3. Programming in the Database Server (Data Types, Structures, Exceptions, Cursors, Triggers, Procedures, Functions and Packages).

• - an individual project with presentation - 50.0%
• - an individual written test - 50.0%

• - a project (individual or in group) with presentation - 35.0%
• - two individual practical assignments - 65.0%

NAO