#30dayssqlchallenge 검색 결과
🚀 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. The BONK 40.5K posts
- 2. FINALLY DID IT 395K posts
- 3. #Nifty 8,444 posts
- 4. $FULC 8,058 posts
- 5. Jalen 74.4K posts
- 6. US Leading Investment Team 4,450 posts
- 7. Eagles 117K posts
- 8. Good Tuesday 24.5K posts
- 9. Chargers 85.3K posts
- 10. Herbert 33.4K posts
- 11. AJ Brown 10.3K posts
- 12. Piers 83.9K posts
- 13. #BoltUp 4,658 posts
- 14. #WWERaw 50.6K posts
- 15. Tony Jefferson 3,108 posts
- 16. Fuentes 117K posts
- 17. Sirianni 5,690 posts
- 18. Saquon 11.6K posts
- 19. Cam Hart 1,394 posts
- 20. LA Knight 10.8K posts