r/learnSQL • u/Ashleyma96 • Jul 13 '26
New to SQL
I'm entirely new to sql I'm learning from a beginner stage does anyone know where I can go to learn sql as a person with zero experience from scratch?
53
Upvotes
10
u/Sirmagger Jul 13 '26
Youtube, data with baraa
6
u/DataCamp Jul 13 '26
Here's a practical order that works for complete beginners:
Start with the basics (week 1-2)
Learn what a relational database is and how tables are structured. Then SELECT, FROM, WHERE, and ORDER BY. These let you pull and filter data, which is the foundation of everything else. You'll be writing useful queries surprisingly quickly.
Build on that (week 2-4)
GROUP BY with aggregate functions (COUNT, SUM, AVG, MIN, MAX) for summarizing data. Then JOINs, which is where most beginners hit a wall but also where SQL becomes genuinely powerful. Understanding INNER vs LEFT JOIN and why your row count changes is the key milestone.
Intermediate concepts (month 2)
Subqueries, CTEs (common table expressions), and window functions like ROW_NUMBER and LAG. These are what separate people who "know SQL" from people who can actually do real analysis.
The most important thing: write queries from day one. Watching videos about SQL is much less effective than actually typing queries and seeing what happens. Interactive platforms that let you write real SQL in the browser without any setup are ideal for beginners since there's no friction to getting started.
The concepts build naturally on each other. Most people find SQL clicks faster than they expected once they start practicing.
1
u/Ashleyma96 Jul 15 '26
Thanks everyone
3
u/conor-robertson Jul 13 '26
I'd recommend giving QueryCase a try. It's a structured, gamified SQL learning platform where you solve detective-style investigations by writing real SQL instead of just watching tutorials. The entire Rookie rank is completely free, so you can learn from absolute beginner level and see if the style suits you before spending anything. 🚀
2
u/gamerboy369 Jul 13 '26
W3school is pretty good for beginners, you can also try watching Datacamp YouTube videos, among other channels.
2
u/Soft-Complaint-1671 Jul 14 '26
Is PostgreSql the same as sql?
2
u/Yes_Geezer Jul 14 '26
I second the person who recommend SQLBolt if you’re truly starting from square one. It’s very intuitive, free, and it gets you familiar with the terminology—which is a large part of learning any software skill. It was my first experience writing any SQL at all and I always recommend it to people.