#SQLWithIDC Etiketinde En Popüler Paylaşımlar

7 ay önce

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

Vikash040999's tweet photo. 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 https://t.co/2EqIM0gJX6

0

2

1

0

33

8 ay önce

Day 19 of my 21 Days SQL Challenge ⚡ Exploring row level ranking for deeper analytical insights Topics: ROW_NUMBER(), RANK(), DENSE_RANK(), OVER clause Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC

vinitsolanki111's tweet photo. Day 19 of my 21 Days SQL Challenge ⚡

Exploring row level ranking for deeper analytical insights

Topics: ROW_NUMBER(), RANK(), DENSE_RANK(), OVER clause

Challenge by
@indiandataclub & @dpdzero
#21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC https://t.co/z940Npzcno

0

2

0

12

8 ay önce

Day 19/21 days sql challenge #SQLwithIDC with @indiandataclub and @dpdzero SELECT SERVICE, SUM(PATIENTS_ADMITTED) AS TOTAL_PATIENTS_ADMITTED, RANK() OVER (ORDER BY SUM(PATIENTS_ADMITTED) DESC) AS ADMISSION_RANK FROM SERVICES_WEEKLY GROUP BY SERVICE;

saikiranudayana's tweet photo. Day 19/21 days sql challenge
#SQLwithIDC
with @indiandataclub and @dpdzero
SELECT SERVICE,
SUM(PATIENTS_ADMITTED) AS TOTAL_PATIENTS_ADMITTED,
RANK() OVER (ORDER BY SUM(PATIENTS_ADMITTED) DESC) AS ADMISSION_RANK
FROM SERVICES_WEEKLY
GROUP BY SERVICE; https://t.co/KYarIq2u7l

0

3

0

27

8 ay önce

Day 18 — #21DaysSQL Challenge with #SQLWithIDC Today’s task: 🔗 Combine patients + staff from critical departments (Surgery & Emergency) @dpdzero @indiandataclub unified healthcare insights On to Day 19! 🚀 #SQL #DataAnalytics #IndianDataClub #DPDzero #AnalyticsJourney

Vikash040999's tweet photo. Day 18 — #21DaysSQL Challenge with #SQLWithIDC

Today’s task:
🔗 Combine patients + staff from critical departments
(Surgery & Emergency)

@dpdzero @indiandataclub

unified healthcare insights
On to Day 19! 🚀
#SQL #DataAnalytics #IndianDataClub #DPDzero #AnalyticsJourney https://t.co/2gpXRMAIht

0

3

0

20

Rishabh Bahuguna @RishabhBahuguna

8 ay önce

Day 18 of my 21 Days SQL Challenge ⚡ Learning how to merge results from multiple queries into one dataset. Topics: UNION, UNION ALL, combining result sets Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC

vinitsolanki111's tweet photo. Day 18 of my 21 Days SQL Challenge ⚡

Learning how to merge results from multiple queries into one dataset.

Topics: UNION, UNION ALL, combining result sets

Challenge by
@indiandataclub
&
@dpdzero
#21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC https://t.co/GYF1ZxxcGD

0

4

0

18

8 ay önce

#SQLWithIDC #DataAnalytics #21DayChallenge #learnsql @indiandataclub @dpdzero

0

2

0

13

Rishabh Bahuguna @RishabhBahuguna

8 ay önce

#SQLWithIDC #DataAnalytics #21DayChallenge #learnsql @indiandataclub @dpdzero

0

2

0

12

8 ay önce

day -18/21 Days SQl challenge #SQLwithIDC Getting back to the Grind of SQL with @indiandataclub and @dpdzero

0

4

0

27

8 ay önce

Day 17 — #21DaysSQLChallenge (IDC) Task: Compare each hospital service’s admissions against the overall average. 🔍 What we reported: 🧠 identify services & areas needing support. @dpdzero @indiandataclub On to Day 18 🚀 #SQLWithIDC #DataAnalytics #DPDzero #IndianDataClub

Vikash040999's tweet photo. Day 17 — #21DaysSQLChallenge (IDC)

Task: Compare each hospital service’s admissions against the overall average.

🔍 What we reported:

🧠 identify services & areas needing support.
@dpdzero @indiandataclub

On to Day 18 🚀
#SQLWithIDC #DataAnalytics #DPDzero #IndianDataClub https://t.co/BTg99qMwqS

