SQL Playground

a quick taste, runs in your browser Install on your machine

Getting ready...

This is a quick taste, not the place to practise. The full RetailMart database is here so you can explore and try queries. Each table downloads the first time you use it, everything runs on your own device (slower on a phone), and nothing you do is saved. For real practice, install PostgreSQL and load the database on your own machine.

Try an example

Your query

Ctrl/Cmd + Enter to run

Just a taste. This is the full RetailMart database: 55 tables and about 2.4 million rows. A table downloads when a query first uses it (the biggest, web_events.page_views, is 21 MB), then stays cached in your browser. Everything runs on your own device, so big queries take longer on a phone. Anything you create or change disappears when you reload. To practise for real, follow the setup guide to run it on your own machine.