ISLA IPGT 8448

Databases

• ApresentaçãoPresentation

  The course unit offers an in-depth exploration of principles and practices related to database management, equipping students to work as specialists in fields such as software development, data analysis, system administration, and data science. With a focus on advanced topics like complex modeling, query optimization, and data security, this UC is highly relevant in various fields, making it essential for deepening knowledge in the study cycle and preparing students for complex challenges in the field of information technology.  The curricular unit aims to develop skills in the area of SQL programming
• ProgramaProgramme

  1. Databases Data concept Data model concept Database architecture Files and databases Relational databases Database management system architecture 2. Relational Model Relational data structure Model integrity rules Data management in the relational model 3. Tables, Records, Fields, and Keys 4. Normalization Representation in non-normalized form DeMarco notation type Gane and Sarson notation type Codd's normalization stages Information integrity 5. Implementation of databases in DBMS 6. Creating, changing and deleting tables and indexes in SQL 7. Elimination of tables and indexes (DROP TABLE and DROP INDEX commands); 8. Updating data . Transaction concept (COMMIT and ROLLBACK commands) 9. Privileges and access control (GRANT and REVOKE commands 10. Views 11 Triggers 12. Security 13.SQL embedded in programming languages
• ObjectivosObjectives

  The learning objectives of the course unit include developing a strong knowledge of database systems, advanced skills in designing complex databases, query optimization, and data security, as well as the utilization of emerging technologies. Students also gain the ability to apply this knowledge to solve practical problems and effectively communicate complex concepts. Teamwork is emphasized for effective collaboration in database projects. These objectives prepare students for advanced challenges in information management and technology Address data manipulation languages, both abstract (relational algebra) and concrete (SQL - Structured Query Language). Study how to access the database using SQL together with a programming language. Use SQL language terminology unambiguously.
• BibliografiaBibliography

  Luís D., SQL, Editora FCA, 1999. Gouveia, F., Fundamentos de Base de Dados, Editora FCA, 2014 José Luís Pereira, Tecnologia de bases de dados, Editora FCA, 1998. Alberto Magalhães SQL Server 2008 Curso Completo - 2ª Edição Raghu Ramakrishnan, Database Management Systems, McGraw-Hill, 2001. Silberschatz, Korth, Database Systems Concepts, III Ediçao, McGraw Hill, 1997.  
• MetodologiaMethodology

  Innovative methodologies to support the teaching and learning process in the course unit include active learning through problem-solving and case studies, collaboration on group projects, the use of interactive digital resources, regular formative assessments, and the practical application of knowledge in real-world projects. These dynamic and engaging approaches help students effectively and motivationally develop advanced database skills
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  6
• NaturezaNature

  Mandatory
• EstágioInternship

  Não