Base de Dados I

Tecnologias de Informação e Comunicação
5.5 ECTS; 2º Ano, 2º Semestre, 30,0 TP + 30,0 TC

Lecturer
- Henrique Carlos dos Santos Mora

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
2. Structured Query Language
3. Modelling
4. Temporary tables and table variables
5. Store Procedures
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
- Ramakrisnan, R. e Gehrke, H. (2003). Database Management Systems. US: McGraw-Hill
- Itzik, B. e Sarka, D. e Wolter, R. (2008). Inside Microsoft SQL Server 2008: T-SQL Programming. US: Microsoft Press

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

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