Hello there, everyone!

TIL, SQL index starts with 1, not with 0. I'm really surprised at this fact, because I'm way too used to counting starting from 0 when programming. I find myself easily thrown off when mentally calculating index-related stuff in SQL, because of 1-based index. Either way, it's just something I need to take into account.

That aside, I spent most of my free time today learning string-related functions in MySQL. I didn't learn all of the functions in the MySQL string functions documentation, but I familiarized them. What I focused on were the most commonly used string functions.

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

Yesterday

I did basic CRUD practice exercises in MySQL to get more used to them.

Today

MySQL

• I learned how to utilize the most commonly used string functions in MySQL such as:
  • CONCAT - concatenates multiple strings together.
  • UPPER - converts a string to uppercase.
  • LOWER - converts a string to lowercase.
  • REVERSE - reverses the order of characters in a string.
  • REPLACE - takes in a string, and replaces substring with another substring.
  • SUBSTRING - retrieves a substring from a string, starting and ending indices can be selected.
  • CHAR_LENGTH - returns the number of characters in a string.
• skimmed through MySQL string functions documentation.
• 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!