Category: Tutorials
SQL Tutorial 10: Advanced SQL Techniques
Level up multi-step SQL with CTEs for readable named steps, window functions like ROW_NUMBER and running sums on detail rows, and a small conceptual recursive example you can…
SQL Tutorial 9: Views and Indexes
Reuse logic with views and speed lookups with indexes on everyday customer and order queries. Learn what each database object is for, how teams share meaning safely, and…
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…
