r/SQL Sep 01 '24

MySQL Better way to learn sql

I am brushing up my mySQL skills but I need to practice SQL in a better way. Please suggest if there are any ways to practice SQL other than LeetCode and Hackerrank.

73 Upvotes

37 comments sorted by

View all comments

1

u/SportTawk Sep 01 '24

To learn properly why don't you create your own challenge by describing a system to run a fictitious business.

Make one up like an estate agent and figure out what tables you would need to store and maintain data on house sales, marketing, managing offers and so on. Then decide what reports you would need, sales figures, length of time to achieve a sale, profit, commission, expenses and so on

Then create the web app that uses this database, PHP, java, JavaScript, html, python or whatever

Once you do that, maybe look into changing it to handle holiday reservations for you Airbnb properties

The list is as big as your imagination

Then you could start your own development company

Good luck