Armazenamento e Recuperação de Dados

Objetivos

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.