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

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

This is good advice but sometimes you will need to nest things depending on database and optimizer and how it handles CTEs, especially if you ever mess with recursive things. An additional problem here is that there’s no standard way to represent EXPLAIN queries across systems so that makes an additional barrier to entry unfortunately.

[ Parent | on HN ]

Re:Challenges students face when learning to work with relat... by tpetry on Sunday August 29, 2021 @10:09PM (#28352217)

> An additional problem here is that there’s no standard way to represent EXPLAIN queries across systems so that makes an additional barrier to entry unfortunately.

What so you mean by this?

[ Parent | on HN ]

Re:Challenges students face when learning to work with relat... by prpl on Sunday August 29, 2021 @10:51PM (#28352400)

The outputs from each DBMS are often specific to their implementation, even when there is a lot of overlap. The good news is they are usually similar enough and user friendly enough that an advanced user will have no issue but for beginners it can be daunting.

[ Parent | on HN ]

Re:Challenges students face when learning to work with relat... by fomine3 on Monday August 30, 2021 @02:55AM (#28353315)

Anyway beginners learn by just using single RDBMS, isn't it?

[ Parent | on HN ]

Re:Challenges students face when learning to work with relat... by prpl on Monday August 30, 2021 @06:35PM (#28361734)

Not necessarily. I often see people learn starting with SQLite because it's easy/installed (and quite a bit of tutorials start with it, especially for Python), and then move to MySQL/Postgres, but that is N=2 so it's not too bad.

[ Parent | on HN ]