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