#sqlwithidc 検索結果
Day 14 #SQLWithIDC INNER JOIN seeks alignment LEFT JOIN preserves perspective RIGHT JOIN changes it A NULL in a LEFT JOIN isn’t absence — it’s a story untold, a connection yet to be made Data reminds us: inclusion reveals as much as matching ever will @indiandataclub @dpdzero
Day 21 #SQLWithIDC CTEs transform tangled logic into elegant, reusable steps, turning complexity into insight. From simple stats to multi-step analysis, CTEs are a game-changer for query organization. @indiandataclub @dpdzero
Day 10 of #SQLWithIDC 🚀— CASE statements 💡 Key takeaways: • Use CASE to categorize or create conditional metrics • Always include ELSE (avoid NULLs) • Works in SELECT, ORDER BY, and GROUP BY • First match wins — order matters!
𝗗𝗮𝘆 12 #21DaysSQLChallenge 🚀 Handling NULLs & comparing categories ✅ IS NULL / IS NOT NULL ✅ COALESCE for fallback ✅ COUNT(*) vs COUNT(column) ✅ CTE + CASE for clean summaries ⚠️ Don’t treat NULL as a value Stepwise queries = clear & scalable SQL! 🙌 #SQLWithIDC
𝐃𝐚𝐲 21/21 – 𝐒𝐐𝐋 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞🚀 🔸Learned CTEs today — clean, readable queries with step-by-step logic. 🔸Perfect for breaking down complex reports easily. 🔥 🔸CTEs > nested subqueries any day! ⚡ #SQLWithIDC #CTE #IndianDataClub #DPDzero
Day 18 #SQLWithIDC 🔶UNION removes duplicates, slower but unique results. 🔷UNION ALL keeps all rows, faster performance. 🔶Same columns + compatible types. Use ORDER BY last. Pro tip: Use UNION ALL when duplicates aren't an issue! @indiandataclub @dpdzero
Day 12 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Dived into NULL handling. Today’s challenge: compare weeks “With Event” vs “No Event” and analyze satisfaction + morale. Key learning: NULLs change everything—handle them smartly! #SQLWithIDC
🚀 𝐃𝐚𝐲 19 — 𝐈𝐃𝐂 𝐒𝐐𝐋 𝐂𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞 Window functions unlocked today! 🔍 ROW_NUMBER = unique RANK = ties with gaps DENSE_RANK = ties without gaps ✨Perfect for top-N insights & performance ranking📊 #SQLWithIDC
𝗗𝗮𝘆 𝟭𝟴 #SQLWithIDC🚀 Today I explored UNION & UNION ALL — combining multiple queries into one dataset! ✨ 💡Quick Tips: • UNION = no duplicates✅ • UNION ALL = keeps all✅ • Match columns & types • Order only after final result Combine smartly, analyze faster! 🙌
Day 19 #SQLWithIDC 🔶ROW_NUMBER(): Unique sequence for each row 🔷RANK(): Ties share rank, gaps appear 🔶DENSE_RANK(): Ties share rank, no gaps Use OVER() with PARTITION BY & ORDER BY to rank data fairly & powerfully. @indiandataclub @dpdzero
Day 10 | #21DaysSQLChallenge with @indiandataclub & @dpdzero Learned conditional logic with CASE WHEN: 🔹 Categorised satisfaction levels 🔹 Grouped staff roles 💡 Challenge: Classify services as Excellent, Good, Fair, or Needs Improvement #SQLWithIDC #SQL #DataAnalytics
Day 12 of #21DaysSQLChallenge by @IndianDataClub & @dpdzero 🔹 Topic: NULL Handling Learned how to work with missing data using IS NULL, IS NOT NULL, and COALESCE() to replace NULLs and ensure accurate filtering and calculations. #SQLWithIDC #LearnSQL #IDCChallenge
I did it! 21 Days of SQL. 21 Days of learning. 21 Days of consistency. Thanks @DPDzero and @IndianDataClub for making the journey so engaging. #SQLWithIDC #SQL #TechCommunity
Day 20 #SQLWithIDC Window functions like SUM() OVER and AVG() OVER unlock running totals, moving averages, and cumulative stats no GROUP BY needed. Track trends, smooth data, and compare values in a single query. Power up your analytics! @indiandataclub @dpdzero
Completed 7 days of the 21 Days SQL Challenge. Staying consistent has helped me strengthen my foundation and approach problems with clarity. Looking forward to learning more and progressing further in the upcoming days. Tagging @dpdzero and @indiandataclub #SQLWithIDC
Something went wrong.
Something went wrong.
United States Trends
- 1. Malik Willis 7,348 posts
- 2. Tulane 28.5K posts
- 3. Packers 38.8K posts
- 4. Bears 59.1K posts
- 5. Jordan Love 8,856 posts
- 6. Oregon 27.3K posts
- 7. Ben Johnson 4,012 posts
- 8. Eagles 81.8K posts
- 9. #GoPackGo 5,515 posts
- 10. #GuerraDeTitanes 8,047 posts
- 11. Booker 6,872 posts
- 12. #GBvsCHI 1,485 posts
- 13. Josh Johnson 3,778 posts
- 14. Andrew Tate 43.8K posts
- 15. Dennis Allen N/A
- 16. DJ Moore 2,162 posts
- 17. Group of 5 8,289 posts
- 18. Notre Dame 37.7K posts
- 19. Will Richard 3,935 posts
- 20. Dante Moore 1,579 posts