News for hackers. Stuff that matters.
Re:Ask HN: Junior SQL developers – How do you learn SQL? by coopreme on Thursday March 11, 2021 @08:49PM (#26431398)
T-sql with pencil and paper. Visualize the problem with tables and relationships (boxes and lines with crows feet). Going through normal forms may be valuable but I like to tell them to just jump to entities and relationships. Once they can draw a “map” of their dB, and it’s usually much simpler than they first expected, then code it out on the nearest computer box.
Re:Ask HN: Junior SQL developers – How do you learn SQL? by s-stude on Friday March 12, 2021 @03:17AM (#26433339)
So you are talking about the db structure itself. How would you approach the SELECT part? All those nested sub-queries, CTEs, and complex EXISTS cases?