DEV Community

Cover image for Day 84 of 100 Days of Code & Scrum: SQL Reads Like English
Rammina
Rammina

Posted on

Day 84 of 100 Days of Code & Scrum: SQL Reads Like English

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. 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, learning Next.js, SQL basic concepts, and MySQL.

Today

Next.js

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

Thank you for reading! Have a good day!

Rammina Thank You Banner

Resources/Recommended Readings

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!

Rammina Logo

Twitter logo

Github logo

Discussion (0)