Databases Complements

Scholar Year: 2019/2020 - 1S

Courses

Head Teacher Responsability Cláudio Miguel Garcia Loureiro dos Santos Sapateiro Head

Weekly workload Hours/week T TP P PL L TC THE EL OT OT/PL TPL S Type of classes 2 2 Lectures Type Teacher Classes Hours Theorethical and Practical classes Totals 2 4,00 Cláudio Sapateiro   6,00 Prática Laboratorial Totals 1 2,00 João Santos   6,00 João Lázaro   4,00 Luís Cassaca   4,00

Teaching language

Portuguese

Intended learning outcomes (Knowledges, skills and competencies to be developed by the students)

The curricular unit aims to provide students with the following skills:
- Advanced knowledge of Relational Databases, particularly in the aspect of administration;
- Introduce the technological aspects concerning the implementation of the DBMS;
- Presentation of other database technologies beyond the relational model.

Syllabus

- DBMS architecture. Metadata and Application Development.
- Backup and Recovery.
- Models and Types of Replication. Mirroring and Clustering.
- Storage and Indexing.
- Processing Queries.
- Optimization of Queries.
- Monitoring, Optimization and Tuning Base.
- Advanced Topics in BD (Transaction Management and Concurrency, Parallel and Distributed BDs, OR OO &
DB, DB Deductive, Spatial DB, Data Warehousing, Business Intelligence, XML and WebServices).

Software

MS SQL SERVER 2017

Demonstration of the syllabus coherence with the UC intended learning outcomes

In the lectures is exposed the syllabus of theoretical support required to database administration, followed by
the presentation of concepts for developing distributed applications and optimizing the performance of
applications and DBMS.
In labs the students must perform a set of exercises in the Microsoft SQL Server environment, in order to
validate the knowledge imparted in the lectures.

Teaching methodologies

The pedagogical methodology used in this curriculum unit is based on two components: lecture method and
group work in laboratory environment.
Will be used an e-learning platform (Moodle) to support teaching, as repository of information, forum, delivery of
work and testing of self assessment and summative evaluation.
The evaluation of the discipline consists of making an exam and a practical work developed in group involving
the database scheme definition and its web interface.
To obtain approval, the students must obtain in the exam and practical work, a grade higher than 9.5. The
component weight of the exam for the final grade will be 50% and the practical work will have a weight of 50%.
The final grade (FG) will be given by the formula:
FG = 50% Exam + 50% Practical work
Forms of communication with students:
In addition to direct contact in the classroom, students will communicate with teachers of the curriculum unit
through e-learning platform Moodle.

Demonstration of the teaching methodologies coherence with the curricular unit's intended learning outcomes

The main objectives of this unit are associated with the development of skills to use Database Management
Systems.
To consolidate the material taught in lectures, methods are used for exhibitions and practical work conducted in
the laboratory in order to convey to students the essential knowledge to achieve the objectives.
The use of e-learning platform Moodle promotes greater contact between the participating faculty and their
students, either through forums or other activities that stimulate communication between elements (for selfassessment
tests, availability of the classes, etc.).

Assement and Attendance registers

Primary Bibliography

Secondary Bibliography