SQL is not hard at all. It’s just all about syntax. You need to learn two parts: SQL basic commands (such as join, group by, order by) and SQL window function (such as row_number(), partition by).

Tutorials:

  • Udemy SQL intro course. It covers all basic SQL commands. I knew nothing about SQL when I took the course, so I learned a lot as a beginner. If you’re already familiar with SQL. You can go ahead and use the resources below to practice SQL product questions.
  • Mode Analytics. I have not checked this one but lots of people recommended to read the tutorial. It also covers window functions.
  • W3School. A good place to check for syntax and example of SQL command.

Practice SQL questions:

  • Leetcode. ~ 120 questions
  • Hackerrank

If you don’t feel like installing SQL on your local machine. SQLfiddle is a good place to experiment and build your schema.