DEV Community

Cover image for Day 98 of 100 Days of Code & Scrum: SQL Sunday

Posted on


Day 98 of 100 Days of Code & Scrum: SQL Sunday

Happy weekend, everyone!

Today, I spent most of the day learning MySQL. I dived deeper into various data types in SQL as well as their respective functions. Also, I learned about how logical operators in MySQL work, which isn't that different from how they work in other programming languages. One interesting thing I noticed is that string comparison in SQL is not case sensitive.

Anyway, let's move on to my daily report!


I practiced utilizing aggregate functions in MySQL and learned more about the Nexus framework.



  • I learned about more datatypes in SQL and their use cases such as CHAR, DECIMAL, FLOAT, DOUBLE, DATE, TIME, DATETIME, and TIMESTAMP.
  • practiced various DATETIME utility functions such as:
    • NOW()
    • CURDATE()
    • CURTIME()
    • DAY
    • DATE_ADD
    • DATE_SUB and more...
  • learned about logical operators in MySQL, the common ones and interesting ones like BETWEEN, LIKE, IN, and more.
  • practiced using CASE statements for conditionally returning different values based on conditions.
  • continued Colt Steele's MySQL course.


Thank you for reading! Have a good day!

Rammina Thank You Banner

Resources/Recommended Readings


This is not a guide, it is just me sharing my experiences and learnings. This post only expresses my thoughts and opinions (based on my limited knowledge) and is in no way a substitute for actual references. If I ever make a mistake or if you disagree, I would appreciate corrections in the comments!

Other Media

Feel free to reach out to me in other media!

Rammina Logo

Twitter logo

Github logo

Top comments (0)

The Complete Guide to Full Stack Web3 Development

The most important tools, protocols, and frameworks for building full stack web3 apps, and most importantly - how to put everything together to lay the groundwork for building out any of your own ideas in the future.