I always see the programmer sentiment that “people should not be using excel for (project). It should be a database.”
I am guessing by that they mean SQL? I dont know a thing about that except the acronym. The most ive done is a basic linux script and 2 hours of a VBA course. I suck at understanding programming, so id like to understand exactly how one uses a database vs excel. Like whay are the actual steps id have to do?
Doesn’t have to be SQL. But most of the time that quote refers to a relational database.
Nowadays there are graphical tools that are alright, such that you don’t have to learn a query language. Such as (1), (2) or more commercial (3).
But what’s still important is doing good relational database design. Learning to look at the world as entities and relationships between them. There’s books and courses on that. While you’re at that, you’ll probably learn SQL along the way, as it’s so convenient.