r/learnSQL • u/No_Ambition8323 • 22h ago
r/learnSQL • u/Whole-Bank1538 • 4h ago
Looking for a good platform to practice Python, SQL and PySpark
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:
Python — syntax, problem solving, data manipulation
SQL — queries, joins, CTEs, window functions, etc.
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 • u/Melodic-Somewhere139 • 5h ago
I built a game to help beginners learn SQL. Looking for honest feedback.
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 • u/Valuable-Ant3465 • 17h ago
Create row for each value in the CSV list in MS SQL Server
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 • u/haligma • 20h ago
how to standardize this date column in mysql?
| 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 |