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 (2)
(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
Learning outcomes are assessed through a written test and practical assignments with pre-established submission dates. Assignments are undertaken as part of a group (but assessed individually) and includes final discussion.
Bibliography
Teaching Method
Lectures providing key concepts. Tutorials based on practical cases that enable the application of acquired concepts.
Software used in class
