Category: SQL
SQL Tutorial 8: Modifying Data with SQL
Change data safely with INSERT, UPDATE, and DELETE on the customers and orders toy schema. Practice row adds, targeted edits, and careful deletes, plus a light take on…
SQL Tutorial 7: Subqueries in SQL
Subqueries nest one query inside another so you can filter and shape results with answers from other answers. Learn scalar, IN, EXISTS, and derived tables on the customers…
SQL Tutorial 6: Joins in SQL
Connect customers to orders with INNER and LEFT joins, using keys on purpose. Learn how join grain can explode row counts, when not to join, and how to…
SQL Tutorial 5: Aggregate Functions and Grouping Data
Turn rows into summaries with COUNT, SUM, AVG, MIN, and MAX. Group with GROUP BY, and learn when HAVING filters groups while WHERE filters rows, so your totals…
SQL Tutorial 4: Filtering and Sorting Data in SQL
Filter rows with WHERE, combine conditions with AND and OR, and use IN, BETWEEN, and careful LIKE patterns. Sort with ORDER BY and learn NULL basics so your…
