Skip to main content

IPLUSO 22250

Databases - Modeling and SQL Concepts

Cybersecurity
  • ApresentaçãoPresentation
    The course introduces the concepts of database design and analysis, with a focus on the relational model, the logical design of databases and implementation. The main objective of this course is introducing the student to the fundamental concepts involved in the creation of database management systems, as well as its practical difficulties.
  • ProgramaProgramme
    Welcoming and presentation of the teacher and program. Analysis and Design of Databases. Definition, objectives, types and concepts; Entity-Relationship model; UML model; Normalization of relational schemas; Relational algebra. Logical Design - SQL Queries. Data manipulation in SQL; Selection, insertion, removal and update instructions; Filtering, ordering, aggregation, joining and manipulation of null values operations; Data description in SQL; CREATE, ALTER, DROP, UPDATE and DELETE instructions. Application of Databases. Database Administration; Vulnerabilities in Databases;
  • ObjectivosObjectives
    This curricular unit aims to provide the students with knowledge of analysis and design of Databases, use and administration of database tools and mastery of the SQL language and its use.
  • BibliografiaBibliography
    Raghu Ramakrishnan e Johannes Gehrke, Database Management Systems, McGraw--¿Hill, 3ª edição, 2003, ISBN 0072465638  
  • MetodologiaMethodology
    Exposition Sessions, in class or online, with concepts, definitions and theoretical framework - Practical lessons, with realization of individual and group work - Practical exercises based in analysis, design, creation and use of Databases. Continuous evaluation: - Written Test 1, 30% of the final grade - Written Test 2, 30% of the final grade - Participation and presence in class, 10% of the final grade - Group work, 30% of the final grade. Approval with a evaluation of 10 or higher. There exists a requirement for the average of the Written test grades to be more or equal to 8 and the group grade to be more or equal to 8. Appeal Evaluation: -Written exam of recover 100% of the final grade. This is intended for students who have not passed the continuous evaluation.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    5
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não