Skip to main content

IPLUSO 23552

Data Communication Bases

Computer Applications for Data Science
  • ApresentaçãoPresentation
    Databases are at the heart of modern commercial application development. In addition, their use extends to many other environments and domains where large amounts of data must be stored for efficient update, retrieval, and analysis. This course provides an introduction to fundamental principles, methodologies for effective database design, and to the SQL language. The course will be driven by a set of practice activities, conducted along the semester, that will allow the students to acquire the required skills.
  • ProgramaProgramme
    1. Introduction to Databases and DBMS. What are DB and why are they essential. Difference between structured vs. unstructured data. Traditional file systems vs. database management systems (DBMS).. Overview of database types  (Relacional, NoSQL). Introduction to Database Management Systems (DBMS). 2. Relational Model & Database Design Data models. Tables, Rows and Columns. Constraints, Primary Keys, Foreign Keys. Relationships in a Database. Introduction to Entity-Relationship (ER) Diagrams. Normalization concepts. 3. SQL Language What it is and why it's used. Data Definition (CREATE, ALTER, DROP).  Data Manipulation (INSERT, UPDATE, DELETE). Basic Queries: (SELECT, WHERE, ORDER BY). Advanced Queries (JOIN, GROUP BY, aggregate funciotns, sub-queries and nested queries) Concurrency (COMMIT e ROLLBACK) Data Integrity (Constraints) Security (GRANT e REVOKE) 5. Database Backup and Recovery Strategies. Backups (Physical and Logical) and Data Recovery.
  • ObjectivosObjectives
    At the end of this course, students will be able to: 1. Understand DBMS systems architecture and components 2. Undestand the relational model approach to data management. 3. Model Entity-Relationship diagrams for a database 4. Formulate queries using the SQL Language 5. Apply different normal forms to design a database 6. Identify suitable Indices for effective storage and retrieval of data. 7. Undestand how access control is performed in a DBMS.  
  • BibliografiaBibliography
    Garcia-Molina, H., Jeffrey David Ullman, & Widom, J. (2014). Database systems: the complete book. Pearson, Cop. Damas, Luís – SQL - Structured Query Language, 14ª Edição atualizada (2020). FCA (2020). ISBN13: 978-972-722-829-4    
  • MetodologiaMethodology
    Use of problem-based learning methodology, w hich allows the student to acquire knowledge, at the same time that carrying out the set of procedures for solving problems allows them to develop skills and competences. This methodology promotes learning as part of the activity developed to solve the problem.
  • LínguaLanguage
    Português
  • TipoType
    Semestral
  • ECTS
    4
  • NaturezaNature
    Mandatory
  • EstágioInternship
    Não