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
Programs
Programs where the course is taught: