News for hackers. Stuff that matters.

A comment on The Curious Case of the Aggregation Query. Parent comment

Re:The Curious Case of the Aggregation Query by uticus on Tuesday December 05, 2023 @04:30PM (#38537174)
> I'd teach them relational algebra...

Agreed. Curious what materials you've found that really drive this home?

Like 90% of googlesearch results simplify things to the point where this is missed.

[ Parent | on HN ]
Re:The Curious Case of the Aggregation Query by Tallain on Tuesday December 05, 2023 @06:12PM (#38538253)
SQL Server Central has a "Stairway to T-SQL" series that starts off with some light history and then has two fairly decent chapters diving into the mathematics of SQL. It's not intensive by any means, but more than most other resources (and even some textbooks I've read).

[0]: https://www.sqlservercentral.com/stairways/stairway-to-t-sql...

[ Parent | on HN ]
Re:The Curious Case of the Aggregation Query by formerly_proven on Wednesday December 06, 2023 @09:05AM (#38544035)
A lot of the Relational Databases course materials in CS programs is built from Oracle educational material; it's probably freely available for many universities. I always assumed the approach outlined by GP is the default way to teach SQL and relational databases.
[ Parent | on HN ]