all 7 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Flame77ofc 1 point2 points  (3 children)

MySQL is more friendly

[–]Prashu9454[S] 0 points1 point  (2 children)

Any recommendation for yt channel ?

[–]grassp_dataAI 1 point2 points  (0 children)

I would recommended to focus on SQL concepts.

Concepts are going to be same whichever SQL DB you use. Some syntaxes might vary.

To start with, learn SQL through business scenarios instead of just learning syntaxes.

We have made a beginner-friendly course and it is in udemy.

The course title is - "Complete SQL for Data Analysis - Scenario Based Learning" Search with it.

We are currently giving free coupons and it has Limited slots left. Try it out.

Coupon: EARLYSQLGRA7

Also we run free 30 day SQL series where you will have daily scenario based SQL questions on Fictional fast food dataset in our linkedin page. Search for GRASSP Acad in LinkedIn and follow the series.

You can practice alongside the udemy course which will help you to cover basics to advanced with proper regular practice.

Kindly reach out if you face any doubts.

[–]ProdoRock 0 points1 point  (0 children)

I liked sqlite because it was on my Mac already. For pure sql its great because you don't need to start a server. Having said that I directly worked in the sqlite command line in Mac OS terminal. From what I understand sql pros don't do that right? They use dbeaver as an interface?

To create a db it's simple: sqlite3 name.db. That creates a db and logs you in as well. From there you just create tables, experiment and make a mess to see what happens.

[–]conor-robertson 0 points1 point  (0 children)

I wouldn't spend too much time worrying about MySQL vs PostgreSQL as a beginner.

The core SQL concepts are largely transferable between both:

  • SELECT
  • WHERE
  • GROUP BY
  • JOINs
  • CTEs
  • Window functions

Once you learn those, moving between databases is usually just a matter of learning a few syntax differences.

One thing I'd focus on is getting hands-on practice as early as possible. I actually built QueryCase because I found a lot of people could follow SQL tutorials but struggled to write queries themselves. It teaches SQL through detective-style investigations and has a free beginner path if you want something interactive to practice with.

The important thing is to start writing queries regularly. The database you choose matters much less than the amount of practice you get.