IPLUSO 13304

Fundamentals of Databases

• ApresentaçãoPresentation

  This UC focuses on introducing and consolidating the fundamental concepts of databases, providing students with the necessary skills for the conception, design, implementation, and management of database management systems (DBMS). The scope of this UC ranges from the study of DBMS to data modelling, including standardisation, SQL, and optimisation techniques. Nowadays, where information plays a predominant role, effective information management is imperative, and databases are a crucial tool in this process. In Computer Engineering and Applications, the ability to interact, manipulate, and optimise databases is essential. This UC is therefore vitally important in the study cycle, preparing students to face real challenges in the job market by providing them with a solid foundation in information management and integration with development platforms.
• ProgramaProgramme

  Introduction to Database Fundamentals Definition of data, types and uses Definition, importance and applications of databases Ethics, privacy and best practices in the use of databases Ethics, privacy and good use of data General Data Protection Regulation (GDPR) Database Management System (DBMS) DBMS components and architecture Data models Database installation and administration Fundamentals of relational models Relational model: components and properties Conceptual models vs logical models Entity-relationship diagrams SQL Data types DDL, DML and DQL Normalisation Transactions and Integrity Transactions and ACID Properties Control and Access Commands Performance, Indexing, Backup and Restore Databases applied to real contexts and integration with other platforms
• ObjectivosObjectives

  Knowledge: Students will acquire a thorough understanding of the fundamental principles of databases, including the architecture of Database Management Systems (DBMS), data models and normalisation practices. Skills: They will develop practical skills in database design, manipulation and querying using SQL and database implementation in real contexts. Competencies: They will be able to analyse and solve problems related to data management, effectively integrating databases, considering aspects of performance, security and scalability. Through this UC, students will be prepared to face contemporary challenges in the area of information management, becoming more complete professionals who are adaptable to market demands.
• BibliografiaBibliography

  Kaufmann, M., & Meier, A. (2023). SQL and NoSQL databases: Modeling, languages, security and architectures for big data management (2nd ed.). Springer. https://doi.org/10.1007/978-3-031-27908-9 Simon, M. (2023). Getting started with SQL and databases: Managing and manipulating data with SQL (1st ed.). Apress. https://doi.org/10.1007/978-1-4842-9493-2  
• MetodologiaMethodology

  Project-Based Learning (PBL): Students develop practical projects, simulating real market challenges, encouraging the direct application of theoretical content. Virtual Learning Environments: Interactive digital platforms that support the sharing of materials and discussion forums. Peer Learning: Stimulation of collaborative learning, where students teach and learn from each other, strengthening their understanding of the content. Microlearning: Division of content into small units or capsules, facilitating the digestion and retention of information. These methodologies seek to adapt the educational process to the needs and characteristics of students in the digital era, making learning moredynamic, interactive, and effective
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  6
• NaturezaNature

  Mandatory
• EstágioInternship

  Não