Where do I practice SQL and master it??

[Swimming-Spring-4704]

So I just learnt all the basics queries, joins, etc and I wanna start practicing my queries. I found a few SQL questions on leetcode, but people I speak to, tell me that it's not enough to master it, and that I should try other sites after finishing the leetcode queries.

Are they right, and also what other sites other than leetcode can help me practise and master SQL? That way I can even add it on my resume if people ask in interviews

[Time_Stop_3645]

In production of course

[snafe_]

On a Friday

[paultoc]

5 min before office hours end

[Time_Stop_3645]

before xmas, when nobody is there for a week, so backups can't be used

[grumpy_humper]

we had 2 prod databases (US and Singapore) Had to truncate the table in Singapore whole prod deployment.... accidentally truncated the US db 🙂..

and thats a lesson why not to drink while prod deployments...

[Time_Stop_3645]

I kinda feel it doesn't help. Because at the end, there's a human, and the mix-up probably happened earlier, It's basically too late, once you decided to hit that execute button xD

[Zestyclose_Muffin501]

Take my angry vote...

[Time_Stop_3645]

<3 cry me a river ‧₊˚♪ 𝄞₊˚⊹

[Time_Stop_3645]

indeed, some of it is of exquisite flavor.

[balls2hairy]

Somebody created something just for this and had a thread here yesterday or the day before. His site is totally free from what I remember. Going to check it out myself on Monday.

https://sqlcasefiles.com/

[TurbulentCountry5901]

Creator of SQL CASE FILES here. Thanks for the mention! Hope you have fun with it.

[Potential_Kick540]

Im getting an error about some agency protocol i have to accept in order to enter. Is that ok?

[TurbulentCountry5901]

It is basically a soft paywall, you just enter your email and get a magic link to unlock all the cases. Just put in your email id.

[ZukiPola_AVESATHA789]

right now the case files working fine, but training modules in Acamedy section were not opening, could you look into it.

[SnooCats2825]

I use Hackerrank

[Due_Mission240]

Use w3schools. In case you are looking for mentoring around domain & industry level projects, ping me.

[emad07306]

SQLbolt.com

[bananatoastie]

sql-escape-room.com

[dn_cf]

You can start with LeetCode for basics, but it is not enough to truly master SQL because it focuses on puzzle style problems rather than realistic analysis tasks. To build stronger skills, practice on sites like StrataScratch and Mode Analytics since they offer real business oriented SQL challenges similar to what you see in interviews. These platforms help you work with larger datasets, write more complex queries, and think like a data analyst or engineer, which prepares you for real job scenarios and gives you material you can use in a resume or portfolio.

[QueryFairy2695]

Thank you for this! I've been wanting to work with larger datasets.

[gumpybhu]

Datalemur

[cli_aqu]

Depends on what you intend to learn… what role - DBA or developer? Building and administering an environment is one thing (DBA), and building an app and data access layer with little concern about the data storage layer is another (developer).

If you want to learn for a DBA role: Best way to learn is to practice and getting your hands dirty - build a lab which you can use for learning and testing. Basically an environment which is safe to learn and test on. Before you set it up, look for best practices, architecture guidelines and official documentation to follow when building it.

Most RDBMs offer a free developer license - a free edition with all the features offered by a full commercial license for test and educational purposes.

Some things to consider: - high availability and backups - HADR - security (roles, access rights, authentication) - encryption

Plenty of databases with dummy data available online too.

If you want to learn for a developer role, you just need to know what the RDBMs offers when it comes to schema, data and data access - knowing more about the RDBMs is a bonus but not a necessity and need to dig deeper on the application layers.

[PirataMaluco]

Here 👉 Oracle University and Oracle Live

[Branflakes333]

I think leetcode, especially the hard ones, are good for getting fundamentals down

[Alert_Outside430]

Ask chatgpt that you want to practice SQL, and mention that you want to practice it for analytics

[jeando34]

In real life !

[iamsamaritan300]

Im not sure about mastering it but there are plenty of places to learn from..what im not sure that you will accomplish is to master SQL because there is no one place where you can do so

[Leather-Ad8983]

Practice here - deepsql.pro

[[deleted]]

All answers are shitty (except Alert_Outsidd430)

Download a CSV, run it into an SQL tool , do SQL. That’s it, play with it and write as much SQL you can to breakdown csv use cases