Blog · Guide

SQL Practice Exercises for Beginners (Free to Start)

A beginner path: SELECT, WHERE, ORDER BY, then JOINs — with drills you can run in your browser.

first_name city age Maya Austin 29 Luis Chicago 41
Columns = named fields. Rows = one record each.

What to practice first

  1. SELECT — pick columns
  2. WHERE — filter rows
  3. ORDER BY + LIMIT — sort and take top-N
  4. JOIN — combine customers and orders
  5. GROUP BY — counts and totals

One shop dataset

Northstar Market uses customers, orders, order_items, and products. Learn the business once; reuse it in every drill.

Try it yourself

The fastest way to lock this in is a short drill on the same Northstar Market tables.

Start the beginner path

Related guides