#sqlwithidc wyniki wyszukiwania
Day 10 #SQLWithIDC 🔶SQL CASE WHEN is where data learns to think 🔷It turns numbers into stories, groups into insights, and queries into decisions 🔶From categorizing patients to custom sorting, CASE 🔷WHEN bridges data and meaning @indiandataclub @dpdzero
Day 12 #SQLWithIDC In SQL, NULL is not a value it’s the silence between the notes. It’s the unknown, the missing, the unrecorded. IS NULL, IS NOT NULL, COALESCE() these are not just keywords, they’re the tools to give meaning to absence. @indiandataclub @dpdzero
day -18/21 Days SQl challenge #SQLwithIDC Getting back to the Grind of SQL with @indiandataclub and @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
𝗗𝗮𝘆 𝟭𝟴 #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 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/21 days sql challenge #SQLwithIDC SELECT SERVICE,COUNT(*) AS total_patients_admitted,AVG(SATISFACTION) AS avg_satisfactionCASE AVG(SATISFACTION) >= 85 'Excellent' AVG(SATISFACTION) >= 75 'Good' AVG(SATISFACTION) >= 65 'Fair' ELSE 'Needs Improvement'END AS pc FROM patients
Day 15 #SQLWithIDC🚀 Today’s focus: joining 3+ tables — the real power move in SQL! 💡 Key Learnings: 🔗 Join tables left → right 🎯 Mix INNER + LEFT wisely 🧩 Use DISTINCT / GROUP BY to remove duplicates ⚠️ Avoid missing join conditions & WHERE filters that break LEFT JOINs
Capstone project done!🕵️♀️ Final task of the #21DaysSQLChallenge: solve a CEO murder case using only SQL. From keycard logs to alibis to suspicious calls, every clue came from a query. Huge thanks to @IndianDataClub & @DPDzero for an amazing journey. #SQLWithIDC #SQL
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
Day 14/21 dayssqlchallenge #SQLwithIDC Excited to share that as part of the #SQLwithIDC challenge, I completed over 400 lines of SQL within just 14 days. Grateful to be part of this learning journey! @indiandataclub @dpdzero
🚀 Day 1 of the IDC 21 Days SQL Challenge! Started my journey with basics: SELECT, filtering, exploring tables & finding unique values with DISTINCT. Day 1 challenge: List all unique hospital services. Big thanks to IDC & @dpdzero for the supportive community!🙌 #SQLWithIDC
Day 15 #SQLWithIDC I explored the art of joining tables, untangling complex relationships,and turning raw data into meaningful insights.This journey isn’t just about queriesit’s about seeing patterns, solving problems, and mastering the language of data @indiandataclub @dpdzero
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
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
🚀 Day 3 of the IDC 21 Days SQL Challenge! Today’s focus: mastering ORDER BY 🔍 Learned how sorting order matters, using DESC for Top N, and why indexes make sorting faster on large datasets SQL turns chaos into clarity! 💡 #SQLWithIDC
Day 15/21 SQL Challenge I have some commitments tomorrow, so I’m submitting the challenge a day early. I don’t want to break my streak — losing it would hurt more than a breakup! 😄 #SQLwithIDC with @indiandataclub and @dpdzero
#SQLWithIDC #portfolioshowcase #portfolio #presentation #businesspresentation #storytelling #DataAnalytics #21DayChallenge #learnsql @indiandataclub @dpdzero
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
The perfect end to the 21-day journey. SQL isn’t just about queries — it’s problem-solving, storytelling & logic. Proud to have completed this challenge! 🚀 @indiandataclub @dpdzero #SQLWithIDC #SQLMystery #21DaysSQLChallenge #DataAnalytics
🕵️♂️ Capstone Completed! | SQL Murder Mystery- “Who Killed the CEO?” Wrapped up the 21-Day SQL Challenge by @indiandataclub with a final investigation project where I solved a murder case using SQL, not fingerprints. @dpdzero #21DaysSQLChallenge #SQLWithIDC
🌟 21 Days. 21 Chances to Grow. I just earned my 21-Day SQL Challenge Badge with #SQLWithIDC! 🚀 It’s not just a badge — it’s proof of showing up every day, learning, practicing, and building consistency. 💫 💭 Lesson: Progress > Perfection. Keep going, every day counts!
🕵️♀️ SQL Murder Mystery — Solved! ➡️All clues point to David Kumar - the only one in the CEO office during the crime, a false alibi, a suspicious call at 8:55 PM, and matching fingerprints. Sponsored by @DPDzero | Organized by @IndianDataClub #SQLWithIDC #21DaysSQLChallenge
Capstone project done!🕵️♀️ Final task of the #21DaysSQLChallenge: solve a CEO murder case using only SQL. From keycard logs to alibis to suspicious calls, every clue came from a query. Huge thanks to @IndianDataClub & @DPDzero for an amazing journey. #SQLWithIDC #SQL
CapStone:I uncovered the killer behind TechNova Inc.’s CEO murder. 🔍 Killer Identified: David Kumar 📊 Skills Used: JOINs, time filtering, CTEs, pattern tracing SQL isn’t just queries — it’s detective work. Linkedin:linkedin.com/feed/update/ur… #SQLWithIDC @indiandataclub @dpdzero
linkedin.com
#sqlwithidc #sqlwithidc #learnsql #sqlforbeginners #dataanalytics #journeyintotech #growthmindset...
SQL Murder Mystery: “Who Killed the CEO?” With #SQLWithIDC 🗂️ A Data-Driven Investigation Using Pure SQL I recently completed the SQL Murder Mystery Challenge, where I investigated the death of...
✅Day 21 of #SQLWithIDC Challenge Complted! sponsored by @dpdzero & organized by @indiandataclub. 💡Today’s concept: CTEs — the best way to simplify complex SQL into clean, readable steps. 🎯 Challenge: Build a hospital performance dashboard using 3 CTEs + final performance.
🗓️ Day 21 of #21DaysSQLChallenge by @indiandataclub! Today's topic: CTEs🎯 Using the WITH clause, you can create a temporary named result set & build your query step by step! Key takeaways💡 • Break complex queries into simple steps • Reuse logic • Easy to debug #SQLWithIDC
Day 21 — #21DaysSQLChallenge (Final Day!) 🚀 Wrapped up the challenge by building a full performance dashboard 1️⃣ Patient metrics 2️⃣ Service metrics 3️⃣ Staff metrics 21 days done — SQL muscles upgraded 💪 @dpdzero @indiandataclub #SQLWithIDC #SQL #DataAnalytics #Day21
Day 21. Final day of the 21 Days of SQL Challenge. I built a dashboard with CTEs combining service metrics, staff metrics, and patient demographics, then computed a weighted performance score. @indiandataclub @dpdzero #SQL #SQLWithIDC
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
𝐃𝐚𝐲 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
✅ Completed Day 20 - Window Functions Sponsored by @dpdzero & Organized by @indiandataclub. - Worked with running totals, moving averages, and trend analysis using SUM() OVER & AVG() OVER. - Analyzed weeks 10–20 for admissions + satisfaction trends. 🔍 #SQLWithIDC
Today’s Learning : SQL window functions. SUM() OVER for running totals, AVG() OVER for moving averages, and ROWS BETWEEN to control the window. Helps analyze trends without losing rows. #sqlwithidc #sqllearning #indiandataclub
🗓️ Day 20 of #21DaysSQLChallenge by @indiandataclub! Topic: Aggregate Window Functions! Key idea: calculate totals without losing rows Frame controls: UNBOUNDED PRECEDING = from start N PRECEDING = last N rows CURRENT ROW = this row N FOLLOWING = next N rows #SQLWithIDC #SQL
Something went wrong.
Something went wrong.
United States Trends
- 1. Tulane 13.9K posts
- 2. Gunther 24.2K posts
- 3. Cocona 92.8K posts
- 4. #SmackDown 35.9K posts
- 5. fnaf 2 64.6K posts
- 6. #AAA2025 42.5K posts
- 7. North Texas 7,519 posts
- 8. #MCWonyoungAAAte 10.6K posts
- 9. #GCWSay N/A
- 10. 5 YEARS WITH MC WONYOUNG 10.2K posts
- 11. Anthony Davis 2,305 posts
- 12. Boise State 3,812 posts
- 13. LA Knight 11.1K posts
- 14. Trouba 1,234 posts
- 15. #ROHFinalBattle 18.7K posts
- 16. UNLV 4,435 posts
- 17. Meek 8,832 posts
- 18. Flag Day 3,167 posts
- 19. Dizzy 6,569 posts
- 20. Athena 10.8K posts