Publication in the Diário da República: Despacho n.º 12419/2016 - 14/10/2016
6 ECTS; 2º Ano, 1º Semestre, 45,0 PL + 30,0 TP + 5,0 OT , Cód. 814311.
Lecturer
- Henrique Carlos dos Santos Mora (1)
(1) Docente Responsável
(2) Docente que lecciona
Prerequisites
Not applicable
Objectives
1. Database fundamentals.
2. Students should be familiarised with related technologies and methodologies.
3. They should also be able to design, implement or follow-up projects involving large databases
4. Be familiarised with server-side programming, triggers and store procedures
Program
1. Fundamentals
2. Databases
3. Traditional drawing methods
4. Language for access to relational databases
5. Microsoft Sql Server
6. Structured Query Language
7. Modelling
8. Temporary Tables and Table Variables
9. Store Procedures and Functions
10. Triggers and Cursors
Evaluation Methodology
Bibliography
- Ramakrisnan, R. e Gehrke, H. (2003). Database Management Systems. US: McGraw-Hill
- Sarka, D. e Itzik, B. e Wolter, R. (2008). Inside Microsoft SQL Server 2008: T-SQL Programming. US: Microsoft Perss
Teaching Method
Lectures providing key concepts. Tutorials based on practical cases that enable the application of acquired concepts.
Software used in class
