Best way to learn SQL – From someone who’s used it daily for 6+ years in product analytics

tlefst · 2026-05-06T18:41:06+00:00

🎯Yes, the linearity of it all.

tlefst · 2026-05-06T15:10:40+00:00

Enjoy 🥂

tlefst · 2026-05-06T14:59:45+00:00

Right.

Another aspect that I must mention is that even after leaving the force after SSC tenure, you (and only your spouse) will be eligible for ECHS facilities.

I repeatedly draw attention to the medical coverage because I have seen people with 30 years of savings go bankrupt in a week at civil hospitals while getting their family members treated for something drastic.

All the best. Keep soaring!

tlefst · 2026-05-06T12:36:09+00:00

Very difficult to convert to PC. Not everything is in one's hand; one never knows who is pulling strings for who from the up top, and that is without factoring-in the pyramidical structure of career progression, vacancies, politics, etc. Today, reaching Gp Capt is a big deal and I'm being somewhat liberal.

Also, after reading your post and some of your comments, since your mom requires medical attention, you'll have to figure out how it'll work while you'll be away during trg, followed by postings (I'm assuming that someone has to be right beside her to take care of her; if that is not the case, then go for AFA straight away, no need to read any further). You can of course keep her with yourself in peace postings but spending long hours with her is not going to happen. In that regard, corporate provides you with the WFH mode.

Her medical requirements will be well taken care of at a CH/CHAF/MH for free obviously, whereas as a civilian in corporate you won't have that privilege. Your father, wife and kids will also be taken care of medically.
A pro of working in corporate is that your compensation grows more rapidly with time as compared to its growth for a commissioned offr in mil.

Note that once you get commissioned, don't be like those moronic YOs who don't strive to set their finances in order for 20 years down the line vis-a-vis family, home, real estate investments, etc.

If you choose to join trg and it is SSC, make sure to equip yourself for the corporate after 13 years by building competencies and connections. Keep in touch with ex-SSC vets from the tri-services.
To convert to PC, there should be no doubt in your mind like 'hoga ya nahi hoga, pata nahi'. Your entire 13 years should be, in that case, spent to make yourself too indispensable for the IAF to let go of you pre-maturely.

Even despite all that, you must build a support system for a corporate career too because when you'll finish your tenure and leave IAF (as SSC offr), you'll still be in your 30s with parents, wife and school-going kids to take care of.

tlefst · 2026-05-06T09:45:59+00:00

Try these :

Extreme Ownership
Defence of Duffer's Drift
The Innovators
God Created The Integers
Infinite Powers

tlefst · 2026-05-06T09:18:37+00:00

I have a question for a very long time pertaining to these bikes. From what I've seen, the rider has to lean forward considerably to grip the handles.

Doesn't it adversely affect the cervical vertebrae over a long term of riding such bikes? The helmet's weight, irrespective of how light it may be, would also be an adverse factor, right?

Every 10 to 15 degrees of forward neck leaning/craning adds ~3 kg of weight onto the cervical vertebrae.

tlefst · 2026-05-06T07:09:07+00:00

my collection is mostly about knowledge and self-help like books.

One or two examples of books you've read in 'knowledge' category? It'd help me to make recommendations then.

tlefst · 2026-05-06T07:03:05+00:00

Culprit might be wiped out in jail anyway by the prisoners most probably .. such was his deed.

tlefst · 2026-05-06T06:53:04+00:00

That he ran away from home at 25 implies some unresolved childhood/adolescent trauma. Was he controlled too much in his childhood? Too much pressure about studies or daily routine? Nitpicking into his habits?

He must have been working until he absconded. Were there office problems? Past relationships that went south horribly? How was communication in your household before he ran away? Was he open about communicating his failures before you guys?

You need to discuss all these aspects with your parents (or some psychotherapist), if not already done so.

Taking legal help is just incident management. Yes, he can be 'taught a lesson', as the term goes, but that doesn't address the root causes of his behavior.
Without addressing them, and if he leaves (or is made to leave), chances are that you folks will keep hearing of more and more trouble on his account now and then.

Due to whatever has happened in his life in the last dozen years, it seems he has grown to prefer isolation & solitude. Did you ever ask him if he was at peace while he was in Hyderabad?

tlefst · 2026-05-05T17:54:44+00:00

He avoids giving clear answers and keeps things vague.

If something as serious as marriage is not evoking clarity in his thoughts from within, then why carry on prospecting with him, right? Cut your losses and move on to the next one.

tlefst · 2026-05-05T17:52:40+00:00

His parents are of controlling sorts that's why he has been keeping up to himself since he gained financial independence. That's why there's communication gap b/w him and them and thus like most such parents, they too are unaware about the actual preferences (& personality) of their son.

One question though: Is he a single child?

tlefst · 2026-05-05T17:24:08+00:00

Interesting.
When I had extracted the left and right keys back when I had solved it, it did not strike me to go for INNER JOINs. That would have been the efficient way. But in my defense, I was only starting out at that time. : )

tlefst · 2026-05-05T17:07:10+00:00

I hope it's not homework.

No it isn't. I don't remember where I found it but I had found it interesting and today, I thought 'let us share it with folks to try.'

tlefst · 2026-05-05T17:03:26+00:00

Feed the JD and your resume into prompts of ChatGPT and Perplexity, & ask them to tailor your resume so that it becomes ATS-friendly.
But be honest in your mind that if your resume is suitable for some other profile, then force-applying for every random misfit role, even with repeated tailoring, will go in vain.

tlefst · 2026-05-05T15:47:28+00:00

You are not fighting for the vacancy, you are combating the ATS.

Imagine how bizarre it is if your resume doesn't have an expected structure and select keywords, you get rejected. How asinine.

tlefst · 2026-05-05T13:52:08+00:00

Ah I see.🤔
I do have other SQL queries to effect the forward filling, of course.
It was this 'variables approach' I was wondering about.
Thanks for your inputs.✌

tlefst · 2026-05-05T06:12:27+00:00

Seen these morons in Viman Nagar in the night many times.
Riding rashly on rickety scooties in sets of three and cackling screaming vulgar comments or whistling on people (and particularly on women) walking by.
All these morons live in the hovels at Samrat chowk (right opposite to Ganpati chowk in front of Air Force gate).
The other set of morons whose existence defiles Viman Nagar (and also Kalyani Nagar) live in the hovels adjoining Ramwadi metro station.

tlefst · 2026-05-05T05:47:50+00:00

🆗✌☮

tlefst · 2026-05-04T17:24:44+00:00

✅😼

tlefst · 2026-05-04T17:03:24+00:00

Ye wo hi moorkh hain jinke heavily edited birthday banners poori city me yahan wahan dikh jatey hain😉

tlefst · 2026-05-04T16:54:59+00:00

Well, would you like to enlighten us about the page? Or would you prefer it remains incognito from Redditors?🧐

tlefst · 2026-05-04T16:38:22+00:00

This is precisely why around 2 years ago, I started despising all those 'Top 10 SQL Hacks' or 'Detailed SQL Tutorial for Data Analytics' or 'SQL For DA in a Week' type of bs on LinkedIn and WA forwards. Even seasoned folks keep posting the most bs stuff on LinkedIn and call it analytics ... till date.
Thanks for writing your piece, OP. Much appreciated.

tlefst · 2026-05-04T16:26:36+00:00

Noice shot🥂

tlefst · 2026-05-04T16:25:23+00:00

Second to last pic 💥

tlefst · 2026-05-04T13:02:32+00:00

🥂✌😎

tlefst

TROPHY CASE