Databases Management

Objectives

Introduce the fundamental concepts inherent to relational databases including data modeling - from the conceptual point of view and to a physical implementation, standardization, optimization of queries, data integrity and transaction management, aimed at supporting the development of transactional systems. This course places great emphasis on a theoretical framework coupled with the provision of an extensive practical experience grounded in the use of a relational Database Management System (DBMS) such as Microsoft SQL Server and data modeling tools such as SAP Power Designer. At the end of the course, participants will be able to use these skills to design, implement and query a database, packaging it with a layer of functional, integrity and security constraints.

General characterization

Code

400007

Credits

7.5

Responsible teacher

Jorge Nelson Gouveia de Sousa Neves

Hours

Weekly - Available soon

Total - Available soon

Teaching language

Portuguese. If there are Erasmus students, classes will be taught in English

Prerequisites

Available soon

Bibliography

Teaching method

Evaluation method

Subject matter