#30dayssqlchallenge Suchergebnisse
🚀 Day 28 of my #30DaysSQLChallenge – Analytics SQL: Time Series Analysis Time series analysis isn’t just for data science tools like Python or R — you can do a lot directly in SQL! I’ve practiced different SQL techniques that help uncover trends and insights over time.
Day 23 of my #30DaysSQLChallenge – Transactions & Constraints Today’s topic is too broad to cover in just one sitting. So I’ll be dividing it into two parts for better clarity: Part 1 (Today): Understanding what Transactions and Constraints are.
🚀 Day 22 of my #30DaysSQLChallenge Today, I focused on Joins and Views in SQL. While joins are powerful for combining data across multiple tables, I found views especially interesting: 🔹 A view is like a virtual table that stores a query for easy reuse.
🚀 Day 17 of my #30DaysSQLChallenge 🚀 Today’s focus: Common Table Expressions (CTEs) A CTE is a temporary named result set that exists only within the query that follows it. Working with CTEs today helped me break complex queries into smaller steps instead
Today’s focus: applying subqueries with ANY and ALL — for example, finding employees with more vacation hours than employees in a specific department. Halfway there, and the motivation is only growing. 🚀 Let’s go for the next 15 days! #30DaysSQLChallenge #SQL #LearningInPubli
#30daysSQLchallenge, #learnwithmoyinofcanada , #data analysis.
Day 2 of my #30DaysSQLChallenge I started today’s challenge by trying to fix the error I ran into yesterday using Python, but I ended up making things worse. 😅 I couldn’t do much querying because I had to go for my monthly biometric clearance, which was really exhausting.
I started my SQL journey today by downloading the Spotify dataset from Kaggle. My plan was to start simple with the SELECT statement, but things didn’t go as planned 😭. I ran into several errors while trying to import the CSV file into MySQL Workbench.
Day 6 of #30DaysSQLChallenge ✅ 🎯 Focus: Understanding GROUP BY! ✨ Learned: Aggregate data using COUNT, SUM, AVG, and more. 💡 Takeaway: GROUP BY is the key to insightful summaries in SQL! 🚀 #SQL #DataScience #30DaysOfSQL #TechJourney #DataEngineer #Day06 (18 Nov. 2024)
Foundations of SQL Day 16: LEFT JOIN Question: List all departments and their employees, including departments with no employees. @AnalystsLeague @RxData_ @iam_daniiel #30daysSQLChallenge
Foundations of SQL Day 15: JOIN Operations (INNER JOIN) Question: Retrieve employee details along with their department names. @analystsleague @RxData_ @iam_daniiel #30daysSQLChallenge
Something went wrong.
Something went wrong.
United States Trends
- 1. Notre Dame 155K posts
- 2. Browns 70.7K posts
- 3. Caleb Williams 6,100 posts
- 4. Shedeur 89.4K posts
- 5. Ravens 46.3K posts
- 6. Packers 37.2K posts
- 7. Stefanski 26.5K posts
- 8. Bengals 42.3K posts
- 9. Christian Watson 4,378 posts
- 10. Nixon 7,676 posts
- 11. #GoPackGo 6,894 posts
- 12. ESPN 113K posts
- 13. Josh Allen 20.8K posts
- 14. Jordan Love 10.5K posts
- 15. Titans 33.7K posts
- 16. Steelers 54.2K posts
- 17. Puka 5,454 posts
- 18. #Bears 4,417 posts
- 19. Bills 94.2K posts
- 20. Lamar 28.5K posts