Database Technologies

Code: INF13271M

6 ECTS

Duration: 15 weeks/156 hours

Scientific Area: Informatics

Teaching languages: Portuguese

Languages of tutoring support: Portuguese

Sustainable Development Goals

Educação de qualidade - Assegurar a educação inclusiva, e equitativa e de qualidade, e promover oportunidades de aprendizagem ao longo da vida para todos.

Learning Goals

Upon completing the course unit students will have to demonstrate that they have acquired knowledge, skills
and aptitudes in the following aspects:
Recognition of the development cycle of a relational database;
Knowledge of advanced elements in database design;
The role of SQL in database applications;
SQL performance-oriented programming;
Data security at the level of database access authorizations;
Advanced security features: SQL injection control and data encryption;
Backup and recovery data methods;
In work group work and in written and oral communication.

1. Database Environment
2. Database Design
3. Application Design
4. Data Availability
5. Performance Management
6. Database Security
7. Database Backup and Recovery
8. Distributed databases

Teaching Methods

The theoretical-practical sessions will comprise (1) lecture/discussion of certain concepts, (2) instructor demonstrations
of these same concepts, and other features, and (3) student lab sessions working with these same concepts and features.
The purpose of this pedagogical approach is to introduce and reinforce ideas and skill sets so that students can
master these on their own after hours. To bring this knowledge to a highly proficient, professional level,
students will have to spend time and effort outside of class.
Method A: Project with four components - 50%; Two tests during the semester - 40% (20% + 20%); Class participation
(10%)
Method B: Project with four components - 50%; Exam - 40%; Class participation (10%)