IPT Logotipo do IPT

Ano Letivo: 2021/22

Engenharia Informática

Advanced Databases

<< back to Curriculum Plan

Publication in the Diário da República: Despacho n.º 8644/2020 - 08/09/2020

5 ECTS; 2º Ano, 2º Semestre, 28,0 PL + 28,0 TP , Cód. 911942.

Lecturer
- António Casimiro Teixeira Batista (2)
- José Casimiro Nunes Pereira (1)(2)

(1) Docente Responsável
(2) Docente que lecciona

Prerequisites
Knowledge of modeling Databases is mandatory.

Objectives
a) identify and describe the physical aspects of a database;
b) carry out transactions in databases;
c) identify and describe data recovery and backup structures
d) identify and choose user permissions
e) define and implement mechanisms for automating a database: procedures, functions, triggers and events
f) define and implement replication of a database

Program
1 - An introduction to the administration of Database Management Systems.
2 - Physical and logical administration of Database Management Systems.
3 - Competition and transactions.
4 - Security and recovery
5 - Query optimization.

Evaluation Methodology
Exam (85%) and Practical Work (15%).

Bibliography
- Date, C. (2003). An Introduction to Database Systems. (Vol. 8th.). .: Addison Wesley
- Gouveia, F. (2014). Fundamentos de Bases de Dados. (Vol. 1st.). Lisboa: FCA - Editora de Informática, Lda
- Navathe, S. e Elmasri, R. (2010). Fundamentals of Database Systems. (Vol. 6th.). .: Addison Wesley
- Pereira, J. e Batista, A. (2012). Apontamentos de Material de Apoio. (Vol. 1). Tomar: edição de autor

Teaching Method
Lectures, tutorials and laboratory classes.

Software used in class
MySQL
MySQL Workbench

 

 

 


<< back to Curriculum Plan
NP4552
Financiamento
KreativEu
erasmus
catedra
b-on
portugal2020
centro2020
compete2020
crusoe
fct
feder
fse
poch
portugal2030
poseur
prr
santander
republica
UE next generation
Centro 2030
Lisboa 2020
co-financiado