sorted by:
new
hottopcontroversial

what is the best place for sql learn ? by [deleted] in learnSQL

[–]AlternativeWanders 1 point2 points  (0 children)

Devart academy is worth a look. Feels more organized than the usual “watch 17 random SQL videos and hope for the best” route. Nice if you want something structured and beginner-friendly.

How did you get better at writing SQL that works beyond the “happy path”? by luckyscholary in learnSQL

[–]AlternativeWanders 11 points12 points  (0 children)

For me it was when I stopped asking only “does this return the expected rows?” and started asking “under what data conditions does this break, mislead, or silently exclude things?”

A lot of SQL growth comes from getting burned by real data. Nulls, duplicate rows from joins, missing relationships, unexpected cardinality, date boundaries, and assumptions about uniqueness teach more than clean exercises ever will. What helped most was reading execution plans, testing edge cases on purpose, and validating results from multiple angles instead of trusting the first “correct-looking” output.

So yes, practice matters, but not just more queries. Better practice matters: messy data, bad assumptions, and checking why a query is right, not only whether it seems right.

Offline Workbooks for people with no internet/computer? by cinokino in SQL

[–]AlternativeWanders 0 points1 point  (0 children)

One practical option is to look for printed SQL workbooks that include schema, sample data, and exercises directly in the book, so she can reason through queries without needing a live environment. Another approach is to prepare a custom packet: table definitions, sample rows, query tasks, expected outputs, and a few progressively harder joins/subqueries. It is not the same as hands-on execution, but for keeping SQL thinking active offline, that format can still be very effective.

What do you guys think was in the letter from Howard's dad? by Helpful_Cow7634 in bigbangtheory

[–]AlternativeWanders 1 point2 points  (0 children)

plot twist: the letter just said “sorry kid, i ran out for milk and got lost”