4 ms·
I've met plenty of people who have worked in computing for some time and have problems understanding anything more than an inner join with SQL. However, this ar
by jemmyw 2y ago
I've met plenty of people who have worked in computing for some time and have problems understanding anything more than an inner join with SQL. However, this article is really bad. Their relization is that SQL is a program is bizarre in both simplicity - everything running on your computer is just a program of sorts - and not the problem most people need to overcome to understand SQL. And what do they even mean by program? Some databases are talking to another running program that executes your queries, others are using libraries and executing as part of your own program.
What most people who struggle with it are failing on is having a mental model of how it is operating on sets of data. You're working in a procedural language and interacting with something that is not procedural. It flummoxed me for awhile in my first job. I feel lucky that my first job was very heavy on the database side, and had me converting from a file+cursor based database to a SQL database.