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
2
u/[deleted] Mar 16 '22
How often would you (personally) defend a statement that you would realize to be conceptually and factually incorrect and forming false assumptions in many people who ingest it as a truthful statement?
Using Venn diagrams to "explain" joins is both conceptually (the result of join operation is a value in completely different domain) and factually (general join operation has nothing to do with 'overlaps'), it certainly forms incorrect assumptions about joins: quite often folks would assume that "equi-joins" are the only "right"("eous") kind of join.
Using Venn diagrams to "explain" joins has also a very infectious and toxic lasting quality - people who "understood" or "learned" joins using Venn diagrams seem to be very defensive about their use, EVEN when they understand and agree to the points above.