1

3

0

76

8 ay önce

🚑 Day 15 — SQL Healthcare Analytics Today’s task: Build a service-level performance report for Week 20 combining: Bringing admissions, satisfaction & staffing into a single view = real insights. @dpdzero @indiandataclub #21DaysSQLChallenge #SQLWithIDC #DataAnalytics #Day15

Vikash040999's tweet photo. 🚑 Day 15 — SQL Healthcare Analytics

Today’s task: Build a service-level performance report for Week 20 combining:

Bringing admissions, satisfaction & staffing into a single view = real insights.
@dpdzero @indiandataclub
#21DaysSQLChallenge #SQLWithIDC #DataAnalytics #Day15 https://t.co/EZim0lYGUy

1

3

0

36

Ashvini Patil @vini_pa99796

8 ay önce

day 16/21days sql challenge Back to the SQL grind #SQLwithIDC with @indiandataclub and @dpdzero

0

3

0

23

8 ay önce

Day 14 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero Explored LEFT & RIGHT JOIN to handle unmatched records. Built a staff utilization report showing all staff + their weeks present. Takeaway: JOINs + COALESCE = clean, complete insights. #SQLWithIDC #SQL

vini_pa99796's tweet photo. Day 14 ✅ of #21DaysSQLChallenge by @IndianDataClub x @DPDzero

Explored LEFT & RIGHT JOIN to handle unmatched records. Built a staff utilization report showing all staff + their weeks present.

Takeaway: JOINs + COALESCE = clean, complete insights.

#SQLWithIDC #SQL https://t.co/P6uYa7sp7I

0

2

0

18

Abhilasha @abhilashadhole5

8 ay önce

𝗗𝗮𝘆 14 of #21DaysSQLChallenge 🚀 Today’s focus: LEFT & RIGHT JOIN — include unmatched records for a complete view. 💡 Key Takeaways: ✅ LEFT JOIN → all left rows + matches ✅ RIGHT JOIN → all right rows + matches ✅ Use COALESCE to handle NULLs #SQLWithIDC

abhilashadhole5's tweet photo. 𝗗𝗮𝘆 14 of #21DaysSQLChallenge 🚀
Today’s focus: LEFT & RIGHT JOIN — include unmatched records for a complete view.

💡 Key Takeaways:
✅ LEFT JOIN → all left rows + matches
✅ RIGHT JOIN → all right rows + matches
✅ Use COALESCE to handle NULLs

#SQLWithIDC https://t.co/wnFVtwDfjC

0

3

0

17

8 ay önce

Day 14 of my 21 Days SQL Challenge ⚡ Topics: LEFT JOIN, RIGHT JOIN, including unmatched records Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC

vinitsolanki111's tweet photo. Day 14 of my 21 Days SQL Challenge ⚡

Topics: LEFT JOIN, RIGHT JOIN, including unmatched records

Challenge by
@indiandataclub & @dpdzero
#21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC https://t.co/c8DY9pBk7i

0

2

0

19

Abhilasha @abhilashadhole5

8 ay önce

Day 13 of my 21 Days SQL Challenge ⚡ Topics: INNER JOIN, joining two tables, relationship understanding Challenge by @indiandataclub & @dpdzero #21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC

vinitsolanki111's tweet photo. Day 13 of my 21 Days SQL Challenge ⚡

Topics: INNER JOIN, joining two tables, relationship understanding

Challenge by
@indiandataclub
&
@dpdzero
#21DaysSQLChallenge #SQLDeveloper #LearnSQL #DataAnalytics #SQLwithIDC https://t.co/YYzjSqAoSg

0

2

0

19

8 ay önce

𝗗𝗮𝘆 13 of #21DaysSQLChallenge 🚀 INNER JOIN — connect tables, get only matching rows. 💡 Tips: ✅ Use aliases & qualify columns ✅ Chain joins for insights ✅ Filter with WHERE after join #SQLWithIDC

abhilashadhole5's tweet photo. 𝗗𝗮𝘆 13 of #21DaysSQLChallenge 🚀

INNER JOIN — connect tables, get only matching rows.

💡 Tips:
✅ Use aliases & qualify columns
✅ Chain joins for insights
✅ Filter with WHERE after join
#SQLWithIDC https://t.co/jxJSaU77vc

0

2

0

27