Storing and Retrieving Data

Objectives

Today, data is everywhere and come in different shapes and volumes, in structured and unstructured forms. Companies need to store and manage data using appropriate database technologies for the success of their business processes and the ability in a competitive market. Database technologies is a very broad field. In the Storing and Retrieving Data course we will focus on relational database technologies, specifically MySQL. We will cover several topics during the course. For instance, the architecture of a DBMS, the process of database modelling and normalization, the implementation of a relational database using SQL language (theoretical and practical), use of advance SQL objects as Views and Triggers, query optimization techniques, and the differences between SQL vs NoSQL databases. 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

200174

Credits

4.0

Responsible teacher

Mijail Juanovich Naranjo Zolotov

Hours

Weekly - Available soon

Total - Available soon

Teaching language

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

Prerequisites

Available soon

Bibliography

Teaching method

Evaluation method

Subject matter