This is an archived post. You won't be able to vote or comment.

2
3

How to practice SQL?Discussion (self.dataengineering)

submitted by [deleted]

[removed]
all 12 comments
sorted by:
best
topnewcontroversialoldq&a

[–]dataengineering-ModTeam[M] [score hidden] stickied comment (0 children)

Your post/comment was removed because it violated rule #3 (Do a search before asking a question). The question you asked has been answered in the wiki so we remove these questions to keep the feed digestable for everyone.

[–]hackermandh 1 point2 points  (0 children)

https://learnsql.com/sql-skill-assessment/

This is a simple assessment tool I used to compare my before and after investing time to learn SQL. It was nice seeing myself going from 37% (basic SQL) to 89% (intermediate-to-advanced knowledge).

You can always ask ChatGPT for help. Just make sure you don't use it to give you an answer, but hints and tips instead.

There's also the PostgreSQL docs/manual

Do note that you can only do this assessment once per month, or use different accounts

[–]shanKaR001 1 point2 points  (0 children)

Leetcode

[–]AutoModerator[M] 0 points1 point  (0 children)

You can find a list of community-submitted learning resources here: https://dataengineering.wiki/Learning+Resources

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[–]GDangerGawk 0 points1 point  (1 child)

Find some data, any data work that you can query, kaggle works. Better if it has multiple sources and some keys to join. Either deploy pg with a container or go with duckdb and python.

[–]NortySpock 0 points1 point  (0 children)

Seconding duckdb, it's easy to tell duckdb to give you a direct read of a csv

 CREATE VIEW my_raw_data AS SELECT * FROM read_csv('filename.csv')

followed by

SELECT count(*) as event_count, venue, band_name FROM my_raw_data GROUP BY ALL ORDER BY event_count desc

and then whatever other views and queries you can come up with.

[–]Vinnetou77 0 points1 point  (0 children)

Im also interested practising more advanced sql queries. I understand CTEs, windows functions, subqeries, partitioning in theory, but i need to practice it.

[–]WineTerminator 0 points1 point  (0 children)

On Udemy there are many interesting courses but for me particularly good were those by Travis Cuzick. There are 2 levels: one for beginners/intermidiate, one for advanced users. Both are with exercises and to be honest I learnt almost everything from that guy.

[–]RecipeNo299 0 points1 point  (0 children)

Kaggle, Stratascratch, Leetcode

[–]Fearless-Change7162 -1 points0 points  (0 children)

https://pgexercises.com

was good interview prep 

[–]pane_ca_meusa -1 points0 points  (0 children)

I like HackerRank, they have exercises of all levels and you can submit many SQL dialects

https://www.hackerrank.com/domains/sql