IPLUSO 1792

Databases

• ApresentaçãoPresentation

  This curricular unit aims to present the importance of Data Management within a company, to guarantee both the daily operation of the business, as well as the support to the strategic decision. This unit will reinforce the framework for structuring and methodologies for creating databases.
• ProgramaProgramme

  The syllabus of the curricular unit is: A) Theorical concepts Introduction Entity-Relationship Model The Relational Model Schema refinement: Normalisation and Transactions concept Architecture of DBMS and some Advanced SQL B) Lab component Introduction to SQL language; Instructions: DDL, DML (DQL) and DCL Operations: WHERE, ORDER BY, GROUP BY; Advanced concept in SQL: Error control Relational Operators: Union, Intersection, and Subtraction Cartesian Product (external) Complex queries (filter with aggregated values) and sub-queries Set DDL; CREATE statement; Data types; Nullity; ALTER and DROP statements INDICES and VIEWS Exception handling Procedures (SP) and Triggers Tables: Cursors
• ObjectivosObjectives

  The objectives are to provide students with the theoretical and practical knowledge required to design, construct and analyze relational databases: namely, to obtain the following skills and competences: 1. Understand the reasons for implementing relational databases in the business world 2. Transpose from a requirements analysis to an entity-association model to design databases; 3. Apply the concepts of the relational database model, transforming the entity-association model into a physical data model; 4. Apply the techniques of normalization of tables; 5. Understand architecture and main components of Database Management Systems; 6. Use the base and advanced SQL language for creating, querying, and modification of databases;
• BibliografiaBibliography

  Livros Damas, Luís (2017). SQL (14ª edição). FCA Date, C. J. (2003). An Introduction to Database Systems (8 edition). Boston: Pearson. Sites Recursos educativos do SQL - SQL Server | Microsoft Learn. (n.d.). Retrieved September 26, 2025, from https://learn.microsoft.com/pt-pt/sql/sql-server/educational-sql-resources?view=sql-server-ver17
• MetodologiaMethodology

  Real world scenario simulation, using, whenever possible and applicable, integration with backend development with common used languages (e.g. PHP or Python) Use of modular case studies, allowing students to develop different yet complementary components, producing more comprehensive solutions
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  5
• NaturezaNature

  Mandatory
• EstágioInternship

  Não