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
- Fernando Sérgio Hortas Rodrigues (2)
(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
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
- 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
