Day 14–16 mySQL Learned logical functions:IFNULL, IF, CASE for conditional queries. Practiced date functions:DATE_ADD, DATE_SUB, DATEDIFF, CURRENT_DATE, TIMESTAMPDIFF. Used COALESCE to handle NULLs. Wrote queries to calculate employee age &group them into categories. #SQL #Data
Day 10–12 of mySQL Challenge Day 10 – Learned GROUP BY with aggregates like SUM to find total salaries per department. Day 11 – Used MAX with GROUP BY to find the country+language with the highest speakers. Day 12 – Practiced HAVING to filter aggregated results. #SQL
Day 9 of MySQL challenge Today,I dived into pattern matching with LIKE & REGEXP. I practiced filtering employees by job titles, listing Sakila actors starting with “S”, pulling Nigerian cities from World DB, and finding countries ending with “A”. SQL + REGEXP = data sniper 🎯
My laptop stopped working for a couple of days but it’s back now,I’ll make sure to share what I learned during that period following the MySQL 30day challenge
🎊🤩 Excited to announce that I’ll be starting the 100 Days of Cybersecurity challenge For the next 100 days, I’ll be learning, practicing, and sharing insights as I deepen my knowledge and skills in the world of cybersecurity #100DaysOfCybersecurity #Cybersecurity @Cyblackorg
Day 4 still on subqueries but intermediate subqueries, will try again tomorrow and also master level subqueries The more I practice the more I learn and understand SQL in general The main thing about subqueries to me is understanding how to analyse the question
United States Trends
- 1. Colts 13.5K posts
- 2. #HardRockBet 4,067 posts
- 3. Arsenal 299K posts
- 4. Jameis 3,744 posts
- 5. Tottenham 96.6K posts
- 6. Mason Rudolph 3,537 posts
- 7. Nahshon Wright N/A
- 8. #ARSTOT 18.5K posts
- 9. #HereWeGo 2,463 posts
- 10. #GoPackGo 2,213 posts
- 11. Thomas Frank 8,851 posts
- 12. #ChiefsKingdom 2,024 posts
- 13. Go Birds 8,424 posts
- 14. DJ Moore N/A
- 15. Latu 1,315 posts
- 16. Richarlison 11.5K posts
- 17. Emanuel Wilson 1,063 posts
- 18. Merino 21.3K posts
- 19. Klay 44.6K posts
- 20. Raya 18.6K posts
Something went wrong.
Something went wrong.