r/learnSQL 22h ago

When does a SQL query become “too clever”?

Thumbnail
1 Upvotes

r/learnSQL 4h ago

Looking for a good platform to practice Python, SQL and PySpark

6 Upvotes

Hi everyone,

I’m currently learning/practicing Python, SQL, and PySpark, mainly with a data engineering goal.

I’m looking for a platform where I can regularly solve problems and improve my hands-on skills, especially:

  1. Python — syntax, problem solving, data manipulation

  2. SQL — queries, joins, CTEs, window functions, etc.

  3. PySpark — DataFrames, transformations, aggregations, joins, optimization, etc.

I know platforms like LeetCode, HackerRank, DataCamp, etc., but I’m looking for something that provides good practical exercises, preferably with datasets/projects rather than only algorithmic problems.

What platforms/websites do you recommend for this?

Also, if you’re a data engineer, I’d appreciate knowing how you personally practice these three skills.

Thanks!


r/learnSQL 5h ago

I built a game to help beginners learn SQL. Looking for honest feedback.

2 Upvotes

Hi Everyone,

I'm Business Analyst and I've spent a lot of time working with SQL. One thing I noticed is that many beginners struggle to stay engaged with traditional tutorials and courses.

So I spent the last few months building SQL Quest, a game where players learn SQL by completing challenges, solving database puzzles, and progressing through levels.

I launched it yesterday and I'm currently looking for honest feedback from SQL learners and professionals.

I'd love to know:

* Is the gameplay engaging?

* Are the SQL challenges useful?

* What would make you keep playing?

App Link - https://play.google.com/store/apps/details?id=com.sqlquest.game


r/learnSQL 17h ago

Create row for each value in the CSV list in MS SQL Server

7 Upvotes
  DROP TABLE IF EXISTS  #x
  SELECT 111 id, '1,3,5' PU_list INTO #x

  SELECT * FROM #x

   id   PU_list        --< current 1 row
  111   1,3,5


   id  PU              --< wanted output, create row for each value in List CSV
  111   1 
  111   3
  111   5

Hi all,
Is it possible to create SQL Server code to produce output like posted above, I need to create separate row for each value in PU_List separated by comma.

Thanks all
VA


r/learnSQL 20h ago

how to standardize this date column in mysql?

9 Upvotes
ship_date delivery_date
Feb 10 2024 Feb 15 2024
2024-01-12 2024-01-11
2024-01-10 2024-01-14
01/15/2024 01/19/2024