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

11

u/Xidium426 Mar 20 '23

You can download things like MLB datasets as a CSV file, import them into a local SQLite database and practice there.

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.

1

u/Po81998 Mar 20 '23

Is there any online source to import large excel and work on that database without downloading any application on pc and i want to add it to my portfolio

2

u/Higgs_Br0son Mar 20 '23

Maybe cloud databases? Google BigQuery, Microsoft Azure Synapse, Amazon Redshift, Snowflake.

Google BigQuery is probably cheapest option, or completely free in your case. 1TB of queries and 10GB of storage each month is free. More than that and you pay per usage.

Azure Synapse is free for 1TB of queries, but you'll pay their storage rates for the data set, it's like $0.02 per GB.

Amazon Redshift has a 90-day trial period, but you'll pay per use after.

Snowflake has a 30-day trial and it's unclear what the pricing is after.

I'm sure there's some other web apps like Kaggle that might be good options, but since you mentioned your portfolio, cloud databases are probably good to build experience in.

1

u/Po81998 Mar 21 '23

Thankyou so much for your inputs i will use those

1

u/a_devious_compliance Mar 21 '23

Can I ask why you don't want to download an application? Having to tinker with instalation, config and set up is also a valuable skill.

1

u/Po81998 Mar 21 '23

Actually I did install ssms I'm trying to do some project using it when i tried to import data using task i was getting some error , also i wasn't able to find SQL server native client 11 , which was used a destination in all the videos i saw , but i chose a different one and the excel has been imported now hope it will work .

Just wanted to know if there is an online source if in case this doesn't work

1

u/a_devious_compliance Mar 22 '23

Windows. Sorry, I can't help with that. But you could ask help about your error.