Data Management and Storage

Objectives

Today, data is everywhere and come in different shapes and volumes, in structured and unstructured forms. Companies need to store and manage these data using appropriate data management or database technologies for the success of their business processes. In Gestão e armazenamento de dados (Data management and storage) course, students will get familiar with the architecture of a DBMS, the existing relational database applications, the process of database modelling and normalization, the implementation of a relational database using SQL language (theoretical and practical), and the advantages and disadvantages of SQL and NoSQL databases. The students will be able to decide about the type of database is the best for their business needs. Moreover, the emergence of Artificial Intelligence (AI) tools has created new opportunities for SQL analysts and SQL developers, greatly increasing their productivity. This course integrates the use of AI tools to work with relational databases in the labs.

General characterization

Code

200193

Credits

4.0

Responsible teacher

Yuri Ivanov Binev

Hours

Weekly - Available soon

Total - Available soon

Teaching language

Portuguese. If there are Erasmus students, classes will be taught in English

Prerequisites

The lectures, group discussions, reading materials, quizzes, and exams will be all provided in English language. Although not mandatory, the students should have a proficient English language skills.

Bibliography

Teaching method

The course combines theoretical and practical lessons. The theoretical component includes lectures and slide show demostrations to present concepts and methodologies, solving examples in class and discussion. The practical part includes individual hands-on exercises and group work, where students will face a problem to discuss and solve. The students are encouraged to use AI tools during the labs and assess the quality of the answers given by the AI tools. Moreover, the lessons may apply short quizzes along the trimester to assess the student’s progress and understanding of the theoretical materials.

Evaluation method

Regular examination period (1^st epoch)

A group project (35%).
Final exam (50%).

Resit examination period (2^nd epoch)

A group project (35%)
Final exam (50%).

Subject matter

LU1. Course Overview. DBMS architecture. Introduction to Entiry-Relationship diagram (ERD). Conceptual modelling.

LU2. Design a relational databases with a sound structure. Data Normalization (3-Normal Forms).

LU3. SQL benchmarking. Database creation. DDL operations. Introduction to MySQL workbench.

LU4. CRUD operations. Introduction to AI tools.

LU5. Sorting and Grouping operations. Working with AI tools.

LU6. Joins and views

LU7. Overview of NoSQL database types. CAP theorem. Wrap-up.

Programs

Programs where the course is taught: