IPT Logotipo do IPT

Ano Letivo: 2020/21

Informática e Tecnologias Multimédia

Databases

<< back to Curriculum Plan

Publication in the Diário da República: Despacho n.º 12419/2016 - 14/10/2016

6 ECTS; 2º Ano, 1º Semestre, 45,0 PL + 30,0 TP + 5,0 OT , Cód. 814311.

Lecturer
- Henrique Carlos dos Santos Mora (1)(2)

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

Prerequisites
Not applicable

Objectives
1. Database fundamentals.
2. Students should be familiarised with related technologies and methodologies.
3. They should also be able to design, implement or follow-up projects involving large databases
4. Be familiarised with server-side programming, triggers and store procedures

Program
1. Fundamentals
2. Databases
3. Traditional drawing methods
4. Language for access to relational databases
5. Microsoft Sql Server
6. Structured Query Language
7. Modelling
8. Temporary Tables and Table Variables
9. Store Procedures and Functions
10. Triggers and Cursors

Evaluation Methodology

Bibliography
- Ramakrisnan, R. e Gehrke, H. (2003). Database Management Systems. US: McGraw-Hill
- Sarka, D. e Itzik, B. e Wolter, R. (2008). Inside Microsoft SQL Server 2008: T-SQL Programming. US: Microsoft Perss

Teaching Method
Lectures providing key concepts. Tutorials based on practical cases that enable the application of acquired concepts.

Software used in class

 

 

 


<< 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