#30DaysOfSQL

Day 15 & 16/30 💻 Today, I watched my tutor’s YouTube @ezekiel_aleke video on SQL "JOINS" and read about "NULL" values on W3Schools. One step at a time! 📊❤️ #30DaysOfSQL #SQL #DataAnalytics

Day 9/30 💻 Today, I learned SQL "CASE" statements: "WHEN" checks a condition, "THEN" gives the result, "ELSE" gives an alternative, and "END" closes the statement. One step at a time! 📊✨ #30DaysOfSQL #SQL

Day 10/30 💻 Today, I studied SQL operators on W3Schools: "=", ">", "<", ">=", "<=", "<>", "BETWEEN", "LIKE" & "IN". I also read about "ORDER BY", "ASC" & "DESC" before practicing. Read, learn, practice! 📊 W3Schools is a great resource. Give it a try! #30DaysOfSQL #SQL

Day 17/30 💻 Today, I practiced "IS NULL" and "COUNT()" to find customers with missing job values and count how many there are. I was exhausted and couldn’t meet up yesterday, but we move again this week 🥹❤️ Keep showing up. Jesus loves you! 🙏🏽 #30DaysOfSQL #DataAnalytics

Day 14/30 💻 Today was busy, and I honestly didn’t feel like doing much. 😩 But I still went back to read "GROUP BY", "HAVING" & "ORDER BY" on W3Schools for a clearer understanding. Consistency isn’t easy, but we keep showing up! One day at a time. ❤️ #30DaysOfSQL #SQL

🚨 30 Days of SQL 🚨 I’m learning SQL from scratch and documenting my journey for the next 30 days. 💻📊 I’ve learnt it before with my tutor @ezekiel_aleke ,but I’m learning it again to build stronger understanding. Join me if you’re learning too! 🤝🏽 #30DaysOfSQL #SQL

Day 8/30 💻 Today, I revised SQL basics on W3Schools, learned more about semicolons, and took a quiz — got everything right! 🎯 Learning isn’t just about practicing; reading and researching matter too. Keep showing up and stay consistent! 📊❤️ #30DaysOfSQL #SQL #DataAnalytics

Day 6/30 💻 Busy day, so I didn’t get much studying done. 😭 But I updated my SQL Server and discovered new features like Copilot, Vector, Regex & AI. 🤖 Haven’t updated yours? This is your sign! Keep upgrading your skills. 📊✨ #30DaysOfSQL #SQL

Day 2/30 💻 Today I learnt "INSERT INTO", "VALUES", "WHERE", "UPDATE", "SET", "DELETE" & "BETWEEN". Learning with AI, my tutor’s videos @ezekiel_aleke & W3Schools. 📊 #30DaysOfSQL #SQL #DataAnalytics

New driver activation, one query : WITH first_ride AS ( SELECT driver_id, MIN(ride_date) d FROM rides GROUP BY driver_id) Find drivers riding within days of signup 🚗 Day of SQL Interviews #SQL #30DaysOfSQL

Day 25 of #30DaysOfSQL I learned how powerful PARTITION BY is in SQL Server. Unlike GROUP BY, it keeps all rows while adding totals and insights. Example: show each employee’s salary + total salary of their department

Day 3/30 💻 Today was stressful and busy, but I still showed up. I learnt "ORDER BY", "AND", "OR" & "LIKE". Just showing up makes a whole lot of difference. Stay consistent, even on your hardest days. ❤️ Hope this encourages someone today. ✨ #30DaysOfSQL #SQL

Day 14 of #30DaysOfSQL Today I learned Subqueries → queries inside queries. Think of it as: “Find X, then use X to find Y.”🧵

Day 15/30 💻❤️ Sorry, guys, I couldn’t post yesterday, but we move again today! 🥹 Hope everyone is doing well. Have a happy and blessed day, and remember, Jesus loves you! ❤️🙏🏽 #30DaysOfSQL #SQL

Day 15 of My #30DaysOfSQL Today I played with EXISTS clause. Perfect for checking if a related record exists without joining tables. Today's Task : Show all films that have at least 1 inventory copy. #SQL #MySQL #datafam #LearnSQL #TechTwitter #TechAfrica #TechTrends

🚀 Day 1/30 of my #30DaysOfSQL challenge! Today I practiced (#175 & #181 on LeetCode) writing complex JOIN queries to combine data across multiple tables. #SQL #Database #LearningInPublic #30DayChallenge #LeetCode

Day 21 of My #30DaysOfSQL Today I explored the RANK() function. I ranked films by their rental duration within each category. Task: Rank films by rental rate within each category. #SQLChallenge #MySQL #LearnSQL #DataAnalytics #Sakila #SQLTips #TechTwitter #TechTips #TechTrends

Day 11 Today, I learnt how to manage tables using constraints in SQL (Not Null, Default, Check, Unique) In simple terms, constraints help maintain consistent, valid, and high-quality data, which is crucial for robust database management and meaningful data analysis #30DaysOfSQL

Day 20 of My #30DaysOfSQL Today I explored Window Functions. I used ROW_NUMBER() to rank films by rental duration within each category. Task : Rank all film in its category and give each a unique number, ignore ties. #SQL #MySQL #DataAnalytics #DataScience #datafam #TechTwitter

Day 5 of my #30DaysOfSQL challenge Today I played with the LIKE operator . It is super useful for searching patterns in text. Today's Task: Get all film titles that start with "A" #SQLChallenge #MySQL #LearnSQL #DataAnalytics #Sakila #SQLTips #TechTwitter #TechTips #TechTrends