Challenges students face when learning to work with relational databases and SQL

Re:Challenges students face when learning to work with relat... by MeinBlutIstBlau on Sunday August 29, 2021 @05:56PM (#28350833)

same with the joins. on paper it makes sense, in practice it does not. if its more than a "select * from dbo.whatever where column abc = 'thing'" i have to refer back to notes and play with it.

[ Parent | on HN ]

Re:Challenges students face when learning to work with relat... by eurasiantiger on Monday August 30, 2021 @01:18AM (#28352992)

Basically inner/left/right is a choice on how you want your NULLs: do you want all the rows that match, all the rows on the left, or all the rows on the right?

[ Parent | on HN ]