StartBeginner15 min read
1. How to use this SQL path
SQL · 48 pages source format
SQL is read-first: master SELECT before writing mutations. Use SQLBolt or SQLite locally. Checkpoints ensure you can join and aggregate before touching transactions.
What you'll learn
- Sandbox setup
- Read before write
- Safety rituals for mutations
Pick a sandbox
SQLBolt in browser, or sqlite3 CLI with a sample .db file. Postgres later — syntax is 95% the same for basics.
Do this now
Complete SQLBolt lesson 1 today. Bookmark the site.
Clear?
Study pace
45–60 min/day. Week 1: SELECT/WHERE. Week 2: JOINs/agg. Week 3: mutations/transactions/indexes.
Do this now
Create sql-notes/ repo with queries/ folder for saved .sql files.
Clear?
Job-ready definition
You are ready when you can: write a 3-table join, aggregate with GROUP BY, wrap updates in a transaction, and explain what an index does.
Do this now
Add checklist to sql-notes README.
Clear?