DataBase Management Systems
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
200032
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
Bibliography
Thomas M. Connolly and Carolyn E. Begg, Database Systems: a Practical Approach to Design, Implementation, and Management, Addison-Wesley, Pearce Education Limited, 2010; Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts, McGraw-hill, 2006 ; 0; 0; 0
Teaching method
Evaluation method
Subject matter
Programs
Programs where the course is taught:
- Specialization in Information Analysis and Management
- Specialization in Risk Analysis and Management
- Specialization in Business Intelligence
- Specialization in Information Systems
- specialization in Digital Transformation
- Specialization in Business Intelligence – Working Hours
- specialization in Information Systems - working hours
- PostGraduate in Information Analysis and Management
- PostGraduate Risk Analysis and Management
- PostGraduate in Business Intelligence
- PostGraduate in Smart Cities
- PostGraduate in Information Management and Business Intelligence in Healthcare
- PostGraduate Information Systems Management
- PostGraduate in Enterprise Information Systems
- Pós-Graduação em Transformação Digital