Preet Sharma

Data Analyst | Ex-Indiamart | Ex-VGL
Here to learn and build in public

[Preet Sharma @ps_preetsharma]

Day R4 of SQL Revision Sprint!
(Reviewing Days 13–16 of #50DaysOfSQL)
• Set operations: UNION, INTERSECT, EXCEPT
• Non-Equi Joins
• Window Functions: RANK(), ROW_NUMBER()

One more revision day to go before jumping back in full swing!
#LearnInPublic #SQLChallenge #DataSkills

[Preet Sharma @ps_preetsharma]

Day R3 of SQL Revision Sprint!
(Reviewing Days 9–12 of #50DaysOfSQL)
• Nested Subqueries
• Mastered Joins: INNER, LEFT, RIGHT, FULL OUTER
• Self-Joins & Cross-DB joins
• Revisited Mini-Project 2: Sales & Shipping Insights

One JOIN at a time!
#SQL #LearnInPublic #DataSkills

[Preet Sharma @ps_preetsharma]

Day R2 of SQL Revision Sprint!
(Reviewing Days 5–8 of #50DaysOfSQL)
• Revisited my 1st mini-project: Invoicing system analysis
• Refreshed string/date/numeric functions
• Grouped & aggregated data
• GROUP BY, HAVING, nested CONCAT

#LearnInPublic #DataSkills #DataAnalytics

[Preet Sharma @ps_preetsharma]

Restarting my #50DaysOfSQL journey with a 5-day revision sprint!

Day R1:
• SQL Basics
• Filtering with WHERE, IN, LIKE
• Sorting + DISTINCT
• Practice queries to warm up 🔥
Back in query mode after a 4-month break 😅 Let’s go! 🚀
#LearningInPublic #SQLChallenge #DataSkills

[Preet Sharma @ps_preetsharma]

Day 20 of #50DaysOfSQL ✅

Mastered Recursive Queries for:
• Organizational hierarchies 🔗
• Summing numbers ➕
• Directory trees 🗂️
Recursive queries make hierarchical data analysis a breeze! Solved 6 questions on HackerRank today 🚀
#LearningInPublic #SQL #DataSkills

[Preet Sharma @ps_preetsharma]

Day 19 of #50DaysOfSQL

Explored the magic of 𝗦𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀:
• WHERE: Dynamic filtering
• FROM: Derived tables
• SELECT: Calculated metrics
• Correlated Subqueries: Row-by-row comparisons

#LearnInPublic #SQL #DataSkills

[Preet Sharma @ps_preetsharma]

Looking to #Connect with people interested in:
-Software Dev
-Web Dev
-Front End
-Back End
-Data Analysis
-Data Science
#LearnInPublic #buildinpublic #100DaysOfCode #CareerChange

[Preet Sharma @ps_preetsharma]

Day 18 of #50DaysOfSQL

After a break, I'm restarting the series! 🚀 Spent today revising everything I’ve covered so far, from basic queries to window functions. Feeling ready to dive back into learning new concepts tomorrow!

#SQL #LearnInPublic #DataSkills #SQLChallenge

[Preet Sharma @ps_preetsharma]

Day 17 of #50DaysOfSQL ✅

Mastered 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗪𝗶𝗻𝗱𝗼𝘄 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀:
• Running Totals 📊
• Percentiles (PERCENT_RANK(), CUME_DIST()) 🏅
• Moving Averages 📈
• First & Last Values 🔍
Solved 1 questions on @hackerrank just keeps getting better! 🚀

[Preet Sharma @ps_preetsharma]

Day 16 of #50DaysOfSQL ✅

Revision day! Spent time reviewing everything from basic queries to window functions. Feels great to solidify the foundation before diving deeper. 🚀

#LearningInPublic #SQL #DataSkill

[Preet Sharma @ps_preetsharma]

Day 15 of #50DaysOfSQL ✅

Learned the magic of 𝗪𝗶𝗻𝗱𝗼𝘄 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀:
• Ranked rows using ROW_NUMBER() & RANK()
• Calculated running totals with SUM()
• Used LAG() & LEAD() to compare rows
• Applied moving averages for trends
Solved 1 question on HackerRank

[Preet Sharma @ps_preetsharma]

Day 14 of #50DaysOfSQL

Mastered 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗝𝗼𝗶𝗻𝘀:
• Self-Joins: Compare rows within the same table
• Cross-DB Joins: Combine multiple databases
• Non-Equi Joins: Map ranges with BETWEEN
Solved 1 question on @hackerrank just keeps getting better!

[Preet Sharma @ps_preetsharma]

Day 13 of #50DaysOfSQL ✅

Learned 𝗦𝗲𝘁 𝗢𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝘀:
• UNION/UNION ALL: Combine datasets
• INTERSECT: Find common rows
• EXCEPT: Compare differences

#LearningInPublic #SQL #DataSkills

[Preet Sharma @ps_preetsharma]

Day 12 of #50DaysOfSQL ✅

Learned 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗝𝗼𝗶𝗻𝘀:
• Self-Joins: Compare data in the same table
• Cross-DB Joins: Combine data from multiple databases
• Recursive CTEs: Build hierarchies 🔄
SQL is getting next-level! 🚀
#LearningInPublic #SQL #DataSkills

[Preet Sharma @ps_preetsharma]

Day 11 of #50DaysOfSQL ✅

Worked on a project analyzing:
• Top products by sales & revenue 🛍️
• Customer activity to find key spenders 💳
• Shipping trends for logistics insights 🚚

#LearningInPublic #SQL #DataSkills

[Preet Sharma @ps_preetsharma]

🔄 Back to #50DaysOfSQL after a 2-day break! 🔄
Used the time to revise what I learned in the first 10 days. Now ready to apply those skills in a project! 🚀
#LearningInPublic #SQL #DataSkills

[Preet Sharma @ps_preetsharma]

Day 10 of #50DaysOfSQL

Learned the magic of 𝗝𝗼𝗶𝗻𝘀:
• Matched clients & invoices with 𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡
• Included unmatched data with 𝗟𝗘𝗙𝗧 & 𝗙𝗨𝗟𝗟 𝗢𝗨𝗧𝗘𝗥 𝗝𝗢𝗜𝗡
• Generated combinations using 𝗖𝗥𝗢𝗦𝗦 𝗝𝗢𝗜𝗡
Solved 7 questions on HackerRank
#Learn #SQL

[Preet Sharma @ps_preetsharma]

Day 9 of #50DaysOfSQL

Learned 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗚𝗿𝗼𝘂𝗽𝗶𝗻𝗴 & 𝗡𝗲𝘀𝘁𝗲𝗱 𝗤𝘂𝗲𝗿𝗶𝗲𝘀:
• Grouped by multiple columns (e.g., client + year)
• Filtered data with subqueries
• Built virtual tables for deeper analysis
Solved x questions on @HackerRank
#LearningInPublic

[Preet Sharma @ps_preetsharma]

📊 Day 8 of #50DaysOfSQL ✅

Mastered 𝗔𝗴𝗴𝗿𝗲𝗴𝗮𝘁𝗶𝗼𝗻 & 𝗚𝗿𝗼𝘂𝗽𝗶𝗻𝗴:
• Aggregates: COUNT, SUM, AVG, MIN, MAX
• Grouped data with GROUP BY
• Filtered groups with HAVING
Solved 5 questions on HackerRank—feeling more data-savvy every day! 🚀
#LearningInPublic #SQL

[Preet Sharma @ps_preetsharma]

Milestone Accomplished🎉
Completed 1 week of #50DaysOfSQL
I didn't gain any followers though😢

Let's #connect if you are interested in:
📷Web Development
📷Data Science
📷Data Analysis
📷SQL
📷Excel
📷Python
📷Power BI
#data #buildinpublic #Technology