Some basic questions on writing scripts
I'm extremely new to programming, and the majority of what I'm doing now is for my entry-level job on an IT department that deals with a lot of database work, using MySql.

Recently, I've been given some projects that require queries and commands a little too complex for a single query into a MySql database, and any answer online that even comes close to what I'm talking about always deals with the issue using a script.

I don't feel the need to list out my exact issue here, because I still want to try to work through it myself, but I'm extremely confused on how you can write and implement a script for both MySql and Microsoft Excel. Currently, I'm on a Macbook Pro using Terminal and MySql Workbench for work in databases, and I edit the few scripts I do write in the Vim editor. When it come to Excel, I'm clueless.

Are both of these situations made possible by writing scripts in my vim editor? If so, what do the extensions need to be and how can I link them to servers that I typically SSH into? The syntax of such scripts makes a little sense to me, but I'd be able to pick up on it a lot faster if I could practice it myself. I just don't even know how to start.

I'd appreciate any help or points in the right direction. If possible, try to explain things as nooby as you can. Act like I'm really new at this please. Thanks guys!
Some basic questions on writing scripts
===

I'm extremely new to programming, and the majority of what I'm doing now is for my entry-level job on an IT department that deals with a lot of database work, using MySql.

Recently, I've been given some projects that require queries and commands a little too complex for a single query into a MySql database, and any answer online that even comes close to what I'm talking about always deals with the issue using a script.

I don't feel the need to list out my exact issue here, because I still want to try to work through it myself, but I'm extremely confused on how you can write and implement a script for both MySql and Microsoft Excel. Currently, I'm on a Macbook Pro using Terminal and MySql Workbench for work in databases, and I edit the few scripts I do write in the Vim editor. When it come to Excel, I'm clueless.

Are both of these situations made possible by writing scripts in my vim editor? If so, what do the extensions need to be and how can I link them to servers that I typically SSH into? The syntax of such scripts makes a little sense to me, but I'd be able to pick up on it a lot faster if I could practice it myself. I just don't even know how to start.

I'd appreciate any help or points in the right direction. If possible, try to explain things as nooby as you can. Act like I'm really new at this please. Thanks guys!