Day 84 of 100 Days of Code & Scrum: SQL Reads Like English
Tags: javascript, 100daysofcode, productivity, beginners
Published: 2022-01-21 11:38:53

Hello there, everyone!

Just one thing I will say first: Coding with SQL feels like I'm just writing in English. Anyway, I spent most of my time today learning SQL and going through [SQLZoo's SQL Tutorial](https://sqlzoo.net/wiki/SQL_Tutorial). I like this resource because it teaches the concepts in a problem-solving type of way in which you have to retrieve certain data from a table.

Other than that, I also continued to learn about Next.js, specifically about writing dynamic API endpoints.

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

## Yesterday

I did various things, such as deploying the updates for my [company website](https://www.rammina.com), learning Next.js, SQL basic concepts, and MySQL.

## Today

### Next.js

- practiced writing dynamic APIs for Next.js.
- continued going through [Next.js & React by Maximilian Schwarzmüller](https://www.udemy.com/course/nextjs-react-the-complete-guide/).

### SQL

- practiced selecting attributes to be retrieved from a table (SELECT and FROM).
- learned how to:
  - filter records using WHERE.
  - combine multiple filter conditions using AND, OR, and the use of () to nest conditions.
  - use IN the specify multiple values in a list when using WHERE clause, and the fact that it is just a shorthand for multiple OR.
  - utilize LIKE in a WHERE clause to search for a specified pattern in a column.
    - `%` represents zero, one, or more characters.
    - `_` represents one single character.
  - escape single quotes.

### Scrum

- read this article, titled [Scrum from the trenches - the Sprint Goal by Jasper Alblas](https://www.scrum.org/resources/blog/scrum-trenches-sprint-goal).

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

- [Next.js & React by Maximilian Schwarzmüller](https://www.udemy.com/course/nextjs-react-the-complete-guide/)
- [Next.js official documentation](https://nextjs.org/docs/getting-started)
- [SQLZoo's SQL Tutorial](https://sqlzoo.net/wiki/SQL_Tutorial)
- [Scrum from the trenches - the Sprint Goal by Jasper Alblas](https://www.scrum.org/resources/blog/scrum-trenches-sprint-goal)
- [The 2020 Scrum Guide](https://scrumguides.org/scrum-guide.html)

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