SQL from Zero to Pro #6: Subqueries (Nested Queries)

Time for advanced SQL with a super useful concept: subqueries. What you'll learn What a subquery is, and where you can use one Add a computed column, replace a table, filter with IN Copy, update or delete rows based on a result Work around MySQL error 1093 What’s a subquery? A subquery is a SQL query nested inside another query, between parentheses. You can use it in SELECT, FROM, WHERE, HAVING, and even in INSERT, UPDATE or DELETE. ...

November 19, 2026 · 4 min · 698 words · Naimi

SQL from Zero to Pro #7: Joins (INNER, LEFT, RIGHT, FULL JOIN)

If you’ve ever worked with several tables, you’ve surely needed to cross-reference their data. That’s exactly what joins do: they link information spread across different tables to get useful results. What you'll learn Visualize joins before writing them INNER JOIN, LEFT JOIN and RIGHT JOIN, with prefixes and aliases Emulate a FULL OUTER JOIN in MySQL with UNION Replace a subquery with a join Visualizing joins The easiest way to understand joins is a circle diagram (like the ones on sql.sh), before you even write the query. With two tables A and B: ...

November 19, 2026 · 5 min · 935 words · Naimi