❤️ 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!
Grinded real hard learning about more complex data types,
DATETIME utility functions, and logical operators in MySQL.
- practiced using SQL
JOINto generate meaningful data by combining multiple relational tables.
- reviewed the different types of
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
JOINand matching rows for the table on the right side of
RIGHT JOIN- returns all the rows of the table on the right side of the
JOINand matching rows for the table on the left side of
FULL JOIN- creates the result-set by combining result of both
RIGHT JOIN. The result-set will contain all the rows from both the tables.
- continued Colt Steele's MySQL course.
- finished reading An Introduction to the Nexus Framework.
Thank you for reading! Have a good day!
- The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert
- The 2020 Scrum Guide
- An Introduction to the Nexus Framework
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!