Where to practice SQL
Choose where to practice SQL by your goal, then run a small PostgreSQL exercise to check results, spot missing values, and plan your next practice session.

Level 1: Newcomer
0 points
Sign in to save your progress across devices.
Posts about SQL: tutorials, interview questions and study guides, each linked to practice in your browser.
RSS feedChoose where to practice SQL by your goal, then run a small PostgreSQL exercise to check results, spot missing values, and plan your next practice session.

Compare LEFT JOIN vs. LEFT INNER JOIN in PostgreSQL, fix invalid syntax, and check which employee rows LEFT JOIN and INNER JOIN keep with a runnable example.

These 10 questions progress from defining a row to handling concurrent writes, with model answers, production follow-ups, and two runnable PostgreSQL tasks.

Use this SQL cheat sheet to choose clauses, filter orders, group city totals, and check results with a runnable PostgreSQL example and a missing-value check.

Learn SQL JOIN and LEFT JOIN with a runnable PostgreSQL example. Check missing matches, repeated rows, and filters to choose the right join for your report.

Calculate a running total in SQL with a window function: a runnable PostgreSQL example, a safe order for tied dates, and how it differs from GROUP BY.
