Sabitlenmiş Tweet
tara_
8.8K posts

tara_
@TechByTaraa
Posting tech stuff I find interesting. Brand / tech collabs → DM.
nowhere Katılım Kasım 2025
1.5K Takip Edilen4.2K Takipçiler

15 Advanced SQL commands every developer should know:
• INNER JOIN — Match rows between tables
• LEFT JOIN — All left + matched right
• RIGHT JOIN — All right + matched left
• FULL JOIN — All records both sides
• GROUP BY — Group rows for aggregation
• HAVING — Filter grouped data
• ORDER BY — Sort results
• LIMIT — Restrict number of rows
• OFFSET — Skip rows
• DISTINCT — Remove duplicates
• UNION — Combine result sets
• CASE — Conditional logic
• EXISTS — Check subquery presence
• IN — Match multiple values
• WITH (CTE) — Temporary result set
English

HIGHEST PAYING TECH SKILLS IN INDIA (2026)
• Platform Engineering - ₹35L+ LPA
• Cloud Architecture - ₹32L+ LPA
• DevSecOps - ₹30L+ LPA
• AI / ML Engineering - ₹28L+ LPA
• Site Reliability Engineering - ₹27L+ LPA
• Data Engineering - ₹25L+ LPA
• Cybersecurity - ₹24L+ LPA
• Generative AI Engineering - ₹35L+ LPA
• AI / Data Architecture - ₹30L+ LPA
• Blockchain Engineering - ₹25L+ LPA
Eesti

I know a senior from my hometown
He graduated from a tier 3 college, and since he was a COVID pass out, he didn’t get placed from college.
Then he joined a relative’s startup for just ₹5k. Anyone who thinks managers or HR are toxic should try working under a relative once.
After that, he left the startup and started preparing for MNCs. He eventually got a job at Capgemini with a package of around ₹6–7 lakh.
After 3 years of grinding, he switched again and as they say, hard work pays off. This time, he got a work from home job with a salary of ₹18 lakh.
So it’s possible that today might not be great, but tomorrow will definitely be better.
And by the way, this isn’t ragebait
English

@TechByTaraa If you want money, then prefer MNC
If you want an experience, then prefer startup
English

The only SQL concepts you really need to know:
• CRUD → SELECT, INSERT, UPDATE, DELETE
• Keys → PRIMARY KEY, FOREIGN KEY
• Constraints → NOT NULL, UNIQUE, CHECK, DEFAULT
• Joins → INNER JOIN, LEFT JOIN, RIGHT JOIN
• Aggregation → COUNT, SUM, AVG, MIN, MAX
• Grouping → GROUP BY, HAVING
• Filtering → WHERE, BETWEEN, IN, LIKE
• Sorting → ORDER BY
• Subqueries → SELECT (SELECT …)
• Indexes → CREATE INDEX
• Views → CREATE VIEW
• Transactions → BEGIN, COMMIT, ROLLBACK
• Pagination → LIMIT, OFFSET
• Optimization → EXPLAIN
English



























