IPT Logotipo do IPT

Tecnologias de Informação e Comunicação

Databases I

<< back to Curriculum Plan

Publication in the Diário da República: Plano 4 - 2010/2011

5.5 ECTS; 2º Ano, 2º Semestre, 30,0 TP + 30,0 TC , Cód. 925030.

Lecturer

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

Prerequisites
Not applicable.

Objectives
An in-depth study of SQL language and data modelling, server-side programming, triggers and store procedures.

Program
1. Microsoft SQL Server
1.1 Backups and Restores
1.2 Dynamic Growth
1.3 File locations for performance reasons
2. Structured Query Language
2.1 Joins
2.2 Sub querys
2.3 Pivot Tables
2.4 Full text search
3. Modelling
3.1 Performance
3.2 Maintenance
3.3 Versatility
4. Temporary tables and table variables
5. Store Procedures and Fucntions
6. Triggers
7. Cursors

Evaluation Methodology
Mid-term assessment
2 individual assignments (50% each)

Final assessment
1 individual assignment (100%)

Bibliography
- Date, C. (2003). An Introduction to Database Systems. US: Addison-Wesley
- Itzik, B. e Sarka, D. e Wolter, R. (2008). Inside Microsoft SQL Server 2008: T-SQL Programming. US: Microsoft Press
- Ramakrisnan, R. e Gehrke, H. (2003). Database Management Systems. US: McGraw-Hill

Teaching Method
Theoretical-practical classes. Fieldwork involving execution of assessed tasks.

Software used in class
Microsoft SQLServer 2008 R2 or superior
Microsoft Visio

 

 

 


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