An Interest In:
Web News this Week
- April 23, 2024
- April 22, 2024
- April 21, 2024
- April 20, 2024
- April 19, 2024
- April 18, 2024
- April 17, 2024
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!
Yesterday
I practiced utilizing aggregate functions in MySQL and learned more about the Nexus framework.
Today
MySQL
- I learned about more datatypes in SQL and their use cases such as
CHAR
,DECIMAL
,FLOAT
,DOUBLE
,DATE
,TIME
,DATETIME
, andTIMESTAMP
. - practiced various
DATETIME
utility functions such as:DATE_FORMAT
NOW()
CURDATE()
CURTIME()
DAY
DAYNAME
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.
Scrum
- continued reading through An Introduction to the Nexus Framework.
Thank you for reading! Have a good day!
Resources/Recommended Readings
- The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
- The 2020 Scrum Guide
- An Introduction to the Nexus Framework
DISCLAIMER
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!
Original Link: https://dev.to/rammina/day-98-of-100-days-of-code-scrum-sql-sunday-km6
Dev To
An online community for sharing and discovering great ideas, having debates, and making friendsMore About this Source Visit Dev To