Day 98 of 100 Days of Code & Scrum: SQL Sunday
Tags: javascript, webdev, beginners, 100daysofcode
Published: 2022-02-13 12:07:53

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`, and `TIMESTAMP`.
- 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](https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/).

### Scrum

- continued reading through [An Introduction to the Nexus Framework](https://scrumorg-website-prod.s3.amazonaws.com/drupal/2016-06/An%20Introduction%20to%20the%20Nexus%20Framework%20-%20June%202016_0.pdf).

Thank you for reading! Have a good day!

![Rammina Thank You Banner](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/x9ayfxxxaz2g2hfcqbsk.png)

## Resources/Recommended Readings

- [The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert](https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/)
- [The 2020 Scrum Guide](https://scrumguides.org/scrum-guide.html)
- [An Introduction to the Nexus Framework](https://scrumorg-website-prod.s3.amazonaws.com/drupal/2016-06/An%20Introduction%20to%20the%20Nexus%20Framework%20-%20June%202016_0.pdf)

## 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!

<hr />

## Other Media

Feel free to reach out to me in other media!

<span><a target="_blank" href="https://www.rammina.com"><img src="https://res.cloudinary.com/rammina/image/upload/v1638444046/rammina-button-128_x9ginu.png" alt="Rammina Logo" width="128" height="50"/></a></span>

<span><a target="_blank" href="https://twitter.com/RamminaR"><img src="https://res.cloudinary.com/rammina/image/upload/v1636792959/twitter-logo_laoyfu_pdbagm.png" alt="Twitter logo" width="128" height="50"/></a></span>

<span><a target="_blank" href="https://github.com/Rammina"><img src="https://res.cloudinary.com/rammina/image/upload/v1636795051/GitHub-Emblem2_epcp8r.png" alt="Github logo" width="128" height="50"/></a></span>