Day 99 of 100 Days of Code & Scrum: Relationships Between Tables, Various JOIN Types in MySQL
Tags: 100daysofcode, javascript, beginners, webdev
Published: 2022-02-14 11:44:54

❤️ Happy Valentine's Day, everyone! ❤️

I love coding, so it's my Valentine, and I have been doing just that the entire day. Jokes aside, I took a relatively easy day today, spending time with my loved ones and having a bit of fun. Coding may be enjoyable, but I didn't want to grind all day on a special occasion.

Moving on, I reviewed various types of table **_relationships_** and the different types of JOINs, just so that I have a clearer understanding of them. Honestly, it's going to take me some time to intuitively understand when to use one over the others, but I suppose I should just practice more.

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

## Yesterday

Grinded real hard learning about more complex data types, `DATETIME` utility functions, and logical operators in MySQL.

## Today

### MySQL

- practiced using SQL `JOIN` to generate meaningful data by combining multiple relational tables.
- reviewed the different types of `JOIN`s:
  - `INNER JOIN` - INNER JOIN keyword selects all rows from both the tables as long as the condition is satisfied.
  - `LEFT JOIN` - returns all the rows of the table on the left side of the `JOIN` and matching rows for the table on the right side of `JOIN`.
  - `RIGHT JOIN` - returns all the rows of the table on the right side of the `JOIN` and matching rows for the table on the left side of `JOIN`.
  - `FULL JOIN` - creates the result-set by combining result of both `LEFT JOIN` and `RIGHT JOIN`. The result-set will contain all the rows from both the tables.
- continued [Colt Steele's MySQL course](https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/).

### Scrum

- finished reading [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>