Kevin Naughton Jr.

Feb 13, 2024 | zaidesanton.substack.com | Anton Zaides |Zach Wilson |Ian Vanagas |Kevin Naughton Jr.

I divided the SQL knowledge into 6 stages. I’m not an SQL expert (you can read my mistakes in ‘How I destroyed the company’s DB’) and I probably missed some stuff, so take it as a generalization: Very basic - select, from, where. Basic - group by and having. Beginners - joins - left/right/outer/inner/self join Intermediate - subqueriesMost people stop after learning this stage, and it’s a shame.