Day 273 of writing every day.
Learning the keywords to use to fine-tune queries with SQL can be a pain. I prefer to master one DBMS and then compare some of the differences in how one would use them rather than get information simultaneously about how something would be written in one DBMS vs another. Imagine learning English but being taught both the British spelling and American spelling of things at the same time while learning it as a second or later language. It’d be much more sensible to get a solid grasp of one or the other inzg
The complexity of SQL is in the relationships amongst data, and I think many people find relationships quite complicated no matter how simple things appear. Bad pun aside, SQL’s complexity lies in its simplicity I think. It’s not the huge library of commands, functions, calculations, etc. that makes it challenging to use. I’d compare it to having a small toolset that’s able to do a wide range of things but really needing to learn how to use it first beyond the simplest of tasks.
Selecting a column from a table and using where to set the conditions for what data to extract, and how to order it seems simple enough in Excel, but doing it with code is a different story and requires a lot more learning and practice just to do something an application built with a lot of code and improved over many years can do with some clicks selections.
Thanks for reading!
One Chance Works 