📥 Free Resources & Cheat Sheets
Sab resources free hain — copy karo, practice karo, interviews crack karo!
🗄️
SQL Cheat Sheet
SELECT, JOIN, GROUP BY, window functions — ek page mein
SELECT
SELECT col1, col2 FROM table WHERE cond;JOIN
SELECT * FROM a INNER JOIN b ON a.id = b.id;GROUP BY
SELECT dept, COUNT(*) FROM emp GROUP BY dept;Window
SELECT name, RANK() OVER (ORDER BY salary DESC) FROM emp;🐍
Python Pandas Cheat Sheet
groupby, merge, pivot — sabse common functions
Read
df = pd.read_csv("data.csv")Group
df.groupby("dept")["salary"].sum()Merge
pd.merge(df1, df2, on="id", how="left")Clean
df.dropna(); df.fillna(0); df.drop_duplicates()📈
Power BI DAX Cheat Sheet
CALCULATE, TOTALYTD, FILTER, RANKX — quick reference
CALCULATE
CALCULATE(SUM(Sales[Amount]), Region="North")YTD
TOTALYTD([Total Sales], Calendar[Date])YoY
CALCULATE(SUM(Sales), SAMEPERIODLASTYEAR(Calendar[Date]))Rank
RANKX(ALL(Product[Name]), [Total Sales], , DESC, Dense)📗
Excel Formulas Cheat Sheet
XLOOKUP, SUMIFS, INDEX+MATCH — daily formulas
XLOOKUP
=XLOOKUP(A2, B:B, C:C, "Not Found")SUMIFS
=SUMIFS(Sales[Amt], Sales[Reg], "North")INDEX+MATCH
=INDEX(C:C, MATCH(A2, B:B, 0))IFS
=IFS(A1>90,"A", A1>75,"B", TRUE,"C")🎯
SQL Interview Questions
Top 30+ questions with answers — interview prep
2nd Highest
SELECT MAX(salary) FROM emp WHERE salary < (SELECT MAX(salary) FROM emp);Dept Count
SELECT dept, COUNT(*) FROM emp GROUP BY dept;Top 3
SELECT name FROM emp ORDER BY salary DESC LIMIT 3;RANK
SELECT name, RANK() OVER (ORDER BY salary DESC) FROM emp;🧠
SQL Playground
257 problems + 8 datasets — practice free
Problems
257 SQL problems (Easy/Medium/Hard)Datasets
8 real-world datasets (Fraud, Zomato, HR...)Submit
Answer check + confetti!URL
/tools/sql-playground💡 Aur resources chahiye?
🔍 Search karke dhundho | 📚 SQL tutorials | 🐍 Python | 📈 Power BI | 📗 Excel | 🎯 Interview Q&A
🔍 Search karke dhundho | 📚 SQL tutorials | 🐍 Python | 📈 Power BI | 📗 Excel | 🎯 Interview Q&A