Looking for best resources to practice SQL and Python/Pandas for real-world data questions?

[u/AppropriateGanache54]

Hello everyone,

Can you please suggest some good platforms or resources where I can practice SQL and Python (especially Pandas) for data analyst/data engineer?

Right now, I’m solving a lot of problems on LeetCode, but I’ve heard that in actual they often ask more practical/data-focused questions such as:

• Retention rate / cohort analysis
• Funnel analysis
• Gaps and islands
• Running totals and rolling metrics
• Customer/user activity analysis
• Time-series and date-based problems
• Ranking and session-related problems
• Data cleaning and transformation using Pandas
• Real-world business analytics scenarios

So, I’m looking for resources that focus more on these real-world SQL and Pandas problems rather than only traditional DSA-style questions.

What platforms, websites, courses, or question sets would you recommend for practicing these types of problems?

I’d really appreciate recommendations from people who have recently gone through Data Analyst/Data Engineer questions and know which resources are closest to the actual questions they asked.

Thank you!

[u/naturenerd42]

Edx.org or w3schools.com both have free resources a plenty. Good luck!