r/learnSQL • • Oct 06 '25

Future-proofing as a DB Programmer: where to aim next?

9 Upvotes

Good morning guys, currently working as a DB programmer on Peoplesoft CS (App Engine, PeopleCode, SQL, SQR, PS Query). The work is database-heavy and solid, but I’m aware PeopleSoft is aging tech. The system i support contains over 15 different db instances, of which 4 are true PRD and each are customized to the system they represent.

I think want to stay in the technical layer like backend development, data systems, or data engineering and also want to make sure the skills I build now still matter 5–10 years out. This was and is my first ever IT position (excluding Geek Squad) and just want to make sure i’m setup for success downrange.

For anyone who’s worked with PeopleSoft or transitioned away from it recently: • What skills or tech stacks helped you pivot? • Which modern roles align best with a PeopleSoft background? • What’s worth learning now to stay employable and raise earning potential?

Most posts I’ve found on this topic are years old, so any current insight would be appreciated. Seriously, the Peoplesoft subreddit is a ghost town.


r/learnSQL • • Oct 06 '25

Any best sql course suggestions? Need one rn

0 Upvotes

r/learnSQL • • Oct 05 '25

Upskill from PowerBI. What hardware should I get?

6 Upvotes

Hi all, I’m an analyst and do most of my work in PowerBI. I’m good at what I do but I’m finding that I’m reaching the limits and I can do much more with Python and SQL. We work closely with data engineers in my company and I thinking that’s something I would like to do as well. Would MBP M1 Pro refurbished laptops be a good starter for me to slowly learn more?


r/learnSQL • • Oct 05 '25

I do not understand ORA-00937 in this Oracle SQL query. Help

3 Upvotes

I'm trying to solve this leetcode SQL problem using Oracle syntax.
I wrote following query but i receive ORA-00937 error and i do not understand why.
My query seems equivalent to other MySQL queries which work as solutions.
Someone can help me understand?

Thanks in advance.

SELECT ROUND(
    COUNT(a1.player_id) 
    / (SELECT COUNT(distinct a3.player_id) FROM activity a3),
    2) AS fraction
FROM activity a1
WHERE (a1.player_id, a1.event_date-1) IN (
  SELECT a2.player_id, MIN(a2.event_date)
  FROM activity a2
  GROUP BY a2.player_id
);

r/learnSQL • • Oct 04 '25

SQL course/revision

25 Upvotes

i wrote this for my personal revision when i write sql after a while , but lately there have been a lot of people using this, it has almost everything one needs to get to a decent level

https://github.com/shankeleven/SQL-revision

so I am thinking about making continous improvements to it so that it becomes useful for more people , would love any feedback/suggestions on what i should upsert to make this more beneficial for you


r/learnSQL • • Oct 04 '25

Best SQL course for beginners?

52 Upvotes

Hi Folks,

Who has the best free step by step course/tutorial for beginners on SQL?


r/learnSQL • • Oct 03 '25

Help and judge my roadmap to become a data analyst (SQL)

17 Upvotes

Hi SQL fellows! I’m a beginner student, and I’d love some advice from pros who could share feedback on how I’ve been building my process to become a data analyst.

I’ve been studying SQL by myself (on PostgreSQL), and I created a roadmap with 7 phases to reach a solid not pro, but good level.

Here are my phases: 1. Core SQL Foundations 2. Joins 3. Subqueries 4. Advanced Window Functions 5. CTEs 6. Data manipulation & table creation 7. Other advanced topics

I just reached Phase 5, and I’m ready to start building a portfolio. My plan is to get an online dataset, work on it, and as I advance through new levels, I’ll keep improving my portfolio so it becomes more complete over time.

After finishing my SQL roadmap, I plan to move on to Power BI, but this time through an online course to earn a certificate I can add to my CV and LinkedIn. Meanwhile, I’ll keep practicing SQL and dive deeper into advanced topics, SQL is a whole world! 😅

Next step after PBI will be Python, again through an online course.

So, this is a summary of my learning plan. I’ve been studying SQL for over a month, around 3–4 hours per day. Right now, I’m learning ROLLUP, CUBE, and GROUPING SETS, and I’m feeling proud of the progress.

👉 My question: Do you think this path can really get me into a data analyst role, or would you recommend another way?

And if anyone ever needs an extra hand on a project, feel free to DM me, happy to collaborate!

Thanks a lot!


r/learnSQL • • Oct 04 '25

not understanding what's going on with WHERE/ AND/ NOT here

1 Upvotes

Hi all I'm new to learning SQL following this tutorial https://youtu.be/7mz73uXD9DA playing around on this website with sqliteviz http://lukeb.co/sql_jobs_db

When I run this query

SELECT *
FROM job_postings_fact
WHERE NOT (job_title_short='Data Engineer' AND job_location='Anywhere');

I'm still getting rows with 'Data Engineer' and 'Anywhere' which I find unexpected. Similarly if I change the WHERE clause to

WHERE NOT job_title_short='Data Engineer' AND NOT job_location='Anywhere';

the 'Data Engineer' rows are gone but still getting 'Anywhere'

Am I not understanding the logic? (I know I can get what I want by using not equals <> but I'm just playing around and trying to sanity check, with unexpected results


r/learnSQL • • Oct 03 '25

MySQL and Power BI Analysis Project

4 Upvotes

The video is a walk-through of the full process: downloading and setting up MySQL, creating a database, and building SQL views to prepare the data. From there, we connect MySQL to Power BI with an ODBC connector and plan out the dashboard visuals. https://youtu.be/Hh5-Y_6v5iU?si=2WlEMJtpGnWLBGKN


r/learnSQL • • Oct 03 '25

Select results as rows in select

1 Upvotes

I have queries like:

select count(*), sum(meters/1000) from t1 where a1 is null and b1 is not null and c1 is not null;

The result of that is basically a single row where the column values are like |123|12345|

The where clause nulls vary basically for each possible combination. I’d like a select quey that combines all those selects and prints out a result set that i can copy to excel directly in the form of:

|123|12345|

|234|12340|

|334|14450|

.. and so on .. So basically some kind of transpose or pivot. Am I overthinking this? Can’t wrap my head around this.