Guide 🗄️ Learn SQL in one weekend — the free plan that actually sticks (2026)

If you learn ONE technical skill this month, make it SQL.

Every data job description asks for it. Every analyst interview tests it. And here's the secret nobody tells beginners: you don't need three months. The 80% of SQL that covers 95% of real work fits into a single focused weekend — free tools, zero setup cost, laptop optional.

This is the exact weekend plan I'd hand a friend today.

---

Saturday morning (2 hrs): the core 6

Install ONE tool: DB Browser for SQLite (free, works offline) or open sqliteonline.com in a browser tab. Then learn the six clauses that run the world:

• SELECT — pick your columns
  
• FROM — pick your table
  
• WHERE — filter rows
  
• ORDER BY — sort
  
• LIMIT — top N
  
• DISTINCT — unique values
  

Code:

SELECT name, city, monthly_salary FROM employees WHERE monthly_salary > 50000 ORDER BY monthly_salary DESC LIMIT 10;

Play with these until you can answer tiny questions by hand: "top 5 salaries in Bengaluru?", "how many people in each city?" — don't rush past this, it's the muscle everything else hangs on.

Saturday afternoon (3 hrs): GROUP BY + JOINs — the superpowers

GROUP BY turns raw rows into answers. Commit this pattern to memory — it's asked in 9 out of 10 interviews:

Code:

SELECT city, COUNT(*) AS people, AVG(monthly_salary) AS avg_salary FROM employees GROUP BY city HAVING AVG(monthly_salary) > 40000 ORDER BY avg_salary DESC;

Then learn just two joins (skip the rest for now):

• INNER JOIN — rows that match in BOTH tables
  
• LEFT JOIN — all rows from the left table, matches where they exist
  

Code:

SELECT o.order_id, c.name, o.amount FROM orders o INNER JOIN customers c ON o.customer_id = c.id WHERE o.amount > 1000;

---

Sunday morning (3 hrs): real data, real mess

Toy tables are fine for syntax; confidence comes from messy reality. Grab one free dataset (our field guide has the best free sources → https://data-forums.com/Thread-Guide-%F0...ield-guide), import the CSV into DB Browser, and answer five questions you invent yourself. Getting stuck and Googling your way out IS the training.

Sunday afternoon (2 hrs): prove it in public

• Do 10 free practice questions — slate: SQLBolt (lessons 1–12) → HackerRank SQL "easy" set → LeetCode top 50 SQL (free tier)
  
• Write up your mini-analysis as a project — screenshots of queries + 3 insights. Our portfolio guide shows exactly how to package it → https://data-forums.com/Thread-Guide-%F0...jects-2026
  

The 6 traps beginners faceplant on

1. Forgetting GROUP BY needs every non-aggregated column listed
   
2. Using WHERE on an aggregate (that's what HAVING is for)
   
3. NULL silently eating rows — always test IS NULL / IS NOT NULL
   
4. JOIN fan-out: sudden duplicate rows because the match wasn't 1:1
   
5. Counting rows when you meant count of uniques: COUNT(DISTINCT id)
   
6. Memorizing syntax instead of practising questions — syntax fades, patterns stay
   

One weekend won't make you a database engineer. But it WILL put SQL on your resume honestly, let you pass screening rounds, and unlock pandas/PowerBI far faster.

Got stuck somewhere this weekend? Post your error below — this community unblocks fast. 💪

More free Data-Forums guides → https://data-forums.com/Thread-Guide-%F0...21-growing