Re:Knowledge Graphs
by jackpirate on Friday October 22, 2021 @01:21PM
(#28959963)
As someone who teaches python+sqlite in an intro to cs course, I can't disagree with this statement more.
SQL is amazing but the mental model beyond inner joins is not at all obvious. Things like outer joins (and when you need them), aggregation, partitioning etc... I am sure I've missed a few things.
But SQL is absolutely amazing.
You have to understand the data and the relations, what's not in the data that you'd expect to be etc...
... except they cannot possibly be like the relational model in that way, because the relational model isn't like that. The value of relational databases becomes readily apparent when you spend five minutes fiddling with a appropropiate small-but-nontrivial relational database; you do not need to spend a [nontrivial] amount of hands-on time with them before their value becomes readily apparent.