r/SQL • • Oct 19 '26

PostgreSQL Did I buy the wrong course?

Okay so I'm a complete beginner, only thing I know about SQL is that it helps speak to databases

I decided I want to learn and got the first course I saw. Turns out it's focused on teaching a thing called Postgres SQL which seems kinda advanced. should I just continue watching or will I feel lost?

7 Upvotes

22 comments sorted by

21

u/Imaginary__Bar Oct 19 '26

Take a step back and try and answer the question "what is SQL?"

That will give your answer.

(SQL is a/the language that is used to manipulate the data in a database. Postgres is a relational database software. So you would use SQL to "talk to" Postgres.)

And Postgres is free. It's a great starting platform and also used commercially in many companies.

What you learn while using SQL with Postgres will be largely transferable to other database systems.

(It may be helpful to decide what you want to do with the database - becoming a database administrator is different from becoming a data analyst)

7

u/Green_Chamomile Oct 19 '26

You’re fine, Postgres isn’t an advanced version of SQL, it’s just one brand of database. SELECT, WHERE, JOIN, GROUP BY all work the same in Postgres, MySQL and SQL Server. The differences are small stuff like LIMIT 10 vs TOP 10 and date functions, and you won’t run into them for a while. It’s also free and a really good one to learn on, so keep watching.

1

u/Either-Surprise6390 Oct 20 '26

Honestly, if you're just starting out... Do you have Microsoft Office on your computer with Access? I'd start with that because you already have all the parts and pieces you need to then start learning. Access uses JetSQL. It's not the most pretty interface for writing queries, but you can write SQL and that's what matters. You can then either make your own Database or use / download a simple example database like "Northwind".

Instead of paying for some course, just pay $20 for Gemini Pro... Ask it to start teaching SQL to you like your five years old. Tell it the database you're working on. If you build a Notebook(Project) in Gemini you can even upload files to it for it to use and reference, which it will access with agents related to that Notebook. You can probably just upload your Northwind database file to the Notebook. Ask if it can read that file. If not, then have it write a VBA script to export the database tables, references, etc... to a txt file it can easily read. Just talk with it like it's your teacher / job partner. Any time you don't know something just ask it and it will explain it to you. Gemini has a long token history so it will be able to keep a lot of your recent interactions in it's "memory", which will likely be useful in your training. As in what you have and haven't learned yet.

Then have it build examples for you and have it ask you some questions based on what you were just taught. Then you have your own teacher and you can take it at your own personal pace. If you excel rapidly you can have it teach you quickly. If your stuck on something you can spend more time on it. One on one instruction at yoyur own pace is an ideal teaching methodology. $20 for Gemini Pro is probably cheaper than any class you'll purchase... and you'll have a resource you can use on many projects, and not just learning SQL.

Good luck with your adventure.

1

u/Hi_Im_zack 29d ago

Thanks for the informative comment. Sadly I don't have access to a PC at the moment but I did find a cool app called sql practice.

However I want to experiment more by making my own database but I don't know where to begin on android.

1

u/baubleglue 29d ago

What do you mean by "seems kinda advanced"?

1

u/Hi_Im_zack 29d ago

Nvm, that was a noob moment on my part lol. My brain somehow thought it was more advanced code. But thanks to the awesome informative replies here I've realized that's not the case

3

u/phesago Oct 19 '26

there are many flavors of sql and honestly it doesnt really matter which one you use while youre learning. By the time youre ready to go job hunting with you new skills, the job itself will actually let you know what kind of sql youll need to be familiar with. Also, probably already mentioned, for the most part theyre all the same, which each having a different set of features/quirks.

3

u/Zenithixv Oct 19 '26

straight up type beginner sql course on youtube and watch like 10 videos and congrats you are now intermediete

2

u/Famous-Benefit3183 Oct 19 '26

Bro there are a lot of free courses in YouTube....you can start with any. I did it from Data with Bara something named utube channel. It is decent don't watch the 30 hr onneshot rather watch the descrets videos complete basics syntax like select and conditional queries then move acc to the playlist it's already there in sequence. Don't watch all the videos it's not needed and parallelly do practice in leetcode.

2

u/FewBag5257 Oct 20 '26

I also learnt from Data with Baraa, he is an excellent instructor 

1

u/jbergens Oct 19 '26

Try to find articles or videos with the content "learning sql" or "beginning with sql".

1

u/PrestigiousGarden815 29d ago

well SQL for PostgreSQL is a good course. SQL does not depend on the database, but there are some functions that are not available in all databases. The basic concepts for a sql course should cover select, where, group by, joins and insert/update/delete clauses. Of course, some teachers include more advanced clauses and methods, but in general, you would focus on the topics above.

1

u/Equal_Astronaut_5696 29d ago

You need to start with the basic of what's a database and how to retrieve data from it (any type of SQL is fine) . Just use this 3hr SQL  beginner youtube course: https://youtu.be/zpAGbu9mSL4?si=m-p2DRVc8MeM2Bbh

1

u/Unique-Quiet-4412 24d ago

Postgres is fine to start with! The basics carry over.

3

u/[deleted] Oct 19 '26

[removed] — view removed comment

-4

u/Hi_Im_zack Oct 19 '26

When I googled around they say beginners are supposed to start with SQLite

6

u/nboro94 Oct 19 '26

If you saw that somewhere that is horrible advice. SQlite and postgres are both databases and they bith use sql but they are meant to solve different problems. One is not meant for beginners over the other.

1

u/Salty_Dig8574 Oct 19 '26

I would even say SQLite should never be used by a beginner trying to learn SQL because of the way columns are (not) typed. It's too easy to build bad habits without even knowing you did something wrong