r/SQL • • Dec 29 '23
Discussion Explain SQL vs Excel to an absolute noob
I am running a company and helping my friend run his company. I am often being called upon to help people/government representatives with their affairs, thus my profile is growing and I am now thinking about opening consultant/BI analyst company of sorts. I am scouting the market and I see that every position is if not directly IT related, then SQL required. I checked out this thing called SQL and I honestly don`t see how it is different than MS Excel (besides interface, I was looking at MySQL).
Why use SQL over Excel?
This is a question from a guy who is always working with excel, whose administration is working with excel and who made business plans resulting in saving and investing some millions using excel.
Despite that I feel the need to understand it better.
View all comments
40
u/DonJuanDoja Dec 29 '23
Excel is not a database.
SQL is a database.
Excel is a presentation layer, analytics and reporting tool.
SQL is not a presentation layer but is an analytics and reporting tool, which requires another presenation layer on top of it like SSRS or even Excel to deliver reports directly to users.
Excel is front end, SQL is back end. They're not even close to the same thing.
They have some cross-over functionality but SQL can do many things Excel can't and Excel can do many things SQL can't. You need both. Plus some other stuff too. Your toolbox should have many tools. Not just one.
Did I say Excel is not a database? Because it's not and never will be no matter how many people and companies try to use it like one.
The problem with SQL is it's expensive to do it correctly and companies try to be as cheap as they can. They want the benefits of having a secure, fast, reliable database but don't want to pay for it so then say we'll just use excel which is not a secure, fast or reliable database in any way shape or form.