Is MySQL that I need?

Question

I am noob. Big rookie. I love Sololearn because is first time that I try to learn code and I know what I am doing. What I am learning.

In my work I am manager and I need to connect different spreadsheets between them.

Now, I work downloading different spreadsheets from different programs and calculate the data that I want from each one for get the data that I need.

With the "final data", I have other document with the "information curated" where I apply different graphs and I can see tables for take decisions.

My problem is that sometimes I think in a different combination of data that usually I don't have... And for got it, I have to start again consulting each spreadsheet and to combine between them for get the result that I want. A lot of time.

So... I am thinking that will be better if I'd have a database with all these information and I'd make queries for different combinations of data depending to the necessity to each moment.

What I need to learn?

One important thing is that information with I work is updated every month. So I need to update the database each month with the new information of the programs that my team work. Is that possible?

Can I import a different spreadsheets to update the database and after make the queries that I need?

In summary, I have different spreadsheets with all the information. I would like to have a database with the combination of all these spreadsheets and make queries combinating all the data from database. And I need update regulary this database with new information that I get from the programs with that we work.

Is MySQL that I need? I understand that MySQL is a program to create the database and SQL is the language to make queries in that database. Is that correct?

Sorry for big question and bad english. ;-)

Thx a lot!

Answer 1

You could do that using any database system, not only MySQL. Include some sanity checks for the monthly import, and properly secure the db.

Answer 2

::sk:: Any database program formac? Free?