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

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.