#sqlwithidc resultados de búsqueda
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 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 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!
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
𝗗𝗮𝘆 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
𝗗𝗮𝘆 𝟭𝟴 #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! 🙌
𝐃𝐚𝐲 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 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 -18/21 Days SQl challenge #SQLwithIDC Getting back to the Grind of SQL with @indiandataclub and @dpdzero
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
Day 1/21 ✅ — #SQLWithIDC Starting my SQL journey with SELECT, DISTINCT & FROM Learning how to ask data questions with SQL. Query: SELECT DISTINCT service_name FROM services_weekly; #SQL #DataAnalytics #21DaysOfSQLChallenge
Sharing my 21 Days SQL Challenge Certificate! 🙌 Thanks @IndianDataClub & @dpdzero for the learning journey. #SQLWithIDC #SQL #Analytics
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
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 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Topic: CASE WHEN & Conditional Logic Today I learned to make SQL smarter — adding if-else logic inside queries 💡 Categorized satisfaction, grouped patients, & built performance reports with CASE! #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
Something went wrong.
Something went wrong.
United States Trends
- 1. #Supergirl 89.9K posts
- 2. The WET 38.1K posts
- 3. Lobo 20.3K posts
- 4. NASCAR 11.7K posts
- 5. Kilmar Abrego Garcia 9,151 posts
- 6. Godzilla 32.2K posts
- 7. Guardians of the Galaxy 1,541 posts
- 8. Bennie Thompson 10.7K posts
- 9. #RIME_NEWS N/A
- 10. Noem 65.1K posts
- 11. Michigan Man 8,498 posts
- 12. Algorhythm Holdings 1,814 posts
- 13. Denny 2,573 posts
- 14. Sora 51.8K posts
- 15. Krypto 15K posts
- 16. OpenAI 26.4K posts
- 17. #thursdayvibes 3,155 posts
- 18. Schefter 1,090 posts
- 19. Johnny Morris 1,372 posts
- 20. Unfortunate Accident 10.6K posts