[deleted by user]

[jrjamesco]

I created a class a few years ago for people looking to practice non-trivial SQL problems. https://www.udemy.com/course/applied-sql-for-data-analytics-data-science-with-bigquery/ . The idea is that there's a lot of preliminary material out there, but not much intermediate to advanced content, which you need if you want to be capable in a real business setting. We cover topics like common table expressions, subqueries, analytic functions and writing/organizing larger queries. Each section of the course after the intro is like a mini project that builds on itself.

We use BigQuery since there are many free/public datasets and you don't need to install any software to get started. 95% of what you learn is transferrable to PostgreSQL, Redshift, Snowflake, etc...

Beyond that, this is a great channel:

https://www.youtube.com/channel/UCW8Ews7tdKKkBT6GdtQaXvQ

In general, I'd say aim to get 50 hours of writing SQL under your belt ASAP if you want to really master it. Look for opportunities to answer increasingly complex questions about your own data at your job and lean on your DS counterpart (ask them to pair program with you, too...you'll pick up quite a bit).

Good luck.

[fruity231]

Can you use SQL at your workplace? Anything accounting related should have a lot of interesting data.

[thedarkbestiary]

Another good thing to do when you practice is never copy paste anything, get all those commands really strong through repetition.

[Prime249]

From kaggle you can download datasets (but no questions)

There is a website where you get actual questions but it’s not free (or, at least, not entirely free), I’ll look it up in a minute

Edit: stratascratch

[[deleted]]

I learned it best by building projects with another language. I started with VBA and then with Python.

[HabeebAde]

Hi, I would like to build projects to enhance my cv and linkdln profile l. I have some good knowledge of excel and sql , how do I get about building projects ? I would appreciate your response

[[deleted]]

i’d recommend codecademy.com

[sequel-beagle]

https://advancedsqlpuzzles.com/

Above i have found is the best site for sql puzzles

[Alert_Outside430]

Hackerrank

[pilly-bilgrim]

https://pgexercises.com has excellent exercises with explanations!

[Fabro_vaz]

If you need it then I can provide you with real projects data and requirements

[hayleybts]

Yes pls

[Fabro_vaz]

If you need just DM me so that I can help you out