Databases I

Information and Communication Technologies
5.5 ECTS; 2º Ano, 2º Semestre, 30,0 TP + 30,0 TC

- Henrique Carlos dos Santos Mora

Not applicable.

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

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

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

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

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