Re:A CS degree is better than teaching yourself how to code?
by scarface74 on Sunday November 03, 2019 @08:01AM
(#21433617)
I’ve never taken a relational algebra class in my life and neither have most dba’s. They learned sql by learning sql.
Re:A CS degree is better than teaching yourself how to code?
by roywiggins on Sunday November 03, 2019 @11:34AM
(#21434826)
That's of course a perfectly good way to learn SQL and probably much cheaper. I'm not saying that you need relational algebra to write a query, that would be silly. I just mean that learning that stuff does stick with you.
Like, knowing that automata and complexity theory exists and remembering roughly how it works means that if something that needs that comes up, at least you have a sense of what you forgot about it.
For instance, having taken a database class where we worked in the relational algebra has helped me fluently write okay SQL even if I couldn't write out a sentence in the relational algebra to save my life.