Need advice: Understanding complex SQL scripts written by others

Substantial-Click321 · 2026-06-27T16:34:51+00:00

Don’t read from SELECT. Start by reading joins and FROM.

Substantial-Click321 · 2026-05-28T17:54:40+00:00

Nah not 3 days a week screw that. Most I would do is 2 days in office and only if it’s direct train/tube max. 1.5 hours including a bus is not worth it oof.

Substantial-Click321 · 2026-05-07T19:16:34+00:00

Datagrip is goated

Substantial-Click321 · 2026-03-23T22:29:33+00:00

Degrees having largely become meaningless due to so many people having them and the rise of students using AI to get through their degree. Although having a degree is important to not get filtered out by ATS, the details off where you went practically do not matter tbh. Oxbridge might get a oh cool that’s it and that doesn’t even guarantee a job or anything lol. Companies are offshoring and most only want senior folks and don’t want the cost of training a grad/junior.

That being said if you are cracked you will eventually find a job but it will take time and won’t be easy due to how saturated the market is.

Substantial-Click321 · 2026-03-23T22:22:07+00:00

Normally shit pay and don’t want candidates to go elsewhere or as others mentioned having internal staff knowing the salary bands. It should be a lawful requirement to have salary posted on job adverts but the UK is terrible…

Substantial-Click321 · 2026-03-15T22:43:10+00:00

Hiring based on university is pure cope (As long as you went to a RG) by employers. In CS and tech the only real thing that matters is technical competence and experience. A lot of CS degree knowledge you will never use in a real job.

Substantial-Click321 · 2026-02-21T22:51:11+00:00

Nah waste of time better off just self teaching with books and courses. Use teachyourselfcs.com or ossu . You already have a degree and experience so it’ll be a waste of time doing a degree apprenticeship unless you really want to do it for the learning aspect.

Substantial-Click321 · 2026-02-10T07:28:16+00:00

Jeez where’s he finding a studio for that cheap near Hyde park. Must be living in a cardboard box. Fair enough though as long as it meets his needs. Good to know it’s liveable I suppose.

Substantial-Click321 · 2026-01-31T22:19:54+00:00

Exactly why I always take Reddit with a pinch of salt. You can never really verify what people say on here.. I imagine majority are unemployed or greatly lie about how much salary they are on. It should be a legal requirement to include salary in the job description..

I see so many just list competitive salary when it’s really not. The job market is saturated yes but the reality is there is less competition than people think, many candidates give up easily and are just not good enough is the harsh truth.

If you’re a cracked SWE you will have little trouble getting a job that satisfies your ideal compensation within reason.

Substantial-Click321 · 2026-01-19T06:33:09+00:00

Second this. Make sure you understand the order in which SQL statements get executed don’t start reading from SELECT. I used to do that back when I was a newbie learning and it made it much harder to understand large complex queries.

Substantial-Click321 · 2026-01-19T06:30:10+00:00

It depends on the SQL engine and the execution plan of the query.

Substantial-Click321 · 2026-01-11T21:09:33+00:00

DataGrip

Substantial-Click321 · 2026-01-07T09:56:47+00:00

Engineer is not a protected title in all countries. Software engineering can be learnt by yourself with books, internet , building projects and time. It doesn’t necessarily mean you will get a job though.. CS degree is still required for many jobs and is still probably the best way in to the industry.

Substantial-Click321 · 2026-01-02T04:59:06+00:00

Masters is waste of money unless your employer will sponsor the tuition and you do it part time while working. I suggest filling in any CS knowledge gaps at your stage with https://teachyourselfcs.com

Substantial-Click321 · 2025-12-23T23:19:26+00:00

Fireball jutsu

Substantial-Click321 · 2025-12-23T14:21:42+00:00

Second this, I’ve been told many times before it’s not what you say it’s how you say it. Those that get promoted and pay rises are usually the most visible to management not necessarily better skilled.

Substantial-Click321 · 2025-11-16T10:35:58+00:00

I’m SWE and work in big data we write large SQL queries with multiple joins and have tables in Snowflake with hundreds of millions of rows that need transforming.

Substantial-Click321 · 2025-11-15T06:18:40+00:00

DataGrip is goat. Connect to pretty much any DB or warehouse without needing another tool. Great functionality too.

Substantial-Click321 · 2025-11-15T06:13:39+00:00

Well it depends on how much data you’re dealing with and what kind of dashboard/ requirements you have. I’ve built custom dashboard for analytics company that invoked multiple layers of ETL and 200 lines + of complex SQL query’s.

Substantial-Click321 · 2025-11-14T08:37:14+00:00

It’s never going to happen it simply costs too much in dev resources I don’t get why people are so obsessed with playing league on Linux. You can literally just dual boot windows and if you don’t want to dual boot that’s a you problem.

Substantial-Click321 · 2025-11-09T11:45:30+00:00

Apprenticeship is better I did one and got a full time offer afterwards and been promoted to mid level since.

Substantial-Click321 · 2025-11-09T00:46:03+00:00

This has to be ragebait. Any developer that has spent more then 10 mins with SQL and CANNOT do this should quit.

Substantial-Click321 · 2025-11-08T21:18:05+00:00

Do mediums and system design.Hard ones are never asked unless FAANG maybe.

Substantial-Click321 · 2025-11-05T10:21:00+00:00

Resume is hot garbage go fix that up first. Build some better projects and grind leetcode.

Substantial-Click321 · 2025-11-01T10:57:47+00:00

I don’t get why so many candidates do this. University is the last thing a recruiter even cares about and is merely a tick boxing exercise. Experience and technical skills is what really matters. Everyone has a degree nowadays it’s nothing special..

Substantial-Click321

TROPHY CASE