In an earlier article we have seen the possibilities to perform Excel functions such as vlookup through Python. In this article we will see how we can perform pivoting through Python. We will analyze ways so that we can find information… read more
How do we load files (csv, txt) into Oracle database
It is possible to import files like csv and txt into an oracle database table. There are two similar ways. Using SQL*Loader or using External Table. Their mode of operation is similar, but depending on the case, it is more suitable... read more
What is Oracle Data Guard
Data Guard is Oracle's database solution for high availability and disaster recovery. In the article we will analyze how it works and the types it has. In its use we define our production base as primary… read more
What is SQL and what can it do?
We have seen what databases are but in order to use them we must somehow be able to export or import data from them. How is this possible? With Structured Query Language or SQL. It is her main… read more
Vlookup with Python without using Microsoft Excel functions
Microsoft Excel is very efficient when managing a small amount of data. But it requires the use of functions which are very easy to modify by mistake or to forget to remove them before saving the result. Somewhere there comes the… read more
What is VBA and how to use it in Microsoft Excel
We all know Microsoft Excel as one of the most basic and first programs created for use with a graphical interface on computers. Excel is a program that manages spreadsheets. It is a mini database that… read more
How to make our first graph using Python
In the article we will see how we can make barplots using Python easily and quickly. To begin with, we should load 3 libraries that we have ready with the functions we will need: In the variable df we loaded a dataframe... read more
In the cloud and beyond with Azure infrastructure
In this article we will analyze what Microsoft's cloud service offers us in terms of infrastructure. By using Azure we can transfer our on-premise systems to the Cloud or even go to… read more
How databases are stored and what indexes are
We have seen what a relational database is and that our entities are logical objects called tables. But how are they stored “physically” in an RDBMS (relational database management system)? Tables as objects are stored and… read more
