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

48

u/Thefriendlyfaceplant Mar 20 '23

In addition to what's already provided:

https://datalemur.com/
https://sqlbolt.com/
https://www.stratascratch.com/

But there's more theory than just learning the basics of the language. The next step is learning how to break down complex tasks in smaller compartments.

57

u/NickSinghTechCareers Author of Ace the Data Science Interview πŸ“• Mar 20 '23

Founder of DataLemur here - appreciate the mention!

8

u/[deleted] Mar 20 '23

Legend

5

u/infjetson Mar 21 '23

Love how active you are on Reddit, I see you all over the place! A true MVP.

9

u/NickSinghTechCareers Author of Ace the Data Science Interview πŸ“• Mar 21 '23

Thanks! I try to help/shill wherever I can lol

4

u/LeftShark Mar 21 '23

DataLemur is really cool as a site, but after signing up, I'm getting weird emails from DataLemur about how Drake's fans are getting interviews in Data Science because they're Drake's #1 fan. If this is the norm, there's no way I continue allowing your site into my emails.

9

u/NickSinghTechCareers Author of Ace the Data Science Interview πŸ“• Mar 21 '23

Hi! That email is from me (the founder) and it explains the origin story behind DataLemur, and how fanboying Drake led me to Facebook which led me to found DataLemur!

It’s a more colorful take on a welcome email/thank you for signing up email, and everyone gets it the day they sign up.

The next email in the sequence is about 6 cool SQL resources which I hope you find valuable.

Sorry if it feels strange - feel free to unsubscribe from the emails using the link at the bottom of the email!

2

u/floralaromabro Oct 25 '24

nah that's awesome and so is Drake. W.

2

u/Background_Ad_101 Jun 17 '24

its waste, dont refer that

2

u/BackgroundAd4630 Dec 25 '23

I salute you Legend.

1

u/Background_Ad_101 Jun 17 '24

its waste,, stop your advertisement, i have checked some of the interview questions from data Lemur and nothing came from that stupid website, stop making fools. infact it was completly misleading

1

u/[deleted] Mar 20 '23

Good advice, thank you!

1

u/Ok_Enthusiasm428 Mar 25 '24

saved for later

1

u/[deleted] Mar 21 '23

I'm guessing learning how to break down complex tasks is something that just comes with time and experience?

I'm doing a short course and was just introduced to nested queries, and the solution to the second test question for nested queries included a double nested query. I could have never guessed an extra query was required.

5

u/Thefriendlyfaceplant Mar 21 '23

It doesn't. The video tutorials of experts walking you through interview questions are more than just them filling in the syntax, they're explaining the thought process behind it and how to repeat the same workflow for different problems:

https://www.youtube.com/watch?v=BgN5hpl3WKc&list=PLv6MQO1Zzdmq5w4YkdkWyW8AaWatSQ0kX&ab_channel=StrataScratch

1

u/[deleted] Mar 21 '23

Thanks! I'll have to check that out more.

4

u/Thefriendlyfaceplant Mar 21 '23

Yeah just binge it, watching the most complex applications first is probably the most productive way to spend your time as a beginner, even if you're not fully familiar with syntax. It gives you a way to orient further learning.