#30daysofsql search results
Day 22 of #30DaysOfSQL Understanding Indexes in SQL Server ⚡ Indexes make queries faster by helping SQL Server find data without scanning the whole table. Think of an index as a table of contents for your data. 🧵
Day 21 of #30DaysOfSQL Nested Joins + Subqueries in Joins (SQL Server Edition) I’ve joined 2 tables before, now let’s link 3 or 4+ 💪🧵
Day 22 of #30DaysOfSQL Understanding Indexes in SQL Server ⚡ Indexes make queries faster by helping SQL Server find data without scanning the whole table. Think of an index as a table of contents for your data. 🧵
Day 21 of #30DaysOfSQL Nested Joins + Subqueries in Joins (SQL Server Edition) I’ve joined 2 tables before, now let’s link 3 or 4+ 💪🧵
Little win in my #30DaysOfSQL journey: I just switched from MySQL → SQL Server & wow, I see the flavours of SQL clearly now. ✅ MySQL: simple, great start ✅ SQL Server: richer (INTERSECT, EXCEPT, CTEs, window funcs) Even small syntax shifts = big growth. Loving it! #sql
Rules to remember: Both queries must return the same number of columns Data types must be compatible #30DaysOfSQL #SQLServer #LearningInPublic
Day 20 of #30DaysOfSQL Set Operators in SQL Server Sometimes, you need to compare results from 2 queries. Instead of joins, SQL gives us Set Operators Let’s break them down 🧵
Hi everyone, here's the link to the project I created for the #30DaysOfSQL challenge. I'd love your thoughts and feedback. Thank you for engaging. github.com/Elizabeth-moyi… #learnwithmoyinofcanada #30SQLchallenge #Datacommunity @cheftee_lead @Odunthedatagirl
It's day 30 of my 30 day SQL learning challenge, and it's been quite a journey. From struggling to import datasets into SQL Workbench and facing errors to mastering joins, subqueries, CTEs, and complex SQL functions that challenged my life choices.
Key takeaway: Self-joins let you explore hierarchies within one table. #SQL #30DaysOfSQL #LearningInPublic #DataAnalytics
Day 19 of #30DaysOfSQL Self-Joins Sometimes the data you need is in one table. That’s when we use a Self-Join. 🧵
Recap: INNER JOIN → only matches LEFT JOIN → all left RIGHT JOIN → all right FULL JOIN → simulate with UNION CROSS JOIN → all combos #SQL #MySQL #30DaysOfSQL #LearningInPublic
Day 18 of #30DaysOfSQL — FULL JOIN & CROSS JOIN (MySQL) MySQL doesn’t support FULL JOIN directly. But here’s how to handle it 🧵
Quick recap: INNER JOIN → only matches LEFT JOIN → all left + matches RIGHT JOIN → all right + matches Pro tip: To find missing rows, use LEFT JOIN ... WHERE right_table.col IS NULL. #SQL #30DaysOfSQL #DataAnalytics #LearningInPublic
Day 17 of #30DaysOfSQL LEFT JOIN vs RIGHT JOIN What if you want all rows from one table (even without a match)?🧵
I really enjoyed today’s learning experience, and hopefully, I’ll still be able to say the same tomorrow 😭😂. #30DaysOfSQL #SQL #DataCleaning #LearnSQL #SQLChallenge #DataAnalysis #LearnWithMoyinOfCanada
🍋 Turning Lemons to Lemonade Missed 4 days of my #30DaysOfSQL challenge. Work + Cider + DataCamp = overwhelming. But… small wins still count. Progress isn’t perfect, it’s persistence. Back on track & ready to keep building. #SQL #DataJourney #LearningInPublic
Day 14 of #30DaysOfSQL Today I learned Subqueries → queries inside queries. Think of it as: “Find X, then use X to find Y.”🧵
Day 22 of #30DaysOfSQL Understanding Indexes in SQL Server ⚡ Indexes make queries faster by helping SQL Server find data without scanning the whole table. Think of an index as a table of contents for your data. 🧵
Day 21 of #30DaysOfSQL Nested Joins + Subqueries in Joins (SQL Server Edition) I’ve joined 2 tables before, now let’s link 3 or 4+ 💪🧵
Something went wrong.
Something went wrong.
United States Trends
- 1. #2025MAMAVOTE 907K posts
- 2. $ZOOZ N/A
- 3. Good Thursday 28.3K posts
- 4. Mila 18.3K posts
- 5. #ThursdayThoughts 1,819 posts
- 6. #thursdayvibes 2,714 posts
- 7. Deloitte 12.5K posts
- 8. #TOMORROWXTOGETHER 44.1K posts
- 9. Deport Harry Sisson 18K posts
- 10. Ninja Gaiden 18.1K posts
- 11. #JoyForum 2,242 posts
- 12. Happy Friday Eve N/A
- 13. Dead or Alive 16K posts
- 14. Tomonobu Itagaki 12.9K posts
- 15. Jennifer Welch 5,742 posts
- 16. DuPont 2,467 posts
- 17. Bernie 43.5K posts
- 18. Starting 5 7,092 posts
- 19. Andrade 5,264 posts
- 20. New Yorkers 27.1K posts