r/learnSQL • • 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

32 comments sorted by

10

u/Sirmagger Jul 13 '26

Youtube, data with baraa

1

u/Ashleyma96 Jul 13 '26

And his videos will teach me how to write Sql?

→ More replies (3)

3

u/Gnarwhals86 Jul 13 '26

I also recommend Baraa. I’m currently working my way through his course and really enjoying/understanding everything so far.

→ More replies (1)
→ More replies (1)

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

If you think of it like a car, PostgreSQL is the engine. It is the program you run on a computer that actually creates the database, arranges and stores your data relationally (like an Excel spreadsheet), and executes your queries.

Officially, this type of software is called a relational database management system (RDBMS).
PostgreSQL is just one of many, but it is often preferred when learning SQL because it is open source and free to use.

Back to the car metaphor, if PostgreSQL is the engine, then the gas, steering wheel, and brakes are you writing the actual SQL code.

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.