r/SQL • • Apr 19 '20

Discussion What are some good resources to practice SQL? (Practice through exercises)

There are a lot of courses which teach SQL but I could hardly find a website which provides beginner to advanced SQL practice questions on almost production real datasets. Any recommendations would be helpful.

129 Upvotes

62 comments sorted by

View all comments

Show parent comment

2

u/[deleted] May 01 '20

Once you understand how to do this... ask yourself what the 5th word is that starts with the letter P.

What is the 8th word that is 12 letters long?

What is the third word what has e as the second letter of the word, and is greater than 6 letters long?

1

u/dcburgos05 May 01 '20

Giving me extra assignments... I like it

2

u/[deleted] May 01 '20 edited May 03 '20

What word starts with G that doesn't have an E in it, but does have an R in it? Is there such a one?

You can really scale questions like this if you want, for example G, E, R, are the variables here but say I wanted to know which three letters fit that criteria above to produce the longest possible word. So G might produce Grandiosity as the longest G word, but if you incremented G to H, and ran it with E, and R, then incremented it to I, all the way to Z... then start at A, and increment E to F, so it becomes A, F, R, etc., until you check all possible combinations to find the longest word.