❤️ 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 theJOIN
and matching rows for the table on the right side ofJOIN
. -
RIGHT JOIN
- returns all the rows of the table on the right side of theJOIN
and matching rows for the table on the left side ofJOIN
. -
FULL JOIN
- creates the result-set by combining result of bothLEFT JOIN
andRIGHT JOIN
. The result-set will contain all the rows from both the tables.
-
- continued Colt Steele's MySQL course.
Scrum
- finished reading 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!
Top comments (2)
Happy Valentine's Day!
Happy Valentine's Day to you as well!