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
Lecturer
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
Teaching Method
Theoretical-practical classes. Fieldwork involving execution of assessed tasks.
Software used in class
Microsoft SQLServer 2008 R2 or superior
Microsoft Visio
