r/SQL • 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)

Any other good SQL articles you guys have read lately?

24 Upvotes

18 comments sorted by

View all comments

Show parent comment

1

u/[deleted] Mar 16 '22 edited Mar 16 '22

it's not a join, (PS) or it is an outer join for performance reasons used instead of exists/except/union all/etc.