Pathwise

Manuals / SQL / Guide 1

Start · beginner · ~15 min · Guide 1 of 12

How to use this SQL path

SQL is read-first: master SELECT before writing mutations. Use SQLBolt or SQLite locally. Checkpoints ensure you can join and aggregate before touching transactions.

Path progress
3%

Step 1 of 3

Pick a sandbox

SQLBolt in browser, or sqlite3 CLI with a sample .db file. Postgres later — syntax is 95% the same for basics.

Pick a sandboxDrag stickies · tap for tips
Study mapDrag stickies · tap for tipsKeep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Assert the UIdrag · tap →Retry wiselydrag · tap →Seed datadrag · tap →Close the loopdrag · tap →Keep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Pathwise hackdrag · tap →Pick a sandboxdrag · tap →Try thisdrag · tap →Follow the dashed drag · tap →

Do this now

Complete SQLBolt lesson 1 today. Bookmark the site.

Was this step clear?
Chapter learning outcomes
  • Sandbox setup
  • Read before write
  • Safety rituals for mutations

Clear these before you leave

Side quest

First query

SELECT * FROM users LIMIT 5; — save as queries/01_select.sql.