ISLA IPGT 8448

Databases

• ApresentaçãoPresentation

  The course uni 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.
• 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. DBMS (Database Management Systems)** - Usage domains - Architecture - Configuration - Database creation - Database maintenance - Implementation of security and integrity
• 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.
• BibliografiaBibliography

  Elmasri Ramez; Fundamentals of database systems. ISBN: 0-321-20448-4 A. Silberschatz, H. Korth and S. Sudarshan; Database Systems Concepts 5/E, McGraw-Hill Ullman Jeffrey D., 1942-; A first course in database systems. ISBN: 0-13-887647-9  
• 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

  3
• NaturezaNature

  Mandatory
• EstágioInternship

  Não