Skip to main content

IPLUSO 13304

Fundamentals of Databases

Development for the Web and Mobile Devices
  • ApresentaçãoPresentation
    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. The field of action of this UC ranges from the study of database management systems (DBMS) to data modeling, including standardization, SQL, and optimization techniques. In the current era, where information plays a preponderant role, its effective management becomes imperative, with databases being a crucial tool in this process. Whether developing web or mobile applications, the ability to interact, manipulate, and optimize databases is essential. Therefore, this UC has a vital relevance in the study cycle, preparing students to face real challenges in the job market, providing them with a solid foundation in information management and integration with various development platforms.
  • ProgramaProgramme
    Introduction to Databases: Definition, importance, and historical evolution. Database Management Systems (DBMS): Characteristics, components, and types of DBMS. Relational Model: Entities, relationships, attributes, and keys. Normalization: Process, objectives, and normal forms. SQL language: Basic and advanced queries, CRUD operations (Create, Read, Update, Delete), aggregate functions, and joins. Database Design: Techniques and tools for modeling and design. Databases in Web and Mobile Environments: Integration with applications, security and optimization. Advanced Topics: Indexing, transactions, concurrency and failure recovery.
  • ObjectivosObjectives
    Knowledge: Students will acquire a deep understanding of the fundamental principles of databases, including the architecture of Database Management Systems (DBMS), data models, and standardization practices. Skills: They will develop practical skills in database design, manipulation, and querying using the SQL language, and implementation of databases in real web and mobile development contexts. Skills: They will be trained to analyze and solve problems related to data management, effectively integrating databases into web and mobile solutions, 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
    Date, C. J. (2003). An Introduction to Database Systems (8th ed.). Boston: Addison-Wesley. Elmasri, R., & Navathe, S. B. (2016). Fundamentals of Database Systems (7th ed.). Boston:Pearson.  
  • 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, discussion forums, and online quizzes. 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 more dynamic, interactive, and effective.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    5
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não