Tech - jroshan

Very Important Questions

s = { 0 , 'Tech Jroshan', True, 12500, 'Python' }

print( 1 in s)


1.🔹True
2.🔹 False
3.🔹 0
4.🔹Invalid / Error


🔥 Join Groups for the latest Update and Notes:-
whatsapp.com/channel/0029Va53iL3D8SE74GZFsz3i

🎯 Test Your SQL Skills – Free Quiz!
forms.gle/Afux5noATe5qRgB9A

🌈Join my YouTube channel for in-depth discussions
youtube.com/@tech_jroshan

🔗let's build a strong professional community together. Connect now!
www.linkedin.com/in/roshan-jha-tech

Please ping your questions or query 🔥

#Python #DataAnalysis #Software #MachineLearning #InterviewQuestions #

1 day ago | [YT] | 2

Tech - jroshan

WHAT IS OUTPUT OF THIS PYTHON CODE 🎯

res = 'Tech' + "Jroshan"
print(ees)

1🔹Tech Jroshan
2🔹Tech
3🔹Jroshan
4🔹Error
#python #coders #viral #machineCode #ProblemSolving #Developer

2 days ago | [YT] | 1

Tech - jroshan

https://youtu.be/aBkUzZjkFi0?feature=...

3 days ago | [YT] | 2

Tech - jroshan

🚀 𝗦𝗤𝗟 - 𝗠𝘆𝗦𝗤𝗟 𝗪𝗵𝘆 𝗜𝗻𝗱𝗲𝘅𝗶𝗻𝗴 𝗰𝗼𝗺𝗲 𝘁𝗼 𝘁𝗵𝗲 𝗽𝗶𝗰𝘁𝘂𝗿𝗲 : 𝗥𝗲𝗮𝗹 𝗘𝘅𝗮𝗺𝗽𝗹𝗲𝘀 𝗘𝘃𝗲𝗿𝘆 𝗗𝗮𝘁𝗮 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝗠𝘂𝘀𝘁 𝗞𝗻𝗼𝘄

Indexes are not theory — they directly improve query performance.
Here’s WHEN and WHERE indexing helps with simple SQL examples 👇

---

🔍 WHERE Condition

Speeds up row filtering

SELECT *
FROM employees
WHERE city = 'Delhi';

✅ Best Index:

CREATE INDEX idx_city ON employees(city);

---

🔗 JOIN Condition

Faster table joins on key columns

SELECT o.order_id, c.name
FROM orders o
JOIN customers c
ON o.customer_id = c.id;

✅ Best Index:

CREATE INDEX idx_customer_id ON orders(customer_id);

---

📊 ORDER BY Sorting

Avoids extra sorting operations

SELECT *
FROM employees
ORDER BY salary;

✅ Best Index:

CREATE INDEX idx_salary ON employees(salary);

---

📈 GROUP BY Grouping

Speeds up aggregation queries

SELECT city, COUNT(*)
FROM employees
GROUP BY city;

✅ Best Index:

CREATE INDEX idx_city ON employees(city);

---

🗃️ Searching Large Tables

Avoids full table scan on millions of rows

SELECT *
FROM orders
WHERE order_date = '2025-01-01';

✅ Best Index:

CREATE INDEX idx_order_date ON orders(order_date);

---

🔥 BONUS: Composite Index

Best for real-world queries

SELECT *
FROM employees
WHERE city = 'Delhi'
AND salary > 50000
ORDER BY salary;

✅ Best Index:

CREATE INDEX idx_city_salary ON employees(city, salary);

---

📌 Key Takeaway:
- Index columns used in WHERE, JOIN, ORDER BY, and GROUP BY

- Faster reads = Better performance
- Poor indexing = Slow applications


#DataScience #DataAnalysis #Software #MachineLearning #MysqlIndexing #SQLNotes #Testing

Skip the Carousel

1 2 3 4 5 6 7 8 9 10

5 days ago | [YT] | 6

Tech - jroshan

Which measure is best for outliers?

A) 🔹 Mean
B) 🔹Median
C) 🔹Mode
D) 🔹Standard deviation

🔥 Join Groups for the latest Update and Notes:-
whatsapp.com/channel/0029Va53iL3D8SE74GZFsz3i

🎯 Test Your SQL Skills – Free Quiz!
forms.gle/Afux5noATe5qRgB9A

🌈Join my YouTube channel for in-depth discussions
youtube.com/@tech_jroshan

🔗let's build a strong professional community together. Connect now!
www.linkedin.com/in/roshan-jha-tech

Please ping your questions or query 🔥


#python #dataanalysis #problemsolving #machineLearning #InterviewQuestions

1 week ago | [YT] | 5

Tech - jroshan

Power BI Hard or Easy ❓

1.🔹Building Dashboard

2.🔹DAX formula

3.🔹Model Creations

4.🔹Data Cleaning


#dataanalysis #pandas #powerbi #buildingdashboard #education #mentor #problemsolving

1 week ago | [YT] | 3

Tech - jroshan

What does df.groupby('Department').mean() do?

A.▫️ Groups by Department and shows mean values

B.▫️ Sorts DataFrame by Department

C.▫️ Deletes Department column

D.▫️ Shows max salary per Department


🔥 Join Groups for the latest Update and Notes:-
whatsapp.com/channel/0029Va53iL3D8SE74GZFsz3i

🎯 Test Your SQL Skills – Free Quiz!
forms.gle/Afux5noATe5qRgB9A

🌈Join my YouTube channel for in-depth discussions
youtube.com/@tech_jroshan

🔗let's build a strong professional community together. Connect now!
www.linkedin.com/in/roshan-jha-tech

Please ping your questions or query 🔥

#post #viral #interview #QuestionsAnswering #MachineLearning #dataanalysis #datascience

2 weeks ago | [YT] | 3

Tech - jroshan

Which method returns summary statistics for numeric columns?

A.▫️ df.info()
B.▫️ df.describe()
C.▫️ df.summary()
D.▫️ df.stats()



🔥 Join Groups for latest Update and Notes:-
whatsapp.com/channel/0029Va53iL3D8SE74GZFsz3i

🎯 Test Your SQL Skills – Free Quiz!
forms.gle/Afux5noATe5qRgB9A

🌈Join my YouTube channel for in-depth discussions
youtube.com/@tech_jroshan

🔗let's build a strong professional community together. Connect now!
www.linkedin.com/in/roshan-jha-tech

Please ping your questions or query 🔥


#datacleaning #dataanalysis #datascience #software #machinelearning #interview #problemsolving

3 weeks ago | [YT] | 6

Tech - jroshan

Which method checks for missing values?

A.🔹 df.isnull()
B.🔹 df.fillna()
C.🔹 df.dropna()
D.🔹df.notnull()


🔥 Join Groups for latest Update and Notes:-
whatsapp.com/channel/0029Va53iL3D8SE74GZFsz3i

🎯 Test Your SQL Skills – Free Quiz!
forms.gle/Afux5noATe5qRgB9A

🌈Join my YouTube channel for in-depth discussions
youtube.com/@tech_jroshan

🔗let's build a strong professional community together. Connect now!
www.linkedin.com/in/roshan-jha-tech

Top 10 Machine Learning questions:- 🌈
lnkd.in/gcewTQdC

Please ping your questions or query 🔥

#python #pandas #dataanalysis #datascience #interview

1 month ago | [YT] | 3