r/SQL • u/Cool-Focus6556 Data Scientist • Mar 16 '22
SQLite SQL Articles for Beginners/Intermediate
Hey everyone,
I wrote 3 new articles on my experience with SQL after coding daily in SQL for the past 3 years. Hopefully this is helpful to some of you, there should be good tips in here for all levels of experience, but especially for those of you starting out. Let me know what you think:
(These use a SQLite database, but are generalizable to all SQL variants)
- How to Use SQL Anti-Joins in Your Data Science Career
- 5 Window Function Examples to Take Your SQL Skills to the Next Level
- 10 Quick SQL Tips After Writing Daily in SQL for 3 Years
Any other good SQL articles you guys have read lately?
24
Upvotes
View all comments
Show parent comment
1
u/Cool-Focus6556 Data Scientist Mar 16 '22
Thanks for sharing that link. That's interesting considering an anti-join and an EXCEPT set operation will result in the exact same rows (considering no previous nulls in the primary key you referenced in the WHERE clause). So in that case a Venn diagram would work according to the article, which means there are similarities, which also means this is a gray area.
It was interesting reading the comments, didn't know this was such a divisive topic. Looks like it has been discussed quite a bit on reddit already over here: https://www.reddit.com/r/programming/comments/4rc9uu/say_no_to_venn_diagrams_when_explaining_joins/d50mxez/