Skip to main content

IPLUSO 13304

Fundamentals of Databases

Computer Engineering and Applications
  • ApresentaçãoPresentation
    This course aims for students to develop abstraction mechanisms, develop information structuring, develop the ability to effectively use information search languages and provide students with knowledge of analysis, design and implementation and management of databases. This UC focuses on the introduction and consolidation of the fundamental concepts of databases, providing students with the necessary skills for the conception, design, implementation and management of database systems.
  • ProgramaProgramme
    Database Concepts and Conceptual Model Definition. Objectives, Types and Concepts Conceptual data model Data Modelling Analysis, design and creation of Databases Database Analysis (UML Language – Class Diagrams) Data relational model Transposition from a conceptual model to a relational model Database Design and Creation Database Management Systems Installation and configuration of Databases Database Administration SQL Language Simple queries Aggregate Functions, Subqueries, and Triggers Stored procedures Analysis, design and implementation of a database Database security NOSQL Databases
  • ObjectivosObjectives
    The course aims for students to develop abstraction mechanisms, develop information structuring, develop the ability to effectively use information search languages and provide students with knowledge of analysis, design and creation, as well as the use and administration of Database Management Systems. Define and implement coherent strategies for copying data and privilege backups and access control. Master the SQL language and its use. The concepts and knowledge will be obtained through exercises and practical examples and an application project.
  • BibliografiaBibliography
    Navathe, Shamcant e Elamsri, Ramez - Fundamentals of Database Systems, 7th Edition, Pearson (2016) ISBN 978-0-13-397077-7 Damas, Luís – SQL - Structured Query Language, 14ª Edição atualizada (2020). FCA (2020). ISBN13: 978-972-722-829-4 Ramos, Pedro Nogueira – Desenhar Bases de Dados com UML, 2ª Edição (2012). Edições Sílabo Lda. Documentos de apoio e textos a fornecer pelos docentes
  • MetodologiaMethodology
    Online support will be made available to students and to bring students closer to the business reality, they will be used in activities to carry out situations identical to those verified in companies
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    6
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não