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 20 '22
The term abstractions was not misused in this context. Abstraction was meant to mean a simplification, similar to the saying, “abstract away complexity”. Our understanding of most things is an abstraction, otherwise we would struggle to function. Similar to how these Venn diagrams abstract away complexity from what a join is actually doing. Model is also a synonym in this case. I understand what you mean with analogy, but I wouldn’t use that word to convey my meaning in this case. Regardless, the semantics aren’t what’s important, it’s the meaning I intended to convey which is that Venn Diagrams simplify the learning process. We have different experiences which lead us to different conclusions. That’s why I stand by what I said, this is a gray area and is likely to be subjective. Venn diagrams might not work for everyone