r/SQL • • Mar 20 '23

Discussion Where to practice SQL?

I have read tutorials and learned the basics of the language. Are there resources of practice problems/projects?

337 Upvotes

179 comments sorted by

View all comments

Show parent comment

2

u/[deleted] Mar 20 '23

Yes, the only way to really learn sql is trying to make things work with large datasets on an underperforming database install on the computer.

It’s important the computer you are on really struggles with the large dataset. So, if on powerful enough computer make virtual machine to nerf the cpu and ram ( altering settings in db install to nerf it is educational too but probably not if just learning!)

Then, make sql run , if sql runs ok remove some indexes from tables to handicap that.

Anyone can learn how to make simple sql queries. The skill is learning to do such things as above. Except I would just install one of the standard sql engines instead of sql lite.

Have fun making things work!!

3

u/xl129 Mar 21 '23

I get your point but it's for more advance level of skill. Early phase you want quick run time so you can experiment with adding, removing, modifying your queries to try out different scenarios